I’ve encountered a problem when developing on MS Visual Web Developer 2008 Express Ed.
Developing ASP.NET C# on Windows7 64 bit OS.
I’m trying to open an Excel document, but it gives me
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
I did configured the build to all processors (Any CPU, x64, x86) but it doesn’t work. I searched the answer on the internet but couldn’t find out how to handle it.
The weird thing is the same code worked on the same system when I developed on Microsoft Visual C# 2010 Express! how come? isn’t it the same dll working behind?
Do I need to change that COM dll so it’ll work on x64 system?
Please help me, what can I do?
My code is:
using Excel = Microsoft.Office.Interop.Excel; xlApp = new Excel.Application(); __Log("Openning " + excelFileName); xlWorkBook = xlApp.Workbooks.Open(excelFileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "t", false, false, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2);
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
After digging the internet I found out that there is a bug in Microsoft Interop with COM objects (at least with my case which is MS Excel 2010).
The bug is that .NET checks that your thread (C# or VB code) localization is suitable to MS Excel localization you installed earlier, and if not it tells that the
Microsoft.Office.Interop library is old or invalid.
Your thread localization is derived from your computer regional settings (from the control panel –> regional and language)
Then there are two options to solve this problem:
- To change your thread localization (by code)
- Install language pack for your Office
The first solution goes like this:
using System.Threading; // For setting the Localization of the thread to fit using System.Globalization; // the of the MS Excel localization, because of the MS bug Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); excelFileName = System.IO.Path.Combine(excelPath, "Ziperty Buy Model for Web 11_11_2011.xlsm");
Hope it helps 🙂