Saves the workbook to the specified file. Returns 1 if it succeeds.
This example creates Example1.xls workbook and Examle1.html file with two worksheets which contain data from DBGrid1 and DBGrid2.
begin
DBGrid2Excel1.Workbook := nil; //Clears workbook
//First dbgrid
DBGrid2Excel1.WorkSheetName := 'DBGrid1 sheet'; //Specifies the name for first worksheet
DBGrid2Excel1.DBGrid := DBGrid1; //Specifies the dbgrid for export
DBGrid2Excel1.ExportDBGrid;
//Second dbgrid
DBGrid2Excel1.WorkSheetName := 'DBGrid2 sheet'; //Specifies the name for second worksheet
DBGrid2Excel1.DBGrid := DBGrid2; //Specifies the dbgrid for export
DBGrid2Excel1.ExportDBGrid;
DBGrid2Excel1.SaveAs('Example1.xls'); //Saves the created workbook into Example1.xls file
DBGrid2Excel1.SaveAs('Example1.html'); //Saves the created workbook into Example1.html file
DBGrid2Excel1.SaveAs('Example1.rtf'); //Saves the created workbook into Example1.rtf file
end;
