Jnei = txtB2.Text + "\\" + strN + ".xls";
try
{
objExcelApp1.Workbooks.Open(Jnei, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
}
catch (Exception e)
{
richTextBox1.Text = "错误信息:" + "卷内文件没有打开!";
}
objExcelApp1.Visible = true;// 不显示 Excel 文件,如果为 true 则显示 Excel 文件
//excel.Workbooks.Add(Missing.Value);// 添加工作簿
try
{
objsheetApp1 = (Worksheet)objExcelApp1.ActiveWorkbook.ActiveSheet;// 获取当前工作表
}
catch (Exception e)
{
richTextBox1.Text = "错误信息:" + "卷内当前工作表没有得到!";
}
int H1 = 7;
int W1 = 2;
for (int I1 = 5; I1 <= 33; I1++)
{
string JneiN;
JneiN = objsheetApp1.get_Range(objsheetApp1.Cells[I1, W1], objsheetApp.Cells[I1, W1]).Text.ToString();
if (JneiN == "")
{
Znub = objsheetApp1.get_Range(objsheetApp1.Cells[I1, H1], objsheetApp.Cells[I1, H1]).Text.ToString();
objExcelApp1.ActiveWorkbook.Close(true,null,null);
break;
}
}
我是打开一个excel然后读取单元格里的名称来打开另一个EXCEL在JneiN = objsheetApp1.get_Range(objsheetApp1.Cells[I1, W1], objsheetApp.Cells[I1, W1]).Text.ToString();
读取第二个EXCEL单元格时报错。