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