ExcelImportPreference
Excel import preferences.
ExcelImportPreference Properties
| Property |
Type |
Access |
Description |
| alignmentStyle |
AlignmentStyleOptions enumeration |
r/w |
Alignment style. |
| decimalPlaces |
Long |
r/w |
The number of decimal places. |
| errorCode |
Long |
r/w |
Error Code (0-Success 1-Empty Sheet 2-Invalid sheet 3-Invalid range 4-Invalid View 5-Misc. Error). |
| parent |
Object |
read |
The parent of the object. |
| preserveGraphics |
Boolean |
r/w |
If true, preserve graphics in the Excel document. |
| properties |
An array of property names and values |
r/w |
Property that allows setting of several properties at the same time. |
| rangeName |
String |
r/w |
Name of selected range. |
| sheetIndex |
Long |
r/w |
Index of selected sheet. |
| sheetName |
String |
r/w |
Name of selected sheet. |
| showHiddenCells |
Boolean |
r/w |
If true, show hidden cells. |
| tableFormatting |
TableFormattingOptions enumeration |
r/w |
Table formatting. |
| useTypographersQuotes |
Boolean |
r/w |
If true, convert straight quotes to typographic quotes. |
| viewName |
String |
r/w |
Name of selected view. |
ExcelImportPreference Methods
| Method |
Returns |
Description |
| getElements |
Array of Objects |
Resolve the object specifier. |
| toSource |
String |
Generate JavaScript source that, if executed, will return the specified objects. |
| toSpecifier |
String |
Retrieve the object specifier. |
Previous post: FindPreference
Next post: EPSs