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