Posted 24 September 2017, 8:13 pm EST
We have a report created in AR11, where when we try to export the report to excel using your APIs, the numbers in the report are saved as characters in the excel. One thing to note here is that the same is working fine if we have excel 2003, but see this problem only if we have excel 2013. Not sure if anything specific we have to do in our code base. Here is the code snippet i use to export to excel.
GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XLSEx = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
this.WebRptViewer.Export(XLSEx, new System.IO.FileInfo(export_file_name));
Also, in the report designer i have set the OutputFormat text box property to Number.
Please suggest to proceed further on this.
Thanks,
Siva G.