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;