Excel import preferences.
Go to Property Listing
AlignmentStyle, Boolean, Number, Object, String, TableFormatting
|
Property |
Type |
Access |
Description |
|---|---|---|---|
|
read/write |
The cell alignment for the imported document. |
||
|
read/write |
The number of decimal places to include. Note: Valid only when alignment style is decimal. |
||
|
read/write |
The import error code. (Key: 0=Success; 1=Empty Sheet; 2=Invalid sheet; 3=Invalid range; 4=Invalid View; 5=Misc. Error) |
||
|
readonly |
The parent of the ExcelImportPreference (a Application). |
||
|
read/write |
A property that allows setting of several properties at the same time. |
||
|
read/write |
The range of cells to import. Note: Use a colon (:) to separate the start and end cell names in the range. |
||
|
read/write |
The worksheet's index. For information, see sheet name. |
||
|
read/write |
The worksheet to import. |
||
|
read/write |
If true, shows hidden cells. |
||
|
read/write |
The format for imported spreadsheets. |
||
|
read/write |
The stored custom or personal view(s) to import with the file. |
Application.excelImportPreferences