如何从Excel Sheet无记名级VSTO解决方案中读取数据? [英] How to read data from a Excel Sheet indocument level VSTO solution?
问题描述
我正在为excel创建一个文档级别的vsto解决方案。
我的excel就像:
工作表名称:Sheet1
数据:
栏 - ABCD
Projetc1
Project2
Project3
我需要读取B列的值。所以我写了下面的代码:
private void ThisWorkbook_Startup(object sender,System.EventArgs e)
{
工作簿wb =
Globals.Factory.GetVstoObject(Globals.ThisWorkbook.Application.ActiveWorkbook);
工作表ws =(工作表)wb .Worksheets [1];
string s = ws.Name;
var cell1 = ws.Range [B,Type。缺少];
var content = cell1.Value2;
}
但是我得到了无效的强制转换错误
无法将'System .__ ComObject'类型的COM对象强制转换为接口类型'Microsoft.Office.Tools.Excel.Worksheet。
我需要阅读列表中的列b值。
PLease指导我如何操作。
I am creating a document level vsto solution for excel .
My excel is like :
sheet name : Sheet1
data :
columns- A B C D
Projetc1
Project2
Project3
I need to read column B values . So i wrote below code :
private void ThisWorkbook_Startup(object sender, System.EventArgs e)
{
Workbook wb =
Globals.Factory.GetVstoObject(Globals.ThisWorkbook.Application.ActiveWorkbook);
Worksheet ws = (Worksheet)wb.Worksheets[1];
string s = ws.Name;
var cell1 = ws.Range["B", Type.Missing];
var content = cell1.Value2;
}
But i am getting invalid cast error
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Tools.Excel.Worksheet.
I need to read the column b values in a list .
PLease guide me how to do it .
推荐答案
错误信息已经告诉你这笔交易是什么:
工作表w s =(工作表)wb.Worksheets [1];
根据这一点,你不能将对象转换为工作簿,因为索引1没有工作簿对象。 br />
如果你一定要使用VSTO,那么你应该读这个:
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook。 activesheet.aspx
别的,我更喜欢odbc方法
http://lmgtfy.com/?q=c%23+excel+odbc [ ^ ]
error msg already tells you what the deal is:
Worksheet ws = (Worksheet)wb.Worksheets[1];
According to that, you cannot cast the object as workbook, since there is no workbook object at index 1.
if you're bound to use VSTO, then you should read this:
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.activesheet.aspx
else, I would prefer odbc method
http://lmgtfy.com/?q=c%23+excel+odbc[^]
这篇关于如何从Excel Sheet无记名级VSTO解决方案中读取数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!