public static void FormatApplyFilters(this ExcelSheet sheet, int filterRow = 1, int filterColumn = 1)
{
Range range = sheet.SetRange(filterRow, filterColumn, filterRow, filterColumn);
range.AutoFilter(2);
Cleanup.ReleaseObject(range);
}
public static void FormatMergeAndCentre(this ExcelSheet sheet, int row1, int column1, int row2, int column2)
{
Range rng = sheet.SetRange(row1, column1, row2, column2);
rng.Merge();
rng.HorizontalAlignment = XlHAlign.xlHAlignCenter;
rng.VerticalAlignment = XlVAlign.xlVAlignCenter;
Cleanup.ReleaseObject(rng);
}
public static void FormatHeadingStandard(this ExcelSheet sheet, int headingRow = 1)
{
Range range = sheet.SetRange(headingRow, 1, headingRow, sheet.FindLastUsedColumn(headingRow));
range.Interior.Pattern = XlPattern.xlPatternSolid;
range.Interior.PatternColorIndex = XlColorIndex.xlColorIndexAutomatic;
range.Interior.Color = COLOR_CELL_HEADING;
range.Interior.TintAndShade = 0;
range.Interior.PatternTintAndShade = 0;
range.Font.Bold = true;
range.WrapText = true;
Cleanup.ReleaseObject(range);
}
