ExcelImportPreference

Excel import preferences.

Objects:

AlignmentStyle, Boolean, Number, Object, String, TableFormatting

Property Listing

Property

Type

Access

Description

alignmentStyle

AlignmentStyle

AlignmentStyle.CENTER_ALIGN

AlignmentStyle.LEFT_ALIGN

AlignmentStyle.RIGHT_ALIGN

AlignmentStyle.SPREADSHEET

read/write

The cell alignment for the imported document.

decimalPlaces

Number

read/write

The number of decimal places to include. Note: Valid only when alignment style is decimal.

errorCode

Number

read/write

The import error code. (Key: 0=Success; 1=Empty Sheet; 2=Invalid sheet; 3=Invalid range; 4=Invalid View; 5=Misc. Error)

parent

Application

readonly

The parent of the ExcelImportPreference (a Application).

properties

Object

read/write

A property that allows setting of several properties at the same time.

rangeName

String

read/write

The range of cells to import. Note: Use a colon (:) to separate the start and end cell names in the range.

sheetIndex

Number

read/write

The worksheet's index. For information, see sheet name.

sheetName

String

read/write

The worksheet to import.

showHiddenCells

Boolean

read/write

If true, shows hidden cells.

tableFormatting

TableFormatting

TableFormatting.EXCEL_FORMATTED_TABLE

TableFormatting.EXCEL_UNFORMATTED_TABBED_TEXT

TableFormatting.EXCEL_UNFORMATTED_TABLE

read/write

The format for imported spreadsheets.

viewName

String

read/write

The stored custom or personal view(s) to import with the file.

Object of

Application.excelImportPreferences