Microsoft Excel¶
The Microsoft Excel connector is a Palantir-provided driver for Microsoft Excel.
To create a new Microsoft Excel source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Microsoft Excel-specific configuration and networking. For the complete property reference, see the official Microsoft Excel driver documentation ↗.
Configuration¶
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
ConnectionType ↗ |
Mandatory | Specifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retrieved. | Local |
SSLMode ↗ |
Mandatory | The authentication mechanism to be used when connecting to the FTP or FTPS server. | IMPLICIT |
URI ↗ |
Mandatory | The Uniform Resource Identifier (URI) for the Excel resource location. | C:\MyExcelWorkbooks\SampleWorkbook.xlsx |
InitiateOAuth ↗ |
Recommended | Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. | REFRESH |
OAuthClientId ↗ |
Recommended | Specifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server. | — |
OAuthClientSecret ↗ |
Recommended | Specifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server. | — |
Networking¶
The table below lists the domains that the source needs to be able to access in order to successfully run.
For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead; the agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.
| Domain | Required |
|---|---|
| graph.microsoft.com | If AzureEnvironment=GLOBAL (default) |
| login.microsoftonline.com | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=GLOBAL |
| microsoftgraph.chinacloudapi.cn | If AzureEnvironment=CHINA |
| login.chinacloudapi.cn | If AuthScheme=AzureAD (default), AzureServicePrincipal , AzureServicePrincipalCert AND AzureEnvironment=CHINA |
| graph.microsoft.us | If AzureEnvironment=USGOVT |
| login.microsoftonline.us | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=USGOVT or USGOVTDOD |
| dod-graph.microsoft.us | If AzureEnvironment=USGOVTDOD |
| \ |
If setting the SharepointURL property |
中文翻译¶
Microsoft Excel¶
Microsoft Excel 连接器是 Palantir 提供的一个用于 Microsoft Excel 的驱动程序。
要创建新的 Microsoft Excel 数据源，请遵循 Palantir 提供驱动程序的标准设置流程，然后使用以下各节进行 Microsoft Excel 特定的配置和网络设置。有关完整的属性参考，请参阅官方 Microsoft Excel 驱动程序文档 ↗。
配置¶
以下属性为必填或推荐项。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
ConnectionType ↗ |
必填 | 指定用于存储和检索 Microsoft Excel 文件的文件存储服务、服务器或文件访问协议。 | Local |
SSLMode ↗ |
必填 | 连接到 FTP 或 FTPS 服务器时使用的身份验证机制。 | IMPLICIT |
URI ↗ |
必填 | Excel 资源位置的统一资源标识符(URI)。 | C:\MyExcelWorkbooks\SampleWorkbook.xlsx |
InitiateOAuth ↗ |
推荐 | 指定获取或刷新 OAuth 访问令牌的过程，该令牌用于在已认证授权用户工作时维持其访问权限。 | REFRESH |
OAuthClientId ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端 ID（也称为消费者密钥）。此 ID 用于在 OAuth 授权服务器上注册自定义应用程序。 | — |
OAuthClientSecret ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端密钥（也称为消费者密钥）。此密钥用于在 OAuth 授权服务器上注册自定义应用程序。 | — |
网络配置¶
下表列出了数据源成功运行所需访问的域名。
对于每个域名，请添加相应的出口策略。如果数据源部署在本地且无法从 Foundry 直接访问，请改用代理出口策略；代理主机本身也必须能够访问所列域名。详情请参阅使用代理作为代理服务器。
| 域名 | 所需条件 |
|---|---|
| graph.microsoft.com | 如果 AzureEnvironment=GLOBAL（默认值） |
| login.microsoftonline.com | 如果 AuthScheme=AzureAD（默认值）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=GLOBAL |
| microsoftgraph.chinacloudapi.cn | 如果 AzureEnvironment=CHINA |
| login.chinacloudapi.cn | 如果 AuthScheme=AzureAD（默认值）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=CHINA |
| graph.microsoft.us | 如果 AzureEnvironment=USGOVT |
| login.microsoftonline.us | 如果 AuthScheme=AzureAD（默认值）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=USGOVT 或 USGOVTDOD |
| dod-graph.microsoft.us | 如果 AzureEnvironment=USGOVTDOD |
| \ |
如果设置了 SharepointURL 属性 |