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. |
This example creates Example1.xls workbook with two worksheets which contain data from Table1 and Table2 datasets.
begin
Dataset2Excel1.Workbook := nil; //Clears workbook
//First dataset
Dataset2Excel1.WorkSheetName := 'Table1 sheet'; //Specifies the name for first worksheet
Dataset2Excel1.Dataset := Table1; //Specifies the dataset for export
Dataset2Excel1.ExportDataset;
//Second dataset
Dataset2Excel1.WorkSheetName := 'Table2 sheet'; //Specifies the name for second worksheet
Dataset2Excel1.Dataset := Table2; //Specifies the dataset for export
Dataset2Excel1.ExportDataset;
Dataset2Excel1.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.
begin
Dataset2Excel1.Workbook := nil; //Clears workbook
Dataset2Excel1.WorkSheetName := 'Table1 and Table2 sheet'; //Specifies the name for worksheet
//First dataset
Dataset2Excel1.Dataset := Table1; //Specifies the dataset for export
Dataset2Excel1.ExportDataset;
//Second dataset
Dataset2Excel1.Dataset := Table2; //Specifies the dataset for export
Dataset2Excel1.ExportDataset(False);
Dataset2Excel1.SaveAs('Example2.xls'); //Saves the created workbook into Example2.xls file
end;
