在中WebBrowser加载Excel后获取excel对象

privatevoidbutton1_Click_1(objectsender, EventArgs e)51Testing软件测试网t!I,zmql@b

{51Testing软件测试网Q5],g{'k%V;v

   stringstrFileName =@"d:\a.xls";51Testing软件测试网{w f2rFOL:k

   Object refmissing = System.Reflection.Missing.Value;51Testing软件测试网p-yD6e'|Y

   this.webBrowser1.Navigate(strFileName);

   objectaxWebBrowser =this.webBrowser1.ActiveXInstance;51Testing软件测试网6N-oX _I,Jy(f

}51Testing软件测试网K'AF#n-MUG

privatevoidwebBrowser1_DocumentCompleted_1(objectsender, WebBrowserDocumentCompletedEventArgs e)

{

   Object refmissing = System.Reflection.Missing.Value;

   object[] args =newobject[4];51Testing软件测试网9Yi:x)}v!l

   args[0] = SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS;

   args[1] = SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER;

   args[2] = refmissing;51Testing软件测试网"rBS L Z,YgC

   args[3] = refmissing;51Testing软件测试网s,sLpQ ~!Y!v

 51Testing软件测试网M1x jS1p5lX"H!`

   objectaxWebBrowser =this.webBrowser1.ActiveXInstance;

 51Testing软件测试网6eI5|w0}1T

   axWebBrowser.GetType().InvokeMember("ExecWB",51Testing软件测试网 x!t3pGp$W

       BindingFlags.InvokeMethod,null, axWebBrowser, args);51Testing软件测试网.E$m'I#C$u8ptI7S6h,[

 51Testing软件测试网rdbfJ

   objectōApplication = axWebBrowser.GetType().InvokeMember("Document",51Testing软件测试网v H']9p"cxP

       BindingFlags.GetProperty,null, axWebBrowser,null);51Testing软件测试网R+O
N~!k(l$xS

 51Testing软件测试网5[l tu m(D$R A5\

   Excel.Workbook wbb = (Excel.Workbook) oApplication;51Testing软件测试网)@5}
fn5WX*VLEd

   Excel.ApplicationClass excel = wbb.ApplicationasExcel.ApplicationClass;51Testing软件测试网(J,t&F2y d'T"q M

   Excel.Workbook wb = excel.Workbooks[1];51Testing软件测试网`*z^H]y}%j

   Excel.Worksheet ws = wb.Worksheets[1]asExcel.Worksheet;

   ws.Cells.Font.Name ="Verdana";51Testing软件测试网)U8f#a#{z6r

   ws.Cells.Font.Size = 14;

   ws.Cells.Font.Bold =true;

   Excel.Range range = ws.Cells;

   Excel.Range ōCell = range[10, 10]asExcel.Range;

   oCell.Value2 ="你好";

}

objectaxWebBrowser =this.webBrowser1.ActiveXInstance;51Testing软件测试网faL*A5a

Object refmissing = System.Reflection.Missing.Value;51Testing软件测试网{B:GUh(FN

object[] args =newobject[4];51Testing软件测试网+Wi2a9^H!d+Z ]8b

args[0] = SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS;51Testing软件测试网.^R:t:ly{*tT

args[1] = SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER;51Testing软件测试网}s,uM9|8Xt d([

args[2] = refmissing;

args[3] = refmissing;

axWebBrowser.GetType().InvokeMember("ExecWB", BindingFlags.InvokeMethod,null, axWebBrowser, args);

axWebBrowser1.ExecWB(SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS, SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER, refmissing, refmissing)51Testing软件测试网)i-s#c~3T

objectōApplication = axWebBrowser.GetType().InvokeMember("Document",51Testing软件测试网/yTWNT8QC

   BindingFlags.GetProperty,null, axWebBrowser,null);51Testing软件测试网/{5y@5C!t aj [

Excel.ApplicationClass excel = wbb.ApplicationasExcel.ApplicationClass;

Excel.Workbook wb = excel.Workbooks[1];