c#操作excel

最近的一个项目中碰到了，记录一下！所谓好记性不如烂笔头嘛！

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

/// <summary> /// 读取excel /// </summary> /// <param name="FilePath">EXCEL地址</param> /// <param name="sheetName">excel内表名字</param> /// <returns></returns> public static DataTable GetExcel(string FilePath, string sheetName) {     string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + FilePath + ";Extended Properties=Excel 8.0;";     OleDbConnection conn = new OleDbConnection(strConn);     conn.Open();     DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);       OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", strConn);       DataTable myDataTable = new DataTable();     try     {         myCommand.Fill(myDataTable);     }     catch (Exception ex)     {         //MessageBox.Show(ex.Message);         throw new Exception();     }     finally     {         conn.Close();     }     return myDataTable; }