HotXLS Docs

SaveDBGridAs method

Creates a new Workbook. Exports DBGrid 到工作表。把工作簿保存到指定文件,成功时返回 1

语法

function SaveDBGridAs( Filename: WideString): Integer;
FileName WideString。指示要保存的文件名的字符串。可以包含完整路径;如果不包含,组件会将文件保存在当前文件夹中

示例

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;