Microsoft Excel Online コネクタを追加
Microsoft Excel Online への認証
After you add the connector, you need to set the required properties. CData Sync supports authenticating to Microsoft Excel Online in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.- Azure Active Directory (default)
- Azure Managed Service Identity
- Azure Service Principal
- Azure Service Principal Certificate
Azure Active Directory
Azure Managed Service Identity
Azure Service Principal
Azure Service Principal Certificate
接続を完了する
To complete your connection:- Specify the following properties:
- Workbook: Enter the name or identifier (Id) of your Microsoft Excel Online.
- Drive: Enter the Id of the drive that you want to use.
- Include SharePoint Sites: Select whether you want to retrieve drives for all Microsoft SharePoint sites when you query the Drives view. By default, the Enable checkbox is not selected.
- Show Shared Documents: Select whether you want to show shared documents. By default, the Enable checkbox is not selected.
- Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
- Connect to Microsoft Excel Online to connect to your Microsoft Excel Online account.
- Click Create & Test to create your connection.