c# 读取 Excel的内容

//excel 的读取namespace Csharp_excel_读{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void button1_Click(object sender, EventArgs e)        {        }        private void Form1_Load(object sender, EventArgs e)        {            DataTable myT = ExcelToDataTable("D:/Book6.xls", "sheet1");//读取的文件路径            String mystr = myT.Rows[1][0].ToString();//myT.Rows[][] 为要读取的列和行            this.textBox1.Text = mystr;        }        public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)        {            //源的定义            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";//这句很重要            //Sql语句            //string strExcel = string.Format("select * from [{0}$]", strSheetName);             string strExcel = "select * from   [sheet1$]";            //定义存放的数据表            DataSet ds = new DataSet();            //连接数据源            OleDbConnection conn = new OleDbConnection(strConn);            conn.Open();            //适配到数据源            OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);            adapter.Fill(ds, strSheetName);            conn.Close();            return ds.Tables[strSheetName];        }    }}