游客

标题:c# 读取excel时报错：外部表不是预期的格式
正文:
读取Excel（扩展名是.xls）的c#代码如下：/// <summary> /// 加载Excel - 郑州网建 Camnpr.Com /// </summary> /// <param name="filePath">excel文件地址</param> /// <returns>DataSet</returns> public static DataSet LoadDataFromExcel(string filePath) { try { string strConn; //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"; //strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'"; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=Excel 8.0"; OleDbConnection OleConn = new OleDbConnection(strConn); OleConn.Open(); String sql = "SELECT * FROM [Sheet1$]";//可是更改Sheet名称，比如sheet2，等等 OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn); DataSet OleDsExcle = new DataSet(); OleDa
[<<][[1]][2][>>]

查看评论(0)
发表评论



首页