Microsoft Excel Online

Microsoft Excel Online is part of the Microsoft GraphAPI that works with Excel workbooks, worksheets, tables, charts, and other related objects, and Microsoft GraphAPI also allows you to access other resources of the Microsoft Cloud service.

How to Connect

There are two ways to connect to Microsoft Excel Online: with the help of our support team (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

Usage 

The Microsoft Excel Online connector introduces a new virtual schema excel_online that contains the stored procedures:

In addition to these public API procedures, there is the excel_online_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping excel_online_examples.