//Clears Workbook
'Orders sheet' //Nurodo name for new Worksheet
| //Nurodo the This example exports the dataset Table1 into Orders.xls Workbook and Orders.html file for export |
DataToXLS1.SaveDatasetAs( |
//Saves the dataset into Orders.xls
begin
DataToXLS1.Workbook := nil; //Clears Workbook
DataToXLS1.WorksheetName := 'Orders sheet'; //Specifies name for new Worksheet
DataToXLS1.Dataset := Table1; //Specifies the dataset for export
DataToXLS1.SaveDatasetAs('Orders.xls'); //Saves the dataset into Orders.xls
DataToXLS1.SaveDatasetAs('Orders.html'); //Saves the dataset into Orders.html
end;