ExcelImportPreference

Excel import preferences.

Methods:

getElements, toSource, toSpecifier

Objects:

AlignmentStyleOptions, Boolean, Number, Object, String, TableFormattingOptions

Property Listing

Property

Type

Access

Description

alignmentStyle

AlignmentStyleOptions

AlignmentStyleOptions.CENTER_ALIGN

AlignmentStyleOptions.LEFT_ALIGN

AlignmentStyleOptions.RIGHT_ALIGN

AlignmentStyleOptions.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).

preserveGraphics

Boolean

read/write

If true, preserves inline graphics.

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

TableFormattingOptions

TableFormattingOptions.EXCEL_FORMATTED_TABLE

TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXT

TableFormattingOptions.EXCEL_UNFORMATTED_TABLE

read/write

The format for imported spreadsheets.

useTypographersQuotes

Boolean

read/write

If true, convert straight quotes and apostrophes in the imported text to typographic quotation marks and apostrophes.

viewName

String

read/write

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

Method Listing

Object getElements ()

Resolves the object specifier, creating an array of object references.

String toSource ()

Generates a string which, if executed, will return the ExcelImportPreference.

String toSpecifier ()

Retrieves the object specifier.

Object of

Application.excelImportPreferences