Hi,
I'm trying to load an Excel file and the Load function through an exception 'Attempted to read past the end of the stream'
It is an Excel 2003 file and I can open it using Excel.
Thanks for your help,
Can you post the code that is giving you this exception?
Hi Mike,
The exception occurs when openning the file:
Workbook workbook = Infragistics.Excel.Workbook.Load(fileName);
This is working with hundreds of files but with 1 or 2 of them we have a problem. If you like I can email you the excel.
Thanks
I only fixed the bug yesterday. You will need to wait for the next SR to be released.
Has this issue been fixed in Infragistics3.Excel.v9.2 version 9.2.20092.2106 or Infragistics2.Excel.v10.2 version 10.2.20102.2064? I've tried my code with both assemblies and still get the Read past end of stream error.
I am facing with same issue with Infragistics4.Documents.Excel.v11.2 (version 11.2.20112.1010). I am using this latest dll from the Infragistics.
Would you let me know the root cause of this issue so that i can fix the excel document?
This type of error has been caused by different reasons. It seems like there may be another which hasn't been handled as well. Can you post the file you are trying to load which gives the error? I will try to reproduce it here.
I found the root cause of this issue. Just take any sample excel workbook, add the password to the excel file at the Workbook level and save it.
Then try to load the file, it will throw this same exception.
As Mike said above, we do not support loading files with password protection. And as Dimi said here in the other thread on which you posted, we cannot include this functionality due to US Export regulations.