小弟代码如下: object o = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
_Application app = o as _Application;
Workbook workBook = app.ActiveWorkbook; //错误位置
Worksheet mySheet = (Worksheet)workBook.ActiveSheet;
WeatherWebServiceSoapClient wws = new WeatherWebServiceSoapClient();
mySheet.Range["A2", Type.Missing].Value2 = wws.getWeatherbyCityName (mySheet.Range["A1", Type.Missing].Value2)[6];
经调试,发现Workbook workBook = app.ActiveWorkbook; 到这一句的时候,workBook 对象没有取到打开Excel里面的工作簿(即workBook对象为null)。请问是为什么呢?备注:当我打开另外一个Excel(No.1),然后在vs里面调试,弹出Excel(No.2)
,在No.1中输入"重庆",这时点击No.2里的插件,则程序不会报空值,而是将值正确写入了No.1指定单元格。求解,拜谢!
_Application app = o as _Application;
Workbook workBook = app.ActiveWorkbook; //错误位置
Worksheet mySheet = (Worksheet)workBook.ActiveSheet;
WeatherWebServiceSoapClient wws = new WeatherWebServiceSoapClient();
mySheet.Range["A2", Type.Missing].Value2 = wws.getWeatherbyCityName (mySheet.Range["A1", Type.Missing].Value2)[6];
经调试,发现Workbook workBook = app.ActiveWorkbook; 到这一句的时候,workBook 对象没有取到打开Excel里面的工作簿(即workBook对象为null)。请问是为什么呢?备注:当我打开另外一个Excel(No.1),然后在vs里面调试,弹出Excel(No.2)
,在No.1中输入"重庆",这时点击No.2里的插件,则程序不会报空值,而是将值正确写入了No.1指定单元格。求解,拜谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货