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
You might need to get the latest service release, if you don't already have it.
How to get the latest service release - Infragistics Community
I applied the latest patch (NetAdvantage_WPF_20121.2314_SR.zip). I get the same error message when opening the file. I'd like to send the file, so you can try it. Is there a way I can send the file without posting it to the forum? I'd rather not make it publicly available.
The way the system works, I'm not able to open and save the file before running the Excel code. It all happens in batch.
Hello,
The fix of this issue was included in the latest service release of Infragistics 13.1 and Infragistics 13.2. As workaround of this issue I could suggest you to open the file with Excel and then close it. When you open this file in MS Excel and they automatically fix it up, the original data in the WRITEACCESS record is lost and it is overwritten with the default value (the current user). Other option is to upgrade to Infragistics 13.1 or Infragistics 13.2.
I hope that this will helps you.
That workaround won't work for me, as this all happens in a batch process. Is there an plans to include the fix in 12.1? Upgrading to 13.1 would require code changes that we aren't able to make just yet
Hello ,
On the following link you could review our Product Lifecycle:
http://es.infragistics.com/help/product-lifecycle/
Infragistics 12.1 was expired for service releases long before this issue to be reported, so we do not have any plans to include this fix in Infragistics 12.1.
Please let me know if you have any further questions.