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,
Could this be related to the Excel Workbook being protected by a password. I have tried to open two excel files using:
Infragistics.Excel.
Workbook.Load(txtFilename.Text);
The file that was password protected did not open and I received the error "Attempted to read past the end of the stream..."
The file that was not password protected opened with no problems.
I have not heard of any other reports of a problem like this. Can you post a sample project that creates an Excel file that reproduces this problem?
It doesn't look like this was fixed as I tried it on 10.1, 10.2, 10.3 with and without the latest service release and it still happens.
The only way to get Workboolk.Load() to open the sreadsheet is to first open it in Excel, then save it.
Infragistics - Please respond to this.
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.
Thanks
Sorry Mike, I read your message as saying it was already fixed in 9.2 and above, and since I was using 10.1 I was afraid it might have been a different issue. I'm happy to wait for the next service release.
Kev