14
12/11
EXCEL转换到TABLE中
//把EXCEL转换到TABLE中 public static DataTable ExcelToDataTable(string excelPath, string strSheetName) { string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelPath + ";" + "Extended Properties=Excel 5.0;"; string strExcel = string.Format("select * from [{0}]", strSheetName); DataSet ds = new DataSet(); using (OleDbConnection conn = new OleD...