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