public static void SaveToExcel(this DataTable target, string filePath) { IWorkbook workbook = new HSSFWorkbook(); ISheet sheet = workbook.CreateSheet(target.TableName); sheet.CreateRowHeader(workbook, target); sheet.CreateRowItem(workbook, target); using (FileStream objFS = new FileStream(filePath, FileMode.Create, FileAccess.Write)) { workbook.Write(objFS); objFS.Flush(); objFS.Close(); } }