Saves the Workbook to the specified file. Returnerer 1 if it succeeds
File names ending in .xlsx are written through the XLSX
export bridge; .xls, .html, and
.rtf continue to use the classic exporters
Syntaks
function SaveAs(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
Eksemplet opretter projektmappen Example1.xls og filen Examle1.html med to regneark, der indeholder data fra DBGrid1 og DBGrid2
begin
GridToXLS1.Workbook := nil; //Clears Workbook
//First dbgrid
GridToXLS1.WorksheetName := 'DBGrid1 sheet'; //Angiver the name for first Worksheet
GridToXLS1.DBGrid := DBGrid1; //Angiver the dbgrid for export
GridToXLS1.ExportDBGrid;
//Second dbgrid
GridToXLS1.WorksheetName := 'DBGrid2 sheet'; //Angiver the name for second Worksheet
GridToXLS1.DBGrid := DBGrid2; //Angiver the dbgrid for export
GridToXLS1.ExportDBGrid;
GridToXLS1.SaveAs('Example1.xls'); //Saves the created Workbook into Example1.xls file
GridToXLS1.SaveAs('Example1.xlsx'); //Saves the created Workbook into Example1.xlsx file
GridToXLS1.SaveAs('Example1.html'); //Saves the created Workbook into Example1.html file
GridToXLS1.SaveAs('Example1.rtf'); //Saves the created Workbook into Example1.rtf file
end;