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); }
public static void FormatAutoFitAllColumns(this ExcelSheet sheet) { Range rangeA = (Range)sheet.Worksheet.Cells; rangeA = rangeA.EntireColumn; rangeA.AutoFit(); for (int i = 1; i <= sheet.FindLastUsedColumn(); i++) { Range range = (Range)sheet.Worksheet.Columns[i]; range.ColumnWidth += 3; Cleanup.ReleaseObject(range); } Cleanup.ReleaseObject(rangeA); }