/// <summary> /// 返回Excel 连接字符串 /// </summary> /// <param name="excelPath">Excel文件 绝对路径</param> /// <param name="header">是否把第一行作为列名</param> /// <param name="eType">Excel 版本 </param> /// <param name="imex">IMEX模式</param> /// <returns>返回值</returns> public static string GetExcelConnectstring(string excelPath, bool header, ExcelType eType, IMEXType imex) { if (!MyFileHelper.IsExistFile(excelPath)) throw new FileNotFoundException("Excel路径不存在!"); string connectstring; string hdr = "NO"; if (header) hdr = "YES"; if (eType == ExcelType.Excel2003) connectstring = "Provider=Microsoft.Jet.OleDb.4.0; data source=" + excelPath + ";Extended Properties='Excel 8.0; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; else connectstring = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" + excelPath + ";Extended Properties='Excel 12.0 Xml; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; return connectstring; }
/// <summary> /// 返回Excel 连接字符串 /// </summary> /// <param name="excelPath">Excel文件 绝对路径</param> /// <param name="header">是否把第一行作为列名</param> /// <param name="eType">Excel 版本 </param> /// <param name="imex">IMEX模式</param> /// <returns></returns> public static string GetExcelConnectstring(string excelPath, bool header, ExcelType eType, IMEXType imex) { if (!FileUtil.IsExistFile(excelPath)) { throw new FileNotFoundException("Excel路径不存在!"); } string connectstring = string.Empty; string hdr = "NO"; if (header) { hdr = "YES"; } if (eType == ExcelType.Excel2003) { connectstring = "Provider=Microsoft.Jet.OleDb.4.0; data source=" + excelPath + ";Extended Properties='Excel 8.0; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; } else { connectstring = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" + excelPath + ";Extended Properties='Excel 12.0 Xml; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; } return(connectstring); }
public static string GetExcelConnectstring(string excelPath, bool header, ExcelType eType, IMEXType imex) { if (!FileUtil.IsExistFile(excelPath)) { throw new FileNotFoundException("Excel路径不存在!"); } string str = "NO"; if (header) { str = "YES"; } if (eType == ExcelType.const_0) { return(string.Concat(new object[] { "Provider=Microsoft.Jet.OleDb.4.0; data source=", excelPath, ";Extended Properties='Excel 8.0; HDR=", str, "; IMEX=", imex.GetHashCode(), "'" })); } return(string.Concat(new object[] { "Provider=Microsoft.ACE.OLEDB.12.0; data source=", excelPath, ";Extended Properties='Excel 12.0 Xml; HDR=", str, "; IMEX=", imex.GetHashCode(), "'" })); }
/// <summary> /// 返回Excel连接字符串 /// </summary> /// <param name="excelPath">Excel文件绝对路径</param> /// <param name="header">是否第一行为列名</param> /// <param name="eType">Excel版本</param> /// <param name="imex">IMEX模式</param> /// <returns></returns> public string GetExcelConnectionString(string excelPath, bool header, ExcelType eType, IMEXType imex) { if (string.IsNullOrEmpty(excelPath)) { throw new ArgumentNullException("Excel路径字符串为空"); } if (!System.IO.File.Exists(excelPath)) { throw new FileNotFoundException(string.Format("Excel文件不存在,路径为:{0}", excelPath)); } string connectionString = ""; string hdr = "NO"; if (header) { hdr = "YES"; } if (eType == ExcelType.Excel_2003) { connectionString = "Provider=Microsoft.Jet.OleDb.4.0; data source=" + excelPath + ";Extended Properties='Excel 8.0; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; } else { connectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" + excelPath + ";Extended Properties='Excel 12.0 Xml; HDR=" + hdr + "; IMEX=" + imex.GetHashCode() + "'"; } return(connectionString); }