![]() That way it would be apparent if the Azure app connected via Graph lacks "owner" status and perhaps that my worksheet sharing grant on the azure app owner email address isn't "enough" for the azure app to get its job done, adding rows to a protected worksheet where "add rows" is set as being permitted. I think this functionality does not exist and/or does not work, but maybe my azure app identity as seen by Excel isn't the Excel sheet owner? If that's the case, my idea submission here will be for the 403 forbidden response, or maybe "access denied" log on the Excel side, to report attempted accesse where permission was denied, and to supply the attempted credential. ![]() ![]() I just want the owner to be able to add rows, and for humans the workbook file is shared with, they need to be able to work on other worksheets to do their pivot tables and whatever all else, using the data worksheet as their source, but never being able to change the data worksheet. "Excel only" is a requirement I have to work with) (While i realize a database would be the preferred method for this scenario, with Excel reading its worksheet table data from the database, I don't get to make that call. My goal here is to all the Azure App and Office Business owner to add rows to a worksheet of defined structure, and to prevent humans from breaking the structure and thus breaking the app. Turning worksheet protection back off, the azure app resumse inserting rows just fine. Soon as worksheet protection is enabled, the azure app gets 403 forbidden when it attempts to add a row. I invite "myself" for sharing, using the e-mail address that is the Office 365 Business license owner and also the Azure app owner. I enable protection and tick the "add rows" box to allow rows being added. My Azure account was created by the same user (email address) as my Office 365 Business Basic account (the one that is currently $6/month), so Excel ought to see my row being inserted by the Workbook owner. This works fine, adding rows as needed, right up till I turn on worksheet protection for this worksheet. Such functions work by returning a special flow control data type, which is also not described in this documentation.I'm using an Azure web app to add a row to an Excel workbook worksheet table. The SDK documentation contains the following sections:ĭeveloping user-defined functions and commands in Excel macro (XLM) sheets.Ĭreating user-defined functions in DLLs that control the flow of execution of an XLM macro. These sample projects provide examples and they serve as a starting point for your own add-in development. Microsoft Visual Studio projects-Includes C/C++ source code and shows how to use the C API. The Excel 2013 XLL SDK includes the following:Ĭ application programming interface (API)-Includes header and source files that enable DLLs to access Excel 2013 functionality, and a description of the interface that a DLL should expose to work with the Excel Add-in Manager. 3 With Microsoft 365 you get the full, installed Office experience on PCs, Macs, tablets (including iPad® and Android tablet) and phones. ![]() This reference contains conceptual overviews, programming tasks, and samples to help you develop Microsoft Excel 2013 XLLs. Microsoft 365 plans include premium versions of these applications plus other services that are enabled over the Internet, including online storage with OneDrive and Skype minutes for home use. Welcome to the Excel 2013 XLL Software Development Kit (SDK) documentation. Applies to: Excel 2013 | Office 2013 | Visual Studio
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |