Documentazione HotXLS
Home Contenuti Panoramica

ExportDataset metodo

Exports the dataset to new o existing Worksheet

Sintassi

procedura ExportDataset;
procedura ExportDataset(Newsheet: Boolean);
procedura 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

Esempio

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

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

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

  //Second dataset
  DataToXLS1.WorksheetName := 'Table2 sheet'; //Specifica the name for second Worksheet
  DataToXLS1.Dataset := Table2; //Specifica 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 e Table2 datasets 

begin
  DataToXLS1.Workbook := nil; //Clears Workbook
  DataToXLS1.WorksheetName := 'Table1 and Table2 sheet'; //Specifica the name for Worksheet

  //First dataset
  DataToXLS1.Dataset := Table1; //Specifica the dataset for export
  DataToXLS1.ExportDataset;

  //Second dataset
  DataToXLS1.Dataset := Table2; //Specifica the dataset for export
  DataToXLS1.ExportDataset(False);

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