给你个EXCEL的,WORD的应该一样的
先声明
public Excel.Application excel;
public Excel.Workbook xBk;
public Excel.Worksheet xSt;
在axWebBrowser1的结束事件中:
private void axWebBrowser1_NavigateComplete2(object sender, AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event e)
{
//导入EXCEL结束
Object o = e.pDisp;
Object oDocument = o.GetType().InvokeMember("Document",BindingFlags.GetProperty,null,o,null);
Object oApplication = o.GetType().InvokeMember("Application",BindingFlags.GetProperty,null,oDocument,null);
Object oName = o.GetType().InvokeMember("Name",BindingFlags.GetProperty ,null,oApplication,null);
//定义当前EXCEL,以便引用
this.excel =(Excel.Application)oApplication;
this.xBk=(Excel.Workbook)excel.ActiveWorkbook;
this.xSt=(Excel.Worksheet)xBk.ActiveSheet;
}
然后在其它地方this.xSt=null;
this.xBk=null;
this.excel.Quit();
先声明
public Excel.Application excel;
public Excel.Workbook xBk;
public Excel.Worksheet xSt;
在axWebBrowser1的结束事件中:
private void axWebBrowser1_NavigateComplete2(object sender, AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event e)
{
//导入EXCEL结束
Object o = e.pDisp;
Object oDocument = o.GetType().InvokeMember("Document",BindingFlags.GetProperty,null,o,null);
Object oApplication = o.GetType().InvokeMember("Application",BindingFlags.GetProperty,null,oDocument,null);
Object oName = o.GetType().InvokeMember("Name",BindingFlags.GetProperty ,null,oApplication,null);
//定义当前EXCEL,以便引用
this.excel =(Excel.Application)oApplication;
this.xBk=(Excel.Workbook)excel.ActiveWorkbook;
this.xSt=(Excel.Worksheet)xBk.ActiveSheet;
}
然后在其它地方this.xSt=null;
this.xBk=null;
this.excel.Quit();
解决方案 »
- 一个很技术的问题,锯齿数组变成矩形数组,行变列,列变行
- C#以OleDbConnection访问Excel,得到定义了过多字段的异常
- 请教.net文件操作的问题!
- 汉字的url编码问题
- 超级变态的问题:System.Net.WebException: 基础连接已经关闭: 服务器提交了协议冲突。
- 求压缩图片的源码
- 事件刷新数据,listview绑定数据
- 求教!关于简易3D引擎的制作。谢谢大家帮忙。
- asp.net处理url地址转为字符串
- 有点挑战性的问题,内详!
- 请问在VS。NET2003中新键一个项目时报MICROSOFT JSCRIPT编译错误,语法错误,是什么回事?
- 我用TextBox做了个做了个多行输入的文本框,可是为什么在这里面输入C#的代码,只要保存就会出错呢?应该怎么处理?
me.Excel=Ctype(oApplication,Excel.Application)
Dim mWord As Word.Application Private Sub AxWebBrowser1_NavigateComplete2(ByVal sender As Object, ByVal e As AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event) Handles AxWebBrowser1.NavigateComplete2
Dim o As Object = e.pDisp
Dim refmissing As Object = System.Reflection.Missing.Value
AxWebBrowser1.ExecWB(SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS, SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER, refmissing, refmissing)
oDocument = o.GetType().InvokeMember("Document", BindingFlags.GetProperty, Nothing, o, Nothing)
Dim oApplication As Object = o.GetType().InvokeMember("Application", BindingFlags.GetProperty, Nothing, oDocument, Nothing) Me.mWord = CType(oApplication, Word.Application) End Sub我在撤消的时候用
Me.mWord.Quit()
提示:“Quit”在继承接口“Word._Application”和“Word.ApplicationEvents2_Event”之间不明确。这个是哪里出错了?
没法提建议