データモデルCData ADO.NET Provider for Excel Online 2019J - Build 19.0.7354
Workbooks as Tables
The 本製品 models the worksheets and ranges in your workbooks as bidirectional tables. When you connect, the 本製品 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 本製品 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 システムテーブル to access the available 本製品 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.