DataTable dt = MappingDataset.loadQuery(dbQuery); ExcelWorksheet sheet = excelPackage.Workbook.Worksheets.Add("SHEET 1"); sheet.Cells["A1"].LoadFromDataTable(dt, true); string ct1 = ((dt.Rows.Count + 1) + ""); sheet.Cells["A1:F" ct1].AutoFilter = true; sheet.Cells["A1:F" ct1].AutoFitColumns();
//sheet.Cells.Where(cell => cell.Address.StartsWith("D") && cell.Value.ToString().Equals("YES")).Select(cell => cell.Start.Row).ToList().ForEach(r => sheet.Row(r).Hidden = true);
<pre>DataTable dt = MappingDataset.loadQuery(dbQuery); ExcelWorksheet sheet = excelPackage.Workbook.Worksheets.Add("SHEET 1"); sheet.Cells["A1"].LoadFromDataTable(dt, true); string ct1 = ((dt.Rows.Count + 1) + ""); sheet.Cells["A1:F" ct1].AutoFilter = true; sheet.Cells["A1:F" ct1].AutoFitColumns();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)