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