/// <summary>
/// 讀取EXCEL內容
/// </summary>
/// <param name="excelPath">EXCEL路徑</param>
/// <param name="exceltableName">EXCEL工作表名 如sheet1,sheet2,不要加$</param>
/// <returns>返回DataTable</returns>
public static DataTable ReadExcel(string excelPath, string exceltableName)
{
string strConn = "";
OleDbConnection conn = null;
if (String.IsNullOrEmpty(excelPath))
{
return null;
}
if (!System.IO.File.Exists(excelPath))
{
return null;
}
try
{
if (excelPath.EndsWith(".xls"))
{
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +