public static void AddColumnHeaderToSheet(
ref Worksheet ws,
int columnNumber,
int columnWidth,
int headerRow,
string headerTitle = "",
int headerFontSize = cHeaderFontSize,
MakeBold headerBold = MakeBold.Yes,
XlUnderlineStyle headerUnderline = XlUnderlineStyle.xlUnderlineStyleNone,
WrapText headerWrapText = WrapText.Yes,
XlHAlign headerHorizontalAlignment = XlHAlign.xlHAlignGeneral,
int headerOrientation = 0)
{
Range column = (Range)ws.Columns[columnNumber];
column.ColumnWidth = columnWidth;
if (!string.IsNullOrEmpty(headerTitle))
{
Range header = (Range)ws.Cells[headerRow, columnNumber];
header.Value = headerTitle;
header.Font.Size = headerFontSize;
header.Font.Bold = headerBold;
header.Font.Underline = headerUnderline;
header.WrapText = headerWrapText;
header.HorizontalAlignment = headerHorizontalAlignment;
header.Orientation = headerOrientation;
}
}
public static void AddContentToCell(Range rng, string text,
int fontSize = 10,
MakeBold bold = MakeBold.No,
XlUnderlineStyle underline = XlUnderlineStyle.xlUnderlineStyleNone,
WrapText wrapText = WrapText.No,
XlHAlign horizontalAlignment = XlHAlign.xlHAlignGeneral)
{
rng.Value = text;
rng.Font.Size = fontSize;
rng.Font.Bold = (int)bold;
rng.Font.Underline = underline;
rng.WrapText = (int)wrapText;
rng.HorizontalAlignment = horizontalAlignment;
//rng.NumberFormat = "MM/DD/YYYY";
}
public static void AddColumnToSheet(
ref Worksheet ws,
int columnNumber,
int columnWidth,
bool columnWrapText,
string columnNumberFormat,
XlDirection shiftDirection,
XlInsertFormatOrigin insertFormatOrigin,
int headerRow,
string headerTitle = "",
int headerFontSize = cHeaderFontSize,
MakeBold headerBold = MakeBold.Yes,
XlUnderlineStyle headerUnderline = XlUnderlineStyle.xlUnderlineStyleSingle,
WrapText headerWrapText = WrapText.Yes,
XlHAlign headerHorizontalAlignment = XlHAlign.xlHAlignCenter,
int headerOrientation = 0)
{
// Insert the new column and apply things that pertain to all cells in the column
//((Range)ws.Columns[columnNumber]).Insert(Shift: shiftDirection, CopyOrigin: insertFormatOrigin);
Range newColumn = (Range)ws.Columns[columnNumber];
newColumn.Insert(Shift: shiftDirection, CopyOrigin: insertFormatOrigin);
newColumn.WrapText = columnWrapText;
newColumn.NumberFormat = columnNumberFormat;
// Pass all the rest on
AddColumnHeaderToSheet(ref ws,
columnNumber,
columnWidth,
headerRow,
headerTitle,
headerFontSize,
headerBold,
headerUnderline,
headerWrapText,
headerHorizontalAlignment,
headerOrientation);
}
