HotXLS-dokumentation

SaveDBGridAs metod

Creates a new Workbook. Exports DBGrid to Worksheet. Saves the Workbook to the specified file. Returnerar 1 if it succeeds

Syntax

function SaveDBGridAs( Filename: WideString): Integer;
FileName WideString. En sträng som anger namnet på filen som ska sparas. Du kan ange en fullständig sökväg; gör du inte det sparar komponenten filen i aktuell mapp

Exempel

This example exports the DBGrid1 into Orders.xls Workbook and Orders.html file

begin
  GridToXLS1.Workbook := nil; //Clears Workbook
  GridToXLS1.WorksheetName := 'Orders sheet'; //Specifies name for new Worksheet
  GridToXLS1.DBGrid := DBGrid1; //Specifies the dbgrid for export
  GridToXLS1.SaveDBGridAs('Orders.xls'); //Saves the dbgrid into Orders.xls 
  GridToXLS1.SaveDBGridAs('Orders.html'); //Saves the dbgrid into Orders.html 
end;