43
Properties
Name
Type
Description
columns
WorkbookColumn[]
Gets or sets an array of sheet columns definitions.
Each WorkbookColumn object in the array describes a column at the
the
corresponding position in xlsx sheet, i.e. the column with index 0 corresponds to
xlsx sheet column with index A, object with index 1 defines sheet column with
index B, and so on. If certain column has no description in xlsx file then
corresponding array element is undefined for both export and import operations.
If WorkbookColumn object in the array doesn't specify the width property
operty
value then the default column width is applied.
F frozenPane
WorkbookFrozenPane
Gets or sets the WorkbookFrozenPane settings.
F name
string
Gets or sets the sheet name.
rows
WorkbookRow[]
Gets an array of sheet rows definition.
Each WorkbookRow object in the array describes a row at the corresponding
ing
position in xlsx sheet, i.e. the row with index 0 corresponds to xlsx sheet row
with index 1, object with index 1 defines sheet row with index 2, and so on. If
certain row has no properties and data in xlsx file then corresponding array
element is undefined for both export and import operations.
If WorkbookRow object in the array doesn't specify the height property value
y value
then the default row height is applied.
F summaryBelow
boolean
Gets or sets a value indicating whether summary rows appear below or above
detail rows.
F visible
boolean
Gets or sets the worksheet visibility.
ITableAddress Class
Module