internal void CreateRange(int row, int column, object value, XmlStyle style) { sheet[column - 1, row - 1].Value = value; Range r = new Range(sheet[column - 1, row - 1], sheet[column - 1, row - 1]); r.Style = style; }
internal void MakeRangeAlignment(int row_start, int column_start, int row_end, int column_end, HorizontalAlignment horizontal, VerticalAlignment vertical) { AlignmentOptionsBase ao = new Range(sheet[column_start - 1, row_start - 1], sheet[column_end - 1, row_end - 1]).Alignment as AlignmentOptionsBase; ao.Horizontal = horizontal; ao.Vertical = vertical; }
internal void CreateRange(int row, int column, int rowSpan, int colSpan, object value) { sheet[column - 1, row - 1].Value = value; Range r = new Range(sheet[column - 1, row - 1], sheet[column - 1 + colSpan - 1, row - 1 + rowSpan - 1]); if (rowSpan > 1 || colSpan > 1) { r.Merge(); } }