TXlsWorksheetEh Class

TXlsWorksheetEh class contains tabular data for one table.

Tabular data includes:

• Column definition (Properties Columns, DefaultColWidth)

• Defining strings (Properties Rows, DefaultRowHeight)

• Values in Table Cells (Cells Property)

• Format for each cell (Color, Font, Line thickness, etc.) (Via IXlsFileCellsRangeEh interface)

• Define row grouping (Set via the properties Rows, OutlineRowsSummaryBelow)

• Column grouping definition (Set via properties Columns, OutlineColsSummaryRight)

• Print settings (Subproperties properties PrintParams)

• Setting non-scrollable areas (Properties FrozenColCount, FrozenRowCount)

You can get access tp Worksheet from the collection of Worksheets in the Workbook.
Like this:
TXlsMemFileEh.Workbook.Worksheets[Index]

TXlsWorksheetEh class has the following properties:

property Name: String;

Worksheet title. In Excel, the title appears at the bottom of the bookmark list.

property TabColor: TColor;

Table bookmark color.

property AutoFilterRange: TXlsFileWorksheetCellsRectEh;

Auto filter area

property CellDataExists[Col, Row: Integer]: Boolean;

Determine if the TXlsFileCellEh object was created at the specified coordinates.

property Cells[Col, Row: Integer]: TXlsFileCellEh;

Access to table cells with coordinates Col, Row. Coordinates start at zero.

property Columns: TXlsFileColumnsEh;

Page column options.

property DefaultColWidth: Double;

The default column width.

property DefaultRowHeight: Double;

Default line height.

property DefaultRowHeight: Double;

The size of the area that contains nonblank cells

property FrozenColCount: Integer;

The number of columns frozen.

property FrozenRowCount: Integer;

The number of frozen lines.

property OutlineRowsSummaryBelow: Boolean;

The group headers for the columns are below the group. The property is used when grouping strings.

property OutlineColsSummaryRight: Boolean

The row group headers are located to the right of the group. The property is used when grouping columns.

property PrintParams: TXlsFileWorksheetPrintParamsEh;

Print Options: Page Orientation, Header, etc.

property Rows: TXlsFileRowsEh;

Page line options.

property ZoomScale: Integer;

Scaling. Set as a percentage. The default is 100.