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