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 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.
Hi I am using Infragistics excel 10.3 and still I am getting the "Attempted to read past the end of the stream" error when I try to import an excel in to our application. It throws the error @
wbExcel = Workbook.Load(sExcelFile);
Hello Darshana,
I have verified that this issue has been fixed in the version 2011 vol1 and up. Please upgrade your version to 11.1 or a newer one, where this has been already resolved.
Thank you for contacting Infragistics.
I'm seeing this sane issue with 2012.1 with trying to open a particular excel file. I get this message on Load:
"Attempted to read past the end of the stream"
Is this fix in 12.1? Or would this be a different issue?
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.