opening xls, error in InvokeMember("Open", .. )

hi everyone,

i need open xsl document, edit , save new file.

i've error on line in bold (so can't open document)

//here create workbooks , worksheet

type exceltype = type.gettypefromprogid("excel.application");

objexlapp = activator.createinstance(exceltype);

exceltype.invokemember("visible", system.reflection.bindingflags.setproperty, null, objexlapp,

new object[] { false });

exceltype.invokemember("usercontrol", system.reflection.bindingflags.setproperty, null, objexlapp,

new object[] { true });

objbooks = objexlapp.gettype().invokemember("workbooks", bindingflags.getproperty, null, objexlapp, null);

objbook = objbooks.gettype().invokemember("add", bindingflags.invokemethod, null, objbooks, null);

objsheets = objbook.gettype().invokemember("worksheets", bindingflags.getproperty, null, objbook, null);

parameters = new object[1];

parameters[0] = 1;

object objsheet = objsheets.gettype().invokemember("item", bindingflags.getproperty, null, objsheets, parameters);

//here try opening document

string _filepath = "d:\\mypath\\myfileexel.xls";

object[] parameters = new object[1];

parameters[0] = _filepath;

objexceldoc = objbook.gettype().invokemember("open", bindingflags.invokemethod, null, objbook, parameters);

in last line got error:

{"unknown name. (exception hresult: 0x80020006 (disp_e_unknownname))"}

stacktrace = " @ system.runtimetype.invokedispmethod(string name, bindingflags invokeattr, object target, object[] args, boolean[]

byrefmodifiers, int32 culture, string[] namedparameters)\r\n @ system.runtimetype.invokemember(string name, bindingflags bindingflags...

i can't understand what's problem.

any ideas?

hi,

please open 1 thread 1 question.

thanks.

regards

Silverlight > Programming Silverlight with .NET – General

Lun