.ExportToExcel creates invalid .XLS file

[ScottWGast]

DXE2/Updt4 / IW 14.0.63 / CG 3.0.0.37

The resulting .xls file is deemed invalid by Excel 2013. I saw some recommended patches in prior posts, but they are a couple of years old.

Thanks,
Scott

Code: Select all

procedure TframeExportData.ClickSaveAsExcel(Sender: TObject; AParams: TStringList);
begin
  Self.gridData.JQGridOptions.ExportToExcel('ExportData.xls', True);
end;




[Alexander Bulei]

Hi ScottWGast,

We use the NativeExcel whcih is free and open-source, and definitely old...and supports only up to 2013 (not include) .

if you want export for newer versions of excell, you must find and/or implement it by yourself.

Best Regards.

[zsleo]

This has been an issue for a long time now.

SUGGESTION:
Can the Excel export be replaced by CSV or CSV added as an export option?

[ScottWGast]

OK, Alexandre... I appreciate the info.

zsleo, I have an underlying TADODataSet so I can save the data to xml for the time being as I continue to look for Excel alternatives.

[tonyzhou]

Ref:
https://www.cgdevtools.com/cgforum/viewtopic.php?f=34&t=3000&p=17271#p17271