public static void FormatBorders(this ExcelSheet sheet, Range range = null)
{
if (range == null)
{
range = sheet.GetUsedRange();
}
Borders borders = range.Borders;
borders[XlBordersIndex.xlDiagonalDown].LineStyle = XlLineStyle.xlLineStyleNone;
borders[XlBordersIndex.xlDiagonalUp].LineStyle = XlLineStyle.xlLineStyleNone;
borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlEdgeBottom].ThemeColor = 1;
borders[XlBordersIndex.xlEdgeBottom].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlEdgeTop].ThemeColor = 1;
borders[XlBordersIndex.xlEdgeTop].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlEdgeTop].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlEdgeLeft].ThemeColor = 1;
borders[XlBordersIndex.xlEdgeLeft].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlEdgeLeft].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlEdgeRight].ThemeColor = 1;
borders[XlBordersIndex.xlEdgeRight].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlInsideHorizontal].ThemeColor = 1;
borders[XlBordersIndex.xlInsideHorizontal].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlInsideHorizontal].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlInsideVertical].LineStyle = XlLineStyle.xlContinuous;
borders[XlBordersIndex.xlInsideVertical].ThemeColor = 1;
borders[XlBordersIndex.xlInsideVertical].TintAndShade = -0.499984740745262;
borders[XlBordersIndex.xlInsideVertical].Weight = XlBorderWeight.xlThin;
Cleanup.ReleaseObject(range);
}
public static void FormatFilTableColours(this ExcelSheet sheet, bool hasColour)
{
Range range = sheet.GetUsedRange();
switch (hasColour)
{
case true:
range.Interior.Pattern = XlPattern.xlPatternSolid;
range.Interior.PatternColorIndex = XlColorIndex.xlColorIndexAutomatic;
range.Interior.Color = 15532007;
range.Interior.TintAndShade = 0;
range.Interior.PatternTintAndShade = 0;
break;
case false:
range.Interior.Pattern = XlPattern.xlPatternSolid;
range.Interior.PatternColorIndex = XlColorIndex.xlColorIndexAutomatic;
range.Interior.ThemeColor = XlThemeColor.xlThemeColorDark1;
range.Interior.TintAndShade = 0;
range.Interior.PatternTintAndShade = 0;
break;
}
Cleanup.ReleaseObject(range);
}
internal SheetFormatting(ExcelSheet excelSheet) => ExcelSheet = excelSheet;
