We created a report in Crystal Reports which we want to export to xlsx format and not to xls format. Is this possible?
We want to do this because after generating several Excel
files using the Thinkwise reporting Service we want to combine them as separate
worksheets in one excel file. The component we use for this needs to have xlsx and
Best answer by Jasper
Crystal Reports unfortunately only supports exporting the data without styling to Excel 2007 (XLSX). See this
link for more info.
An alternative would be to use DevExpress or SQL Server Reporting, which both support exporting to XLSX.