TcxGrid导出EXCEL

时间:2023-03-09 17:49:59
TcxGrid导出EXCEL

function ExportExcel(grid: TcxGrid; const fileName: string = '1.xls'): Boolean;
var
  sd: TSaveDialog;
begin
  Result := False;
  if not Assigned(grid) then
    Exit;
  sd := TSaveDialog.Create(nil);
  try
    sd.Filter := '*.xls|*.xls';
    sd.fileName := fileName;
    if sd.Execute then
    begin
      Screen.Cursor := crSQLWait;
      try
        ExportGridToExcel(sd.fileName, grid);
      finally
        Screen.Cursor := crDefault;
      end;
      Result := True;
    end;
  finally
    sd.Free;
  end;
end;