Excel found unreadable content in 'file.xls'.Do you want to recover the contents of this workbook

[Viser]

Hi,

I'm getting this error from Excel 2010 on simple xls file with 10000 rows and 20 columns without formatting or formulas. It is rather hard to get which row or cell leads to such error. Because after removing 1000 rows excel opens file without issues(with 90000 rows) and file with those 1000 rows excel able to open as well. Do you have any idea how to fix this issue?

ruby 1.9.3p545
magic utf8 comment were added to each source file
i'm using just write_row and put force_encoding("UTF-8") to any row field

Thanks.

[cxn03651]

worksheet.write(row, col, string.encode('UTF-8'))

2014-06-24 20:56 GMT+09:00 Mitya notifications@github.com:

Hi,

I'm getting this error from Excel 2010 on simple xls file with 10000 rows
and 20 columns without formatting or formulas. It is rather hard to get
which row or cell leads to such error. Do you have any idea how to fix this
issue?

ruby 1.9.3p545
magic utf8 comment were added to each source file
i'm using just write_row and put force_encoding("UTF-8") to any row field

Thanks.

—
Reply to this email directly or view it on GitHub
#39.

[Viser]

no luck, but i found a string which cause Excel error, but it seems normal all fields are in UTF8. Adding this line cause excel error, removing - ok.

[Viser]

I found an issue, it seems that number of Hyperlinks in a worksheet has been exceeded. Is it possible to implement Excel limitations warnings?