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,
Hi Mike,
I am using Infragistics4.WebUI.Documents.Excel.v11.2I have an excel template file Test.xlt (File Attached) which contains an image in the headerWhen I try to load the file using the following codeWorkbook workBook = Workbook.Load(Test.xlt)
I get the following exception "Attempted to read past the end of the stream."Note: If there is no image in the header then it works fine.
I need to include images in the header and footer.
Kindly provide a solution ASAP.
Thanks,
Utkarsh Bandekar
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.
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.
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 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?
Thanks