Name | Type | Description |
---|---|---|
Rows | TExportRows | Row list in the worksheet. |
Title | OWideString | Worksheet title. Must be unique in the document. |
Header | TExportHeaders | Print header of the worksheet. |
Footer | TExportHeaders | Print footer of the worksheet. |
PageSettings | TExportPageSettings | Page (printer) settings. |
WindowSettings | TExportWindowSettings | Window settings. |
WindowSettings | TExportWindowSettings | Window settings. |
Protection | TExportWorkSheetProtection | Sheet protection information. |
NewCell* are default properties for new created cells: | ||
NewCellStringAlignment | TCellHAlignment | Horizontal alignment of new string cells |
NewCellDateTimeAlignment | TCellHAlignment | Horizontal alignment of new date/time/datetime cells |
NewCellNumberAlignment | TCellHAlignment | Horizontal alignment of new number/percent/formula cells |
NewCellVAlignment | TCellVAlignment | Vertical alignment of new cells |
NewCellFont | TExportFont | Font of new cells |
NewCellBorders | TExportCellBorders | Border of new cells |
NewCellWrapText | Boolean | Word wrap of new cells |
NewCellDateFormat | OWideString | Default date format for date/datetime cells. The default value is your current OExportDateFormat value. |
NewCellTimeFormat | OWideString | Default time format for time/datetime cells. The default value is your current OExportTimeFormat value. |
SaveOnTheFlyOnAddRow | TExportAddRowEvent | This event is called for every row when you use on-the-fly export. |
SaveOnTheFlyRows | Integer | A write-only property you have to define when using on-the-fly export. |
OnTheFlyParam | Pointer | Store a user-definedobject here (e.g. a database query). |
function AddRow: TExportRow; |
---|
Adds a new row in the worksheet. |
function FindCell(const aColIndex, aRowIndex: Integer; out aCell: TExportCell): Boolean; |
Tries to get the cell from a row aRowIndex and column aColIndex. Returns True if cell exists and in this case aCell is set. |
function FindCreateCell(const aColIndex, aRowIndex: Integer; const aCellClass: TExportCellClass): TExportCell; |
Returns the cell from a row aRowIndex and column aColIndex. The cell will be created if it does not exist or transformed to the aCellClass type if the cell is of a different type. |
function FindRow(const aRowIndex: Integer; out aRow: TExportRow): Boolean; |
Tries to get the row with the index aRowIndex. Returns True if cell exists and in this case aRow is set. |
function FindCreateRow(const aRowIndex: Integer): TExportRow); |
Returns the row with the index aRowIndex. If the row doesn't exists, it will be automatically created. |
procedure CalculateColWidthsRowHeights(const aColWidths, aRowHeights: TIntegerList); |
This procedure calculates widths and heights of all cells in the worksheet and saves them in two integer lists. Row heights are calculated also for rows with default height - according to the font size of the cells. |
procedure PositionToCell(const inCol, inColOffset, inRow, inRowOffset: Integer; out outCol, outColOffset, outRow, outRowOffset: Integer); overload; procedure PositionToCell( const aColWidths, aRowHeights: TIntegerList; const inCol, inColOffset, inRow, inRowOffset: Integer; out outCol, outColOffset, outRow, outRowOffset: Integer); overload; |
Calculates position in a worksheet. The input reference cell (inCol, inRow) and
the pixel offsets (inColOffset, inRowOffset) are recalculated as out* parameters.
If you use this function more often, use CalculateColWidthsRowHeights to store aColWidths and aRowHeights. |