Class

ExcelImportPreference

 Excel import preferences. Base Class: Preference

QuickLinks

getElements, toSource, toSpecifier

Hierarchy

Application

Preference

ExcelImportPreference

Properties

Property	Type	Access	Description
alignmentStyle	AlignmentStyleOptions: AlignmentStyleOptions.SPREADSHEET AlignmentStyleOptions.LEFT_ALIGN AlignmentStyleOptions.RIGHT_ALIGN AlignmentStyleOptions.CENTER_ALIGN	r/w	The cell alignment for the imported document.
decimalPlaces	number	r/w	The number of decimal places to include. Note: Valid only when alignment style is decimal.
errorCode	number	r/w	The import error code. (Key: 0=Success; 1=Empty Sheet; 2=Invalid sheet; 3=Invalid range; 4=Invalid View; 5=Misc. Error)
isValid	bool	readonly	Returns true if the object specifier resolves to valid objects.
parent	Application	readonly	The parent of the ExcelImportPreference (a Application).
preserveGraphics	bool	r/w	If true, preserves inline graphics.
properties	Object	r/w	A property that allows setting of several properties at the same time.
rangeName	string	r/w	The range of cells to import. Note: Use a colon (:) to separate the start and end cell names in the range.
sheetIndex	number	r/w	The worksheet's index. For information, see sheet name.
sheetName	string	r/w	The worksheet to import.
showHiddenCells	bool	r/w	If true, shows hidden cells.
tableFormatting	TableFormattingOptions: TableFormattingOptions.EXCEL_FORMATTED_TABLE TableFormattingOptions.EXCEL_UNFORMATTED_TABLE TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXT TableFormattingOptions.EXCEL_FORMAT_ONLY_ONCE	r/w	The format for imported spreadsheets.
useTypographersQuotes	bool	r/w	If true, convert straight quotes and apostrophes in the imported text to typographic quotation marks and apostrophes.
viewName	string	r/w	The stored custom or personal view(s) to import with the file.

Methods

Instances

Array of ExcelImportPreference 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.

Element of

Application.excelImportPreferences

Return

Array of ExcelImportPreference ExcelImportPreference.getElements ()

Jongware, 20-Jun-2010 v3.0.3d

Contents :: Index