Formatting options for imported spreadsheets.
| Name | Description | Value |
|---|---|---|
| EXCEL_FORMATTED_TABLE | Use formatting from the original spreadsheet. | 2020361812 = ‘xlFT’ |
| EXCEL_UNFORMATTED_TABLE | Convert the spreadsheet to an unformatted table. | 2020365652 = ‘xlUT’ |
| EXCEL_UNFORMATTED_TABBED_TEXT | Convert the spreadsheet to unformatted, tab-delimited text. | 2018858068 = ‘xUTT’ |
| EXCEL_FORMAT_ONLY_ONCE | Converts the spreadsheet to a table that is formatted only on initial import but not on update. | 2017873748 = ‘xFOT’ |
Usage:
- As property:
- ExcelImportPreference.tableFormatting