HotXLS-dokumentation
Indhold
Startside
Oversigt
TGridToXLS
IXLSWorkbook
Startside
Indhold
Oversigt
ExportDataset metode
Exports the dataset to new or existing Worksheet
Syntaks
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
Eksempel
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'; //Angiver the name for first Worksheet
DataToXLS1.Dataset := Table1; //Angiver the dataset for export
DataToXLS1.ExportDataset;
//Second dataset
DataToXLS1.WorksheetName := 'Table2 sheet'; //Angiver the name for second Worksheet
DataToXLS1.Dataset := Table2; //Angiver 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
begin
DataToXLS1.Workbook := nil; //Clears Workbook
DataToXLS1.WorksheetName := 'Table1 and Table2 sheet'; //Angiver the name for Worksheet
//First dataset
DataToXLS1.Dataset := Table1; //Angiver the dataset for export
DataToXLS1.ExportDataset;
//Second dataset
DataToXLS1.Dataset := Table2; //Angiver the dataset for export
DataToXLS1.ExportDataset(False);
DataToXLS1.SaveAs('Example2.xls'); //Saves the created Workbook into Example2.xls file
end;
Copyright © 2010-2026 losLab Software