• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 810
  • Last Modified:

How to avoid COMException when getting value of an Excel 2007 cell?

Hello,

I'm developing an add-in for Excel 2007 with Visual Studio 2005, and I don't have any errors when I use it on my machine, but I'm getting following errors on another computer:
 Exception thrown when getting cell value
This error occurs when getting value of a cell:
 
Excel.Range rng = sheet.Cells[headidx, icol] as Excel.Range;
                if (rng != null)
                {
                    object val = rng.get_Value(oMissing);
                }

Open in new window


Would you have any idea about the origin of the problem and how to solve it?

Many thanks,
Julien
0
JulienVan
Asked:
JulienVan
  • 2
1 Solution
 
JulienVanAuthor Commented:
I've found an element of answer on this site: http://www.tebyan.net/index.aspx?pid=31159&BookID=22108&PageIndex=44&Language=3

"Old Format or Invalid Type Library Error

A second issue that further complicates the Excel locale issue is that you can get an "Old format or invalid type library" error when using the Excel object model in an English Excel installation on a machine where the locale is set to a non-English locale. Excel is looking for a file called xllex.dll in Program Files\Microsoft Office\OFFICE11\1033 that it cannot find. The solution to this problem is to install the xllex.dll file or install the MUI language packs for Office. You can also make a copy of excel.exe, rename it to xllex.dll, and copy it to the 1033 directory."

The origin of the problem might be that my system is not in english but my Office software is, I'm going to check it...
0
 
JulienVanAuthor Commented:
OK so the origin of the problem was the locale culture that was different from Excel language, as explained here:
http://blogs.msdn.com/b/vsto/archive/2009/07/06/bug-old-format-or-invalid-type-library-error-when-automating-excel-christin-boyd.aspx
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now