> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft SharePoint Excel

CData Sync アプリケーションからMicrosoft SharePoint Excel コネクタを使用して、Microsoft SharePoint Excel からデータを取得してサポートされている任意の同期先に移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。

## Microsoft SharePoint Excel コネクタを追加

Sync でMicrosoft SharePoint Excel のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります：

<ol>
  <li>Sync のダッシュボードから**接続**ページを開きます。</li>
  <li>**接続を追加**をクリックして**コネクタを選択**ページを開きます。</li>
  <li>**データソース**タブをクリックして
  **Microsoft SharePoint Excel** 行に移動します。</li>

  <li>
    行末にある**接続を設定**アイコンをクリックして、**新しい接続**ページを開きます。この操作により、
    **接続を追加**ダイアログボックスが開きます。

    **Note：** **接続を設定**アイコンが表示されない場合は、**コネクタをダウンロード**アイコンをクリックして Microsoft SharePoint Excel コネクタをインストールしてください。
  </li>

  <li>**接続を追加**ダイアログボックスに接続名を入力します。</li>
  <li>**追加**をクリックして、コネクタの**設定**タブを開きます。</li>
</ol>

新しいコネクタのインストールについての詳細は、
[接続](https://docs.sync.cdata.com/26.4/ja/connections/connections.md)を参照してください。

## Microsoft SharePoint Excel への認証

After you add the connector, you need to set the required properties.

* **URL:** Enter the base URL for a site or site collection.
* **File:** Enter the name of the Microsoft Excel workbook to which you want to connect.

CData Sync supports authenticating to Microsoft SharePoint Excel in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**NTLM**](#ntlm) (default)
* [**Basic**](#basic)
* [**Digest**](#digest)
* [**Forms**](#forms)
* [**None**](#none)
* [**Negotiate**](#negotiate)
* [**Active Directory Federation Services**](#active-directory-federation-services-adfs)

### NTLM

To connect with NTLM user credentials, specify the following properties:

* **Auth Scheme:** Select **NTLM**.
* **User:** Enter the username that you use to authenticate to the Microsoft server.
* **Password:** Enter the password that you use to authenticate to the Microsoft server.

### Basic

To connect with your user credentials, specify the following properties:

* **Auth Scheme:** Select **Basic**.
* **User:** Enter the username that you use to authenticate to the Microsoft server.
* **Password:** Enter the password that you use to authenticate to the Microsoft server.

### Digest

To connect with digest-authentication credentials, specify the following properties:

* **Auth Scheme:** Select **Digest**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### Forms

To connect with a custom authentication method, specify the following properties:

* **Auth Scheme:** Select **Forms**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### None

認証なしで接続するには、**Auth Scheme** で**None** を選択します。追加のプロパティは必要ありません。

### Negotiate

To connect with Kerberos credentials, specify the following properties:

* **Auth Scheme:** Select **Negotiate**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### Active Directory Federation Services (ADFS)

To connect with single sign-on (SSO) via ADFS, specify the following properties:

* **Auth Scheme:** Select **ADFS**.
* **User:** Enter the username that you use to authenticate to your ADFS account.
* **Password:** Enter the password that you use to authenticate to your ADFS account.
* **STSURL:** The URL of the security token service (STS).
* **SSO Login URL:** Enter the login URL that is used by your SSO provider.
* **SSO Domain:** Enter the domain of the user.
* **SSO Properties:** Enter additional properties that are required to connect to your identity provider. You must use a semicolon-separated list of properties (for example, *SSOProperty1*=*Value1*;*SSOProperty2*=*Value2*;...).

## 接続を完了する

To complete your connection:

1. Specify the following properties:
   * **SharePoint Version:** Select your version of Microsoft SharePoint from the list. The default version is **SharePoint 2013**.
   * **Folder:** Enter the path to the folder that contains the workbook that you specified earlier for **File**.
   * **Library:** Specify the document library to which you want to connect.
   * **Use RESTAPI:** Select whether you want to use the REST API (instead of the OData API) to retrieve data. By default, the **Enable** checkbox is already selected.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. Click **Create & Test** to create your connection.

## 詳細について


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.