using Excel = Microsoft.Office.Interop.Excel;
private Excel.GlobalClass excel_GlobalClass = new Excel.GlobalClass();
if (excel_GlobalClass.ActiveWorkbook == null)//ActiveWorkbook的值为null,不知道为什么
{
MessageBox.Show("null");
}
MessageBox.Show(excel_GlobalClass.Workbooks.Count.ToString());//Count值为0
无论是workbooks,还是worksheets统统获取不到,但奇怪的是在word里用同样的方式却可以获取到,代码如下:
using Word = Microsoft.Office.Interop.Word;
private Word.GlobalClass word_GlobalClass = new Word.GlobalClass();
MessageBox.Show(word_GlobalClass.ActiveDocument.Name);//这句就可以获取到当前活动文档
试了好多办法,就是在Excel中无法获取,唉,求高手指教啊!
6 个解决方案
#1
自己先顶一下,在线等高手解答!
#2
帖子不要沉了啊,坐等答案!
#3
oledbConnection.Open();
OleDbCommand oleDbCommand = new OleDbCommand(strQuerySql, oledbConnection);
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
oleDbDataAdapter.SelectCommand = oleDbCommand;
oleDbDataAdapter.Fill(dt);
这样试试
OleDbCommand oleDbCommand = new OleDbCommand(strQuerySql, oledbConnection);
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
oleDbDataAdapter.SelectCommand = oleDbCommand;
oleDbDataAdapter.Fill(dt);
这样试试
#4
其实我必须得到ActiveWorkbook这个对象,可无论如何也获取不到任何workbook。
#5
自己顶一下,坐等高手解答
#6
唉,求高手解答啊,难道没人知道吗?
#1
自己先顶一下,在线等高手解答!
#2
帖子不要沉了啊,坐等答案!
#3
oledbConnection.Open();
OleDbCommand oleDbCommand = new OleDbCommand(strQuerySql, oledbConnection);
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
oleDbDataAdapter.SelectCommand = oleDbCommand;
oleDbDataAdapter.Fill(dt);
这样试试
OleDbCommand oleDbCommand = new OleDbCommand(strQuerySql, oledbConnection);
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
oleDbDataAdapter.SelectCommand = oleDbCommand;
oleDbDataAdapter.Fill(dt);
这样试试
#4
其实我必须得到ActiveWorkbook这个对象,可无论如何也获取不到任何workbook。
#5
自己顶一下,坐等高手解答
#6
唉,求高手解答啊,难道没人知道吗?