Workbooks as Tables
The component models the worksheets and ranges in your workbooks as bidirectional tables. When you connect, the component retrieves the metadata from Excel Online and reflects any changes to the table schemas.
See the Getting Started section for quickstarts to executing SQL to the tables. This section provides additional details on the component behavior.
Stored ProceduresIn addition to working with the data in the workbook, you can use the available stored procedures to access functionality in the Excel Online API that is not modeled as SELECT, INSERT, UPDATE, or DELETE statements; for example, the AddWorksheet stored procedure.
Query the available System Tables to access the available component metadata, including schema information.
1) If you currently have many workbooks or sheets in your account, it may take a long time to initially retrieve all the data. You may shorten this time by adding the Workbook connection property to your connection string.
2) If you will be running a SELECT operation after INSERT or BATCH INSERT then make sure to wait 3-5 seconds before running it. The API takes a few seconds to register all the data you're adding to the database, so waiting is required to avoid partial results.