Excel import preferences.
excel import preference Properties
| Property | Type | Access | Description |
|---|---|---|---|
| alignment style | spreadsheet, left align, right align, center align, |
r/w | The cell alignment for the imported document. |
| class | type | read | The class descriptor type. |
| decimal places | integer | r/w | The number of decimal places to include. Note: Valid only when alignment style is decimal. |
| error code | integer | r/w | The import error code. (Key: 0=Success; 1=Empty Sheet; 2=Invalid sheet; 3=Invalid range; 4=Invalid View; 5=Misc. Error) |
| object reference | excel import preference | read | An object reference for the object. |
| parent | specifier | read | The parent of the excel import preference (a application). |
| preserve graphics | boolean | r/w | If true, preserves inline graphics. |
| properties | record | r/w | A property that allows setting of several properties at the same time. |
| range name | text | r/w | The range of cells to import. Note: Use a colon (:) to separate the start and end cell names in the range. |
| sheet index | integer | r/w | The worksheet’s index. For information, see sheet name. |
| sheet name | text | r/w | The worksheet to import. |
| show hidden cells | boolean | r/w | If true, shows hidden cells. |
| table formatting | excel formatted table, excel unformatted table, excel unformatted tabbed text, excel format only once, |
r/w | The format for imported spreadsheets. |
| use typographers quotes | boolean | r/w | If true, convert straight quotes and apostrophes in the imported text to typographic quotation marks and apostrophes. |
| view name | text | r/w | The stored custom or personal view(s) to import with the file. |