/// <summary>读取excel中指定表索引以及是否有列头行的读取数据情况</summary>
/// <param name="filePath"></param>
/// <param name="sheetIndexs"></param>
/// <param name="hasColNames"></param>
/// <param name="dataStartIndex"></param>
/// <returns></returns>
public static DataSet Read(string filePath, List <int> sheetIndexs, List <bool> hasColNames, List <int[]> dataStartIndex)
{
DataSet ds = ExcelHelper.ImportExceltoDs(filePath, sheetIndexs, hasColNames, dataStartIndex);
return(ds);
}
/// <summary>读取excel中指定表索引和相应列头行的表</summary>
/// <param name="stream"></param>
/// <param name="sheetIndexs"></param>
/// <param name="indexOfColNames"></param>
/// <returns></returns>
public static DataSet Read(Stream stream, List <int> sheetIndexs, List <int> indexOfColNames)
{
DataSet ds = ExcelHelper.ImportExceltoDs(stream, sheetIndexs, indexOfColNames);
return(ds);
}
/// <summary>读取excel中指定表索引和相应列头行的表</summary>
/// <param name="strFileName"></param>
/// <param name="sheetIndexs"></param>
/// <param name="indexOfColNames"></param>
/// <returns></returns>
public static DataSet Read(string filePath, List <int> sheetIndexs, List <int> indexOfColNames)
{
DataSet ds = ExcelHelper.ImportExceltoDs(filePath, sheetIndexs, indexOfColNames);
return(ds);
}
/// <summary>将excel中的每一个表第一行为列名组合读取成一个dataset</summary>
/// <param name="stream"></param>
/// <returns></returns>
public static DataSet Read(Stream stream)
{
DataSet ds = ExcelHelper.ImportExceltoDs(stream);
return(ds);
}
/// <summary>将excel中的每一个表第一行为列名组合读取成一个dataset</summary>
/// <param name="filePath"></param>
/// <returns></returns>
public static DataSet Read(string filePath)
{
DataSet ds = ExcelHelper.ImportExceltoDs(filePath);
return(ds);
}
/// <summary>读取excel中指定表名以及是否有列头行的读取数据情况</summary>
/// <param name="stream"></param>
/// <param name="sheetNames"></param>
/// <param name="hasColNames"></param>
/// <param name="dataStartIndex"></param>
/// <returns></returns>
public static DataSet Read(Stream stream, List <string> sheetNames, List <bool> hasColNames, List <int[]> dataStartIndex)
{
DataSet ds = ExcelHelper.ImportExceltoDs(stream, sheetNames, hasColNames, dataStartIndex);
return(ds);
}