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