Documentazione HotXLS
Home Contenuti Panoramica

ExportDBGrid metodo

Exports the dbgrid to new o existing Worksheet

Sintassi

procedura ExportDBGrid;
procedura ExportDBGrid(Newsheet: Boolean);
procedura ExportDBGrid(Newsheet: Boolean; Row, Col: Integer);
Newsheet Boolean facoltativo. True - esporta la dbgrid in un nuovo foglio; False - esporta la dbgrid nel foglio esistente. Il valore predefinito รจ 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 DBGrid1 e DBGrid2 

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

  //First dbgrid
  GridToXLS1.WorksheetName := 'DBGrid1 sheet'; //Specifica the name for first Worksheet
  GridToXLS1.DBGrid := DBGrid1; //Specifica the dbgrid for export
  GridToXLS1.ExportDBGrid;

  //Second dbgrid
  GridToXLS1.WorksheetName := 'DBGrid2 sheet'; //Specifica the name for second Worksheet
  GridToXLS1.DBGrid := DBGrid2; //Specifica the dbgrid for export
  GridToXLS1.ExportDBGrid;

  GridToXLS1.SaveAs('Example1.xls'); //Saves the created Workbook into Example1.xls file
end;
This example creates Example2.xls Workbook with one Worksheet which contain data from DBGrid1 e DBGrid2 

begin
  GridToXLS1.Workbook := nil; //Clears Workbook
  GridToXLS1.WorksheetName := 'DBGrid1 and DBGrid2 sheet'; //Specifica the name for Worksheet

  //First dbgrid
  GridToXLS1.DBGrid := DBGrid1; //Specifica the dbgrid for export
  GridToXLS1.ExportDBGrid;

  //Second dbgrid
  GridToXLS1.DBGrid := DBGrid2; //Specifica the dbgrid for export
  GridToXLS1.ExportDBGrid(false);

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