> ## 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

export const CommonDatasourceMoreInformation = ({datasource = "the data source", advancedurl = "", siteName = "CData Sync", driverVersion = ""}) => {
  return <>
      <p>
        {siteName} と{datasource} の連携について、詳しくは{' '}
        <a href={`https://cdn.cdata.com/help/${advancedurl}${driverVersion}/jp/synch/default.htm`}>
          {datasource} Connector for {siteName}
        </a> を参照してください。
      </p>
    </>;
};

export const CommonAuthSchemeNone = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>認証なしで接続するには、<strong>Auth Scheme</strong> で<strong>None</strong> を選択します。追加のプロパティは必要ありません。</p>
    </>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        {siteNameShort} で{datasource} のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります：
      </p>
      <ol>
        <li>{siteNameShort} のダッシュボードから<strong>接続</strong>ページを開きます。</li>
        <li><strong>接続を追加</strong>をクリックして<strong>コネクタを選択</strong>ページを開きます。</li>
        <li>
          <strong>{destination ? "同期先" : "データソース"}</strong>タブをクリックして
          <strong>{title}</strong> 行に移動します。
        </li>
        <li>
          行末にある<strong>接続を設定</strong>アイコンをクリックして、<strong>新しい接続</strong>ページを開きます。この操作により、{' '}
          <strong>接続を追加</strong>ダイアログボックスが開きます。
          <br />
          <strong>Note：</strong> <strong>接続を設定</strong>アイコンが表示されない場合は、<strong>コネクタをダウンロード</strong>アイコンをクリックして {title} コネクタをインストールしてください。
        </li>
        <li><strong>接続を追加</strong>ダイアログボックスに接続名を入力します。</li>
        <li><strong>追加</strong>をクリックして、コネクタの<strong>設定</strong>タブを開きます。</li>
      </ol>
      <p>
        新しいコネクタのインストールについての詳細は、{' '}
        <a href="../connections">接続</a>を参照してください。
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      {siteName} アプリケーションから{datasource} コネクタを使用して、{datasource} からデータを取得してサポートされている任意の同期先に移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Microsoft SharePoint Excel";
export const pageTitle = "Microsoft SharePoint Excel";
export const advancedurl = "DT";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

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

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## 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.

{siteName} supports authenticating to {datasource} 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

<CommonAuthSchemeNone siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

### 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.

## 詳細について

<CommonDatasourceMoreInformation datasource={datasource} advancedurl={advancedurl} siteName={siteName} driverVersion={driverVersion} />