I have a report.aspx in which:
Create a report using SQL reporting services and using Export option we are choosing different format such as .xls & .xlsx
When I open "exp.xls" (EXCEL97TO2003 format), there are no errors and everything is fine (line alignment, spacing & all).
But when I open "exp.xlsx" (XLSX format), the following Excel error pop-up dialog is displayed:
'Excel found unreadable content in 'exp.xlsx'. Do you want to recover the contents of this workbook?
If you trust the source of this workbook, click Yes.'
Its showing some error along with alignment mistake, some text are moved & placed some where else,some columns border are break, most of the columns are getting duplicated and values are getting errored
Could you suggest some solutions for it since our requirement is to export data's in .xlsx format itslef
I have attached 4 screen shots of excel sheet. Screen 1 (1_xlsx.gif & 2_xls.gif) and Screen 2 (3_xlsx.gif & 4_xls.gif)