C#中Excel的常规处理

C#中Excel的常规处理

将worksheet转成datatable

 public static DataTable WorksheetToTable(Excel._Worksheet worksheet, string ConString)
  {
        //获取worksheet的行数
        int rows = worksheet.UsedRange.Cells.Rows.Count;
        //获取worksheet的列数
        int cols = worksheet.UsedRange.Cells.Columns.Count;

        DataTable dt = new DataTable(name);

        DataSet set = new DataSet(name);

        try
        {
            using (OleDbConnection conn = new OleDbConnection(ConString))
            {
                conn.Open();
                string sql = string.Format("SELECT * FROM [" + name + "$]"); //查询字符串
                OleDbDataAdapter ada = new OleDbDataAdapter(sql, ConString);
                //进行查询数据的连接和刷新
                ada.Fill(set);
                dt = set.Tables[0];
            }
        }
        catch (Exception)