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); }