/// <summary>
/// 获得连接
/// </summary>
/// <param name="excelVersion"></param>
/// <returns></returns>
private static string GetConnectionString(ExcelVersion excelVersion, ImportOrExportType etype)
{
if (etype == ImportOrExportType.Import)
{
if (excelVersion == ExcelVersion.Excel12)
{
return("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR={1};IMEX=1'");
}
else if (excelVersion == ExcelVersion.Excel3)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 3.0;HDR={1};IMEX=1'");
}
else if (excelVersion == ExcelVersion.Excel4)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 4.0;HDR={1};IMEX=1'");
}
else if (excelVersion == ExcelVersion.Excel5)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 5.0;HDR={1};IMEX=1'");
}
else
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 8.0;HDR={1};IMEX=1'");
}
}
else
{
if (excelVersion == ExcelVersion.Excel12)
{
return("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR={1}'");
}
else if (excelVersion == ExcelVersion.Excel3)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 3.0;HDR={1}'");
}
else if (excelVersion == ExcelVersion.Excel4)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 4.0;HDR={1};'");
}
else if (excelVersion == ExcelVersion.Excel5)
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 5.0;HDR={1};'");
}
else
{
return("Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 8.0;HDR={1};'");
}
}
}
/// <summary>
/// 获得连接
/// </summary>
/// <param name="excelVersion"></param>
/// <returns></returns>
private static string GetConnectionString(ExcelVersion excelVersion, ImportOrExportType etype)
{
if (etype == ImportOrExportType.Import)
{
if (excelVersion == ExcelVersion.Excel12)
{
return "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR={1};IMEX=1'";
}
else if (excelVersion == ExcelVersion.Excel3)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 3.0;HDR={1};IMEX=1'";
}
else if (excelVersion == ExcelVersion.Excel4)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 4.0;HDR={1};IMEX=1'";
}
else if (excelVersion == ExcelVersion.Excel5)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 5.0;HDR={1};IMEX=1'";
}
else
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 8.0;HDR={1};IMEX=1'";
}
}
else
{
if (excelVersion == ExcelVersion.Excel12)
{
return "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR={1}'";
}
else if (excelVersion == ExcelVersion.Excel3)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 3.0;HDR={1}'";
}
else if (excelVersion == ExcelVersion.Excel4)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 4.0;HDR={1};'";
}
else if (excelVersion == ExcelVersion.Excel5)
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 5.0;HDR={1};'";
}
else
{
return "Provider=Microsoft.Jet.OleDb.4.0; Data Source={0}; Extended Properties='Excel 8.0;HDR={1};'";
}
}
}
