Range GetRange(int r1, int c1, int r2, int c2)
{
string cell1 = ExcelSupport.GetCellSymbol(r1, c1);
string cell2 = ExcelSupport.GetCellSymbol(r2, c2);
return(_sheet.get_Range(cell1, cell2));
}
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)
{
}
}
}
Range GetCell(int r, int c)
{
string cell = ExcelSupport.GetCellSymbol(r, c);
return(_sheet.get_Range(cell, cell));
}