Rendered Report in .XLSX format is showing error while opening and report is not Populated
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The error "Repaired Records: String properties from /xl/worksheets/sheet1.xml part" is due to huge sheet name.
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
i was also facing the same error, and by changing the orientation from potrait to landscape I could fix the problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
