Provide access to SQL queries through Officejs API for Add-ins
Spreadsheets built for handling financial data need access to the corporate database. Presumably that is why capabilities are provided within Excel to define and execute SQL queries within the context of a workbook/worksheet.The role of an Add-in to provide a whole host of capabilities to the workbook author cannot be overstated. Yet OfficeJS Excel API seem to be lacking the ability to define, access, and execute the aforementioned queries. Are there any plans in the works to provide the capabilities?
The lack of this capability particularly affects 3rd party add-in providers who cannot otherwise access a customer's corporate database.