ExportDataset method - HotXLS Developer Reference

Exports the dataset to new or existing Worksheet.

Syntax

procedure ExportDataset;

procedure ExportDataset(Newsheet: Boolean);

procedure ExportDataset(Newsheet: Boolean; Row, Col: Integer);

Newsheet	Optional Boolean. True - export the dataset to new Worksheet; False - export the dataset to existing Worksheet. Default value is True.
Row	Optional Integer. Row index.
Col	Optional Integer. Column index.

Example

This example creates Example1.xls Workbook with two Worksheets which contain data from Table1 and Table2 datasets.

begin
  DataToXLS1.Workbook := nil; //Clears Workbook

  //First dataset
  DataToXLS1.WorksheetName := 'Table1 sheet'; //Specifies the name for first Worksheet
  DataToXLS1.Dataset := Table1; //Specifies the dataset for export
  DataToXLS1.ExportDataset;

  //Second dataset
  DataToXLS1.WorksheetName := 'Table2 sheet'; //Specifies the name for second Worksheet
  DataToXLS1.Dataset := Table2; //Specifies the dataset for export
  DataToXLS1.ExportDataset;

  DataToXLS1.SaveAs('Example1.xls'); //Saves the created Workbook into Example1.xls file
end;

This example creates Example2.xls Workbook with one Worksheets which contain data from Table1 and Table2 datasets.