public static void FormatSetJustificationLeft(this ExcelSheet sheet) { Range range = sheet.GetUsedRange(); range.HorizontalAlignment = XlHAlign.xlHAlignLeft; range.VerticalAlignment = XlVAlign.xlVAlignCenter; Cleanup.ReleaseObject(range); }
public static void FormatSetFont(this ExcelSheet sheet) { Range range = sheet.GetUsedRange(); range.Font.Name = "Calibri"; range.Font.Size = 10; range.Font.Strikethrough = false; range.Font.Superscript = false; range.Font.Subscript = false; range.Font.OutlineFont = false; range.Font.Shadow = false; range.Font.Underline = XlUnderlineStyle.xlUnderlineStyleNone; range.Font.ThemeColor = XlThemeColor.xlThemeColorLight1; range.Font.TintAndShade = 0; range.Font.ThemeFont = XlThemeFont.xlThemeFontMinor; Cleanup.ReleaseObject(range); }
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); }