excel import preference

Excel import preferences.

excel import preference properties

Property Type Access Description
alignment style alignment style options enumeration r/w Alignment style.
class integer read The class descriptor type.
decimal places integer r/w The number of decimal places.
error code integer r/w Error Code (0-Success 1-Empty Sheet 2-Invalid sheet 3-Invalid range 4-Invalid View
5-Misc. Error).
object reference object read An object reference for this object.
parent object read The parent of the object.
preserve graphics boolean r/w If true, preserve graphics in the Excel document.
properties record r/w Property that allows setting of several properties at the same time.
range name string r/w Name of selected range.
sheet index integer r/w Index of selected sheet.
sheet name string r/w Name of selected sheet.
show hidden cells boolean r/w If true, show hidden cells.
table formatting table formatting options enumeration r/w Table formatting.
use typographers quotes boolean r/w If true, convert straight quotes to typographic quotes.
view name string r/w Name of selected view.

Leave a Comment

Previous post:

Next post: