using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;//.NET
using Office = Microsoft.Office.Core;//COM
using System.Reflection;//使用Missing字段namespace demo3
{
class Program
{
static void Main(string[] args)
{
Excel.ApplicationClass xApp = new Excel.ApplicationClass();
xApp.Visible = true;//激活excel //得到WorkBook对象,打开已有的文件
Excel.Workbook xBook = xApp.Workbooks._Open(@"E:\demo.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value); //指定要操作的Sheet
Excel.Worksheet xSheet = (Excel.Worksheet)xBook.Sheets[1]; //读取数据,通过Range对象
Excel.Range rng1 = xSheet.get_Range("A3", Type.Missing);
Console.WriteLine(rng1.Value2); //读取,通过Range对象,但使用不同的接口得到Range
Excel.Range rng2 = (Excel.Range)xSheet.Cells[3, 1];
Console.WriteLine(rng2.Value2);
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;//.NET
using Office = Microsoft.Office.Core;//COM
using System.Reflection;//使用Missing字段namespace demo3
{
class Program
{
static void Main(string[] args)
{
Excel.ApplicationClass xApp = new Excel.ApplicationClass();
xApp.Visible = true;//激活excel //得到WorkBook对象,打开已有的文件
Excel.Workbook xBook = xApp.Workbooks._Open(@"E:\demo.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value); //指定要操作的Sheet
Excel.Worksheet xSheet = (Excel.Worksheet)xBook.Sheets[1]; //读取数据,通过Range对象
Excel.Range rng1 = xSheet.get_Range("A3", Type.Missing);
Console.WriteLine(rng1.Value2); //读取,通过Range对象,但使用不同的接口得到Range
Excel.Range rng2 = (Excel.Range)xSheet.Cells[3, 1];
Console.WriteLine(rng2.Value2);
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货