public static System.Data.DataSet GetDataSetFromExcelFile(string fileName, bool firstRowIsColumnHead = true, bool ignoreBlankRow = true, bool ignoreHiddenSheet = true)
{
NPOI.SS.UserModel.IWorkbook workbook = GetWorkbookFromExcelFile(fileName);
if (workbook == null)
{
return(null);
}
System.Data.DataSet dataSet = new System.Data.DataSet();
for (int i = 0; i < workbook.NumberOfSheets; i++)
{
bool isHiddenSheet = workbook.IsSheetHidden(i) || workbook.IsSheetVeryHidden(i);
if (ignoreHiddenSheet && isHiddenSheet)
{
continue;
}
dataSet.Tables.Add(GetDataTableFromSheet(workbook.GetSheetAt(i), 0, 0, true, true, true));
}
return(dataSet);
}
