Rendered Report in .XLSX format is showing error while opening and report is not Populated

Question

Hi All,

I am using render tool to generate a report in different sheets in excel. while opening the excel i am getting below error

Repaired Records: String properties from /xl/worksheets/sheet1.xml part
Repaired Records: String properties from /xl/worksheets/sheet4.xml part

also if click close the report is not showing properly

Can anyone please provide some solution to this error

excel error.PNG

pall · Answer

Hello

Agree I was also facing the same issue - you can modify the Paper Size settings - use custom size and then work backwards and adjust it as per your content to avid getting the error

arindita97 · Answer

Hi,

i was also facing the same error, and by changing the orientation from potrait to landscape I could fix the problem.

ShankerV · Answer

Excel will allow only 31 characters in sheet names.

I believe you might be using dynamic Excel sheet names which were longer that the 31 character length for sheet name in Excel.

You can resolve this by limiting the sheet name to 31 characters.

Shanker V