ExportToExcel Properties

Defines absolute position (starting cell). If AbsolutePosition.X >= 1 and AbsolutePosition.Y >= 1 then Position and Offset parameters will be ignored and the data will be exported at selected cell.

Draw table borders or not.

Export 1st table column headers or not.

Export 2nd, etc table column headers or not.

Defines direction if more than one object exported.

Export only expanded rows when true.

Returns file filters in format NAME|*.EXT for selected object.

Returns True if Excel installed on this computer.

Defines offset between 2 blocks of data.

Export options: NewWorksheet, AppendToBottom, AppendToRight.

Defines starting position on the new worksheet.

Export 1st table row headers or not.

Export 2nd, etc table row headers or not.

Format grouping rows as splitting the data into multiple columns.

Export style (font and colors) or not. This is a slow method.

Name of the destination worksheet.