Hi,
When I try to open excel file generated using Infragistics.Excel - I am getting below exception....
"Excel found unreadable content in 'filename.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, Click Yes"
After Repaired it shows in repair log - "Repaired Records: Worksheet properties from /xl/worksheets/sheet1.xml part"
After my analysis on the issue i found below line of code causing the issue.
workSheet.PrintOptions.InsertPageBreak(workSheet.Rows[headerRow]);
Part of my code FYR...
workSheet.PrintOptions.InsertPageBreak(workSheet.Columns[reportSet.Tables[0].Columns.Count]);
workSheet.PrintOptions.Orientation = Infragistics.Documents.Excel.
Orientation.Landscape;
workSheet.PrintOptions.PaperSize =
PaperSize.Legal;
workSheet.PrintOptions.LeftMargin = 0.2;
workSheet.PrintOptions.RightMargin = 0.2;
workSheet.PrintOptions.ScalingFactor = 72;
Hello Georgi,
My current installed version - 12.1.20121.2038
I'm still having the same issue, in the meantime to resolve the issue I commented the below line which causing the issue...
Can you please try creating the excel file dynamically and also add data at runtime and format – Insert Page break at rows/column level. As I said earlier I’m seeing this issue when I’m having more than 65k rows in my output excel file.
Thanks
Hello vbalingula,
Have you been able to resolve your issue ? If you still have any concerns or questions I will be glad to help. If you need any additional assistance don’t hesitate to ask.
Regards
I try to reproduce this issue using bigger excel file (in my test I`m using file with size 260 Kb), but again everything works properly. Could you please tell me what exact is your current build of version 12.1. I`m using 12.1.20121.2054. If you are using older build, please download the latest available service release from our site:
Infragistics.com -> Accounts -> My Keys and Downloads
Please take a look at the attached video file with my tests with bigger file. Please let me know if you have any questions.
I am using version 12.1
Hello,
Thank you for your quick reply and sample code.
Sorry I forgot to mention - but I noticed that when I have rows fewer then 65K I don’t see that issue but more then that it started causing the issue!