object missing = Type.Missing;
Sheets sheets = w.Worksheets;
Worksheet datasheet = null;
foreach (Worksheet sheet in sheets)
{
if (sheet.Name == "Recovered_Sheet1")
{
datasheet = sheet;
break;
}
}
if (null == datasheet)
{
MessageBox.Show(this, "没有名称为 Recovered_Sheet1 的Sheet.");
return;
}
Range range = datasheet.get_Range("A8","N35");
System.Array values = (System.Array)range.Formula;
if (values != null)
{
int len1 = values.GetLength(0);
int len2 = values.GetLength(1);
for (int i = 1; i <= len1; i++)
上一篇:最详细的SQL注入相关的命令整理
下一篇:怎样将Excel中的数据导入到SQLServer2000数据库中
|
精品推荐