I'm trying to use Microsoft.Office.Interop.Excel. It seems to load fine but when I try to use it, all the defaults parameters are not working. Here is a screenshot that shows all those bad values
Whenever I try to ommit them, the compiler tells me that the function needs more than 1 parameter.
This function is Open as in :
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Workbook wb = excel.Workbooks.Open("ss.xlsx");
How can I use the default value for those 14 parameters?
EDIT I'm using C# 3.5 (2008) with Office 2010
Accepted Solution :
Type.Missing works I also had this issue http://support.microsoft.com/default.aspx?scid=kb;en-us;320369 The problem is that my windows is french but office is in english so hell breaks loose.
Solution is
CultureInfo ci = new CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentCulture = ci;