Hi,
My windows application has reference to the above mentioned dlls. I am looking to load a excel 2007 file to the grid, and i keep getting the below exception message. I believed Infragistics3.Excel.v9.2.dll supported this Load. The code breaks at Workbook.Load(fs); where fs is filestream
Any idea what could be wrong?
Many Thanks
Renu
Hi Renu,
It would appear that there is a problem with your filestream. How are you creating this stream? What does the code look like?
Also.. just out of curiosity, why use a FileStream instead of just using the filename? Are you manipulating the file stream in some way before you try to load the Workbook?
I have a filedialog . user selects the file and then i have this line
fs =
new System.IO.FileStream(selectedFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
Let me try with the file directly.
The excel file is simple file with data in 6 columns. No formulas / fomatting etc.
Thanks
Hi Mike,
I changed the code to the pass the file path.
I still see the same error.
I don't see anything wrong with the code you posted here, so there must be something wrong with the Excel file.
Can you post an Excel file that you are trying to open which does not work? You can attach a file to your post by going to the Options tab.
I'm glad you got this resolved. For future reference, the answer to your question is no, you cannot mix different versions of the Infragistics assemblies in the same solution.
I got it working. Just cleaned my solution and included all the references again. a 8.2 version was still being reference..
Thanks a lot mike for your help
Can i reference the excel dll of version infragistics3.Excel.v9.2 and the rest of the dll's of infragistics2.***v8.2 ?
Not sure, if i can upload any files due to security restrictions. But i have this file with numbers from 1 to 50 in the first column. that's it. Nothing fancy.
Can you provide me with a file, which works at your end and is expected to work at my end too..