Excel Automation problem

[Walter Andosen]

I have some trouble creating a Excel workbook. I get lots
of Exceptions.

For example I get
System.Runtime. InteropServices .COMException (0x80028018):
Old format or invalid type library.
at Excel.Applicati onClass.set_Dis playAlerts(Bool ean RHS)

when I do

Excel.Applicati on excel=new Excel.Applicati on();
excel.DisplayAl erts=false; // <-- Exception thrown here.

I have problems with this as well (I get some HRESULT
error):

Excel.Range range;
range=worksheet .get_Range("A1" ,Missing.Value) .get_Resize
(1,fieldCount);
range.set_Value (Missing.Value, headers);
range.Font.Bold =true;

I also get the "Old format or invalid type library."
error when I do:
workbook.SaveAs
(@"C:\Book1.xls ",Excel.XlFileF ormat.xlXMLSpre adsheet,Missi
ng.Value,Missin g.Value,Missing .Value,Missing. Value,Excel.X
lSaveAsAccessMo de.xlNoChange,M issing.Value,Mi ssing.Value,M
issing.Value,Mi ssing.Value,Mis sing.Value);
What is wrong? I'm using Office 2003 and I have the
following references:
adodb
Excel
Microsoft.Offic e.Core
stdole
System
VBIDE

usings:
using System;
using System.Collecti ons;
using System.Diagnost ics;
using System.Globaliz ation;
using System.Reflecti on;
using System.Runtime. InteropServices ;
using ADODB;

Other Excel things like
range.CopyFromR ecordset(rs,Mis sing.Value,Miss ing.Value);

Please help!

Walter

[Anders Norås [MCAD]]

There is a bug in Excel 2003 that may cause an "Old format or invalid type
library" exception. The exception is thrown when the method your calling or
the method called internally by the public property requires an LCID locale
identifier and you're running an English version of Excel on a computer with
a forreign regional setting.
The easiest way to workaround the bug is to set the CurrentCulture property
of the Thread to en-US.
System.Threadin g.Thread.Curren tThread.Current Culture = new
CultureInfo("en-US");

Anders Norås
http://dotnetjunkies.com/weblog/anoras/