Output Flexcel with Intraweb

I previously used FlexcelReport with xlsxadapterin Intraweb programs to generate spreadsheet reports from databases but want to use the latest version of Flexcel and am not sure how to create the report and then output it via a memory stream. Can domebody provide some code examples for use with Delphi?

Thanks
   Bruce

Hi,
Running a report with the new FlexCelReport isn't very different from before. You just nave to create it and free it. The general structure would be:


uses VCL.FlexCel.Core, FlexCel.Report;
...

var
  report: TFlexCelReport;
begin
  report := TFlexCelReport.Create(true);
  try
     Report.Run(...);
  finally
    report.Free;
  end;
end;


I've made an iw example that shows it in more detail. you can get it here.
https://download.tmssoftware.com/flexcel/samples/iw-example.zip

Just because we can, I also added another button to export as PDF. Exporting as html would be as simple too.

Important: As you can see, the code changes are simple. But old report templates are not compatible with the newer ones, and that might mean more work. Normally, all you have to do is to pass the old templates through the report converter, and they should be ready to go. But if you were doing very complex stuff in the templates, they might not convert well, so a manual check is always needed.

You can read more about the converting reports from v3 to v7 here:
http://www.tmssoftware.biz/flexcel/doc/vcl/guides/migrating-from-flexcel-3.html#tflexcelreport