Enumeration

TableFormattingOptions

 Formatting options for imported spreadsheets.

Value

NameDescriptionValue
TableFormattingOptions.EXCEL_FORMATTED_TABLEUse formatting from the original spreadsheet.2020361812 = 'xlFT'
TableFormattingOptions.EXCEL_FORMAT_ONLY_ONCEConverts the spreadsheet to a table that is formatted only on initial import but not on update.2017873748 = 'xFOT'
TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXTConvert the spreadsheet to unformatted, tab-delimited text.2018858068 = 'xUTT'
TableFormattingOptions.EXCEL_UNFORMATTED_TABLEConvert the spreadsheet to an unformatted table.2020365652 = 'xlUT'

Usage

As property

ExcelImportPreference.tableFormatting

Jongware, 28-Apr-2012 v3.0.3iContents :: Index