/// <summary>
/// 由Excel导入DataTable
/// </summary>
/// <param name="excelFilePath">Excel文件路径，为物理路径,可传空值</param>
/// <param name="sheetName">Excel工作表名称</param>
/// <param name="headerRowIndex">Excel表头行索引</param>
/// <returns>DataTable</returns>
public static DataTable ToDataTable(string excelFilePath, string sheetName, int headerRowIndex)
{
if (string.IsNullOrEmpty(excelFilePath))
{
excelFilePath = ExcelCommon.GetOpenFilePath();
}
if (string.IsNullOrEmpty(excelFilePath))
{
return(null);
}
using (FileStream stream = System.IO.File.OpenRead(excelFilePath))
{
bool isCompatible = ExcelCommon.GetIsCompatible(excelFilePath);
return(ToDataTable(stream, sheetName, headerRowIndex, isCompatible));
}
}
