c# 请问为什么读取excel的时候有的列不显示是excel的格式问题还？

qq_30968951 2016-01-15 10:32:57



 public System.Data.DataSet ExcelSql(string filepath, string tableName)

        {



                //string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties=Excel 8.0;";

                //string strConn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'", filepath);

                //string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties=Excel 8.0;";

                string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + filepath + ";Extended Properties=Excel 8.0; ";

                OleDbConnection conn = new OleDbConnection(strConn);



                conn.Open();



                //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等    

                DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });





                //包含excel中表名的字符串数组

                int a = dtSheetName.Rows.Count;

                string[] strTableNames = new string[dtSheetName.Rows.Count];

                for (int k = 0; k < dtSheetName.Rows.Count; k++)

                {

                    strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();

                }



                DataTable dt = new DataTable();

                DataSet ds = new DataSet();

                //从指定的表明查询数据,可先把所有表明列出来供用户选择 

                OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + strTableNames[0].ToString() + "]", conn);//("select * from [Sheet1$]", conn);

                odda.Fill(ds, "[" + tableName + "$]");

                conn.Close();

                return ds;

        }