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,
Hello ,
On the following link you could review our Product Lifecycle:
http://ko.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.
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,
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.
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.
If you still get the same issue after applying the latest updates, try the following: Open the file in Excel and save it to a new filename preferably as an xlsx workbook.
We've seen this same error message with 13.1 as well, but it has a logical explanation: The spreadsheet we were trying to process was produced by an old in-house Access export that was producing Excel 97 files. Once we save the export to an Excel 2007 or later format, the error doesn't happen.
Hoppe this helps.