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

[divya_kavishwar]

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 

[ShankerV]

Hi @divya_kavishwar 

The error "Repaired Records: String properties from /xl/worksheets/sheet1.xml part" is due to huge sheet name.

Shanker V

[ShankerV]

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

[arindita97]

Hi, 

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

[pall]

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