Advertisement
Guest User

Untitled

a guest
Dec 12th, 2017
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.64 KB | None | 0 0
  1.  
  2. procedure SaveDBGridDataToExcel(var ADbgrid: TDBGridEh);
  3. var
  4.   sd: TSaveDialog;
  5. begin
  6.   if not ADbgrid.DataSource.DataSet.IsEmpty then
  7.     if ADbgrid.DataSource.DataSet.RecordCount > 0 then
  8.     begin
  9.       sd := TSaveDialog.Create(nil);
  10.       try
  11.         sd.Filter := 'Excel|*.xlsx';
  12.         sd.Options := [ofOverwritePrompt, ofHideReadOnly, ofPathMustExist,
  13.           ofEnableSizing, ofExtensionDifferent];
  14.         if sd.Execute then
  15.         begin
  16.           SaveDBGridEhToExportFile(TDBGridEhExportAsXlsx, ADbgrid,
  17.             sd.FileName + '.xlsx', true);
  18.         end
  19.       finally
  20.         FreeAndNil(sd);
  21.       end;
  22.     end;
  23. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement