.ExportToExcel creates invalid .XLS file
Posted:
30 Oct 2017 19:29by 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;
Re: .ExportToExcel creates invalid .XLS file
Posted:
31 Oct 2017 18:31by 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.
Re: .ExportToExcel creates invalid .XLS file
Posted:
31 Oct 2017 19:20by 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?
Re: .ExportToExcel creates invalid .XLS file
Posted:
31 Oct 2017 20:59by 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.