Excel
Read or write an Excel (XLSX) file from an S3, SFTP, SharePoint, Smartsheet, or Databricks connection.
info
You can also use the upload file feature to use Excel files. These will be stored in the SQL warehouse configured in your fabric.
Parameters
| Parameter | Description |
|---|---|
| Location type | Location you want to connect from. |
| Select or create connection | Whether to select an existing connection, or to create a new one. |
| Filepath | The file path according to the connection type. |
Source properties
| Property | Description | Default |
|---|---|---|
| Description | Description of the table. | None |
| Header | Whether the first row is the column header. | True |
| Allow Undefined Rows | Whether to permit rows with all values undefined (null or empty). | True |
| Allow Incomplete Rows | Whether to permit rows with missing values for some columns. | True |
| Ignore Cell Formatting | Whether to apply the number format for the cell value or get the raw value. | True |
| Sheet Name | Name of the sheet to read from. | None |
| Skip Undefined Rows | Whether to skip rows where all values are undefined. | False |
| Date Format Reference | Date format to use when parsing date values. | None |
| Time Format Reference | Time format to use when parsing time values. | None |
| Timestamp Format Reference | Timestamp format to use when parsing date-time values. | None |
| Inference Data Sampling Limit | Maximum number of rows to sample for inferring the schema. | 0 |
| Password | Password for password-protected sheets. | None |
Target properties
| Property | Description | Default |
|---|---|---|
| Description | Description of the table. | None |
| Header | Whether to make the first row the column header. | True |
| Ignore Cell Formatting | Whether to apply the number format for the cell value or get the raw value. | True |
| Password | Password for password-protected sheets. | None |