FileStream stream = File.OpenRead(sFileName);
Workbook book = Workbook.Load(stream);
Gives Error: Attemped to read past the end of the stream.
Get this with large .xls (old version of excel file) when trying to read. If it is .xlsx which is Excel 2010 format don't get error. The file I tried to use was only 3.9 MB in side. It opens fine in Excel 2013 (I have Office 2013 installed).
Anything I need to do except convert over to xlsx format which works - I get the excel files from 3rd party and don't want to open and save every file for infragistics to work on the file.
If you need an example file, I can email it to you or something (I didn't know how to include the file in the forum post, although I figure you probably know about this error and how to fix in code hopefully).
PS> no password protection or anything so it should open. I saw a similar post and it looks like others are getting same error. If you need a sample file, give me an email or FTP site to push a sample file which has the error.
Hello ,
Can you please provide us sample xls file in order to investigate this issue, you could attach this file in zipped format . Please click on “Reply” button to my post, go to “Options” tab (clicking on “Reply”, you will be on “Compose” tab), press on “Add/Update” button and attach your files.
I am waiting for your details.