HotXLS-dokumentation

SaveDBGridAs metode

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

Syntaks

function SaveDBGridAs( Filename: WideString): Integer;
FileName WideString. En streng, der angiver navnet på den fil, der skal gemmes. Du kan angive en fuld sti; gør du det ikke, gemmer komponenten filen i den aktuelle mappe

Eksempel

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

begin
  GridToXLS1.Workbook := nil; //Clears Workbook
  GridToXLS1.WorksheetName := 'Orders sheet'; //Angiver name for new Worksheet
  GridToXLS1.DBGrid := DBGrid1; //Angiver 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;