Jump to content

Export Query to Excel


Louay02

Recommended Posts

Hi

I have used SMExportToExcel [the components 'about' gives ver 5.0 (b17)]. without issue.

I just recompiled an old app (was xe5) using Xe8 and UniGui 1.70.0.1485. It still exports fine.

The form with a UniDbGrid (whose dataset is on the MainModule) has a button: It simply sets the filename (from a procedure that gets the query details) on a SMExporttoXLS component that is on the MainModule, and runs the export. 

 procedure TfrmSQLRes.btn2ExcelClick(Sender: TObject);
  var fname : string;
 begin
  fname := makeFilename('.XLS');
  unimainmodule.SMExportToXLS1.filename := fname;
  unimainmodule.SMExportToXLS1.Execute;
end;

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...