public void SetText(
int row,
int col,
string text,
bool wrapText = false,
XlHAlign xlHAligh = XlHAlign.xlHAlignLeft,
XlVAlign xlVAlign = XlVAlign.xlVAlignCenter,
float orientation = 0,
float indetLevel = 0,
float fontSize = 12,
bool bold = false,
bool?mergeCells = null,
int?interiorColor = null,
int?fontColor = null) => range.SetText(row, col, text, wrapText, xlHAligh, xlVAlign, orientation, indetLevel, fontSize, bold, mergeCells, interiorColor, fontColor);
public static void SetText(
this Range rngHome,
int row,
int col,
string text,
bool wrapText = false,
XlHAlign xlHAligh = XlHAlign.xlHAlignLeft,
XlVAlign xlVAlign = XlVAlign.xlVAlignCenter,
float orientation = 0,
float indetLevel = 0,
float fontSize = 12,
bool bold = false,
bool?mergeCells = false,
int?interiorColor = null,
int?fontColor = null)
{
var rng = (Range)rngHome.Cells[row, col];
rng.SetText(text, wrapText, xlHAligh, xlVAlign, orientation, indetLevel, fontSize, bold, mergeCells, interiorColor, fontColor);
}
public static void SetText(
this Range rngHome,
string text,
bool?wrapText = null,
XlHAlign xlHAligh = XlHAlign.xlHAlignLeft,
XlVAlign xlVAlign = XlVAlign.xlVAlignCenter,
float orientation = 0,
float indetLevel = 0,
float fontSize = 12,
bool bold = false,
bool?mergeCells = null,
int?interiorColor = null,
int?fontColor = null)
{
rngHome.Value2 = text;
rngHome.HorizontalAlignment = xlHAligh;
rngHome.VerticalAlignment = xlVAlign;
rngHome.Font.Size = fontSize;
rngHome.Font.Bold = bold;
rngHome.IndentLevel = indetLevel;
rngHome.Orientation = orientation;
rngHome.WrapText = wrapText;
if (wrapText.HasValue)
{
rngHome.WrapText = wrapText;
}
if (interiorColor.HasValue)
{
rngHome.Interior.Color = interiorColor.Value;
}
if (fontColor.HasValue)
{
rngHome.Font.Color = fontColor.Value;
}
if (mergeCells.HasValue && mergeCells.Value)
{
rngHome.Merge();
}
}
/// <summary>
/// Cambiar la alineación del texto de las celdas seleccionadas.
/// <param name="vertical">Alineación vertical</param>
/// <param name="horizontal">Alineación horizontal</param>
/// </summary>
public override void cambiarAlineacionTexto(AlineacionVertical vertical, AlineacionHorizontal horizontal)
{
XlVAlign alineacion_vertical = XlVAlign.xlVAlignBottom;
XlHAlign alineacion_horizontal = XlHAlign.xlHAlignLeft;
switch (vertical)
{
case AlineacionVertical.Centro: alineacion_vertical = XlVAlign.xlVAlignCenter; break;
case AlineacionVertical.Arriba: alineacion_vertical = XlVAlign.xlVAlignTop; break;
case AlineacionVertical.Abajo: alineacion_vertical = XlVAlign.xlVAlignBottom; break;
case AlineacionVertical.Justificado: alineacion_vertical = XlVAlign.xlVAlignJustify; break;
case AlineacionVertical.Distribuido: alineacion_vertical = XlVAlign.xlVAlignDistributed; break;
}
switch (horizontal)
{
case AlineacionHorizontal.Centro: alineacion_horizontal = XlHAlign.xlHAlignCenter; break;
case AlineacionHorizontal.Izquierda: alineacion_horizontal = XlHAlign.xlHAlignLeft; break;
case AlineacionHorizontal.Derecha: alineacion_horizontal = XlHAlign.xlHAlignRight; break;
case AlineacionHorizontal.Lleno: alineacion_horizontal = XlHAlign.xlHAlignFill; break;
case AlineacionHorizontal.Justificado: alineacion_horizontal = XlHAlign.xlHAlignJustify; break;
case AlineacionHorizontal.Distribuido: alineacion_horizontal = XlHAlign.xlHAlignDistributed; break;
case AlineacionHorizontal.General: alineacion_horizontal = XlHAlign.xlHAlignGeneral; break;
}
_seleccionado.VerticalAlignment = alineacion_vertical;
_seleccionado.HorizontalAlignment = alineacion_horizontal;
}
private void RangeSetting(Range rng, string fontName, int fontSize, bool isBold, XlHAlign hAlignment, XlVAlign vAlignment, string text, int colorIndex)
{
rng.Font.Name = fontName;
rng.Font.Size = fontSize;
rng.Font.Bold = isBold ? 1 : 0;
rng.Interior.ColorIndex = colorIndex;
rng.HorizontalAlignment = hAlignment;
rng.VerticalAlignment = vAlignment;
rng.Value2 = text;
}
void insertFormatData(ExcelFormatData formatData)
{
foreach (ExcelRangeInfo range in formatData.Ranges)
{
Range rng = GetRange(range);
try
{
if (formatData.Foreground.HasValue)
{
rng.Font.Color = ColorTranslator.ToOle(formatData.Foreground.Value);
}
if (formatData.Background.HasValue)
{
rng.Interior.Color = ColorTranslator.ToOle(formatData.Background.Value);
}
if (formatData.FontSize.HasValue)
{
rng.Font.Size = formatData.FontSize.Value;
}
if (formatData.IsFontBold.HasValue)
{
rng.Font.Bold = formatData.IsFontBold.Value;
}
if (formatData.IsFontItalic.HasValue)
{
rng.Font.Italic = formatData.IsFontItalic.Value;
}
if (formatData.IsWrapped.HasValue)
{
rng.WrapText = formatData.IsWrapped.Value;
}
if (formatData.IsCoumnAutofit.HasValue)
{
foreach (Range col in rng.Columns)
{
col.EntireColumn.AutoFit();
}
}
if (formatData.HorizontalAlignment.HasValue)
{
XlHAlign horizAlignment = (XlHAlign)formatData.HorizontalAlignment.Value;
rng.HorizontalAlignment = horizAlignment;
}
if (formatData.Vertical.HasValue)
{
XlVAlign verticalAlignment = (XlVAlign)formatData.Vertical.Value;
rng.VerticalAlignment = verticalAlignment;
}
if (formatData.IsPrintArea.HasValue && formatData.IsPrintArea.Value)
{
_sheet.PageSetup.PrintArea = rng.Address;
_sheet.DisplayPageBreaks = true;
}
if (formatData.ColumnWidths != null)
{
for (int c = 0; c < formatData.ColumnWidths.Length; ++c)
{
int col = range.Start.Column + c;
string colSymbol = ExcelSupport.GetColumnSymbol(col);
string colRange = string.Format("{0}:{1}", colSymbol, colSymbol);
int width = formatData.ColumnWidths[c];
_sheet.get_Range(colRange).EntireColumn.ColumnWidth = width;
}
}
}
catch (Exception exc)
{
}
}
}
