Excel
This page describes the Excel-specific properties that appear in the Properties tab of Source and Target gems. These settings are the same for Excel files regardless of which connection type is configured in the gem (for example, S3, SFTP, or SharePoint).
If you need details on configuring a Source or Target gem end to end (including all tabs such as Location), see the documentation for the specific file storage 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.
Properties
Source properties
The following properties are available for the Excel Source gem.
| 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. | 2006-01-02 |
| Time Format Reference | Time format to use when parsing time values. | 15:04:05 |
| Timestamp Format Reference | Timestamp format to use when parsing date-time values. | 2006-01-02 15:04:05 |
| Inference Data Sampling Limit | Maximum number of rows to sample for inferring the schema. | 0 |
| Password | Password for password-protected sheets. | None |
Target properties
The following properties are available for the Excel Target gem.
| 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 |