/// <summary>
/// 设定单元格字体颜色
/// </summary>
/// <param name="wSheet"></param>
/// <param name="rows"></param>
/// <param name="cols"></param>
/// <param name="rColor"></param>
public void SetCellFontColor(Worksheet wSheet, int rows, int cols, ExcelColorIndex rColor) //会修改上一行及指定行？
{
try
{
if (wSheet == null)
{
throw new Exception("工作表为空");
}
Range eRange = wSheet.get_Range(wSheet.Cells[rows, cols], wSheet.Cells[rows, cols]);
eRange.Font.ColorIndex = rColor;
}
catch (Exception excep)
{
throw new Exception("设置指定单元格字体颜色失败,可能原因为:" + excep.Message);
}
}
/// <summary>
/// 设置某行背景色
/// </summary>
/// <param name="wSheet">工作表</param>
/// <param name="rows">行数</param>
/// <param name="rColor">颜色</param>
public void SetRowBackgroundColor(Worksheet wSheet, int rows, ExcelColorIndex rColor)
{
try
{
if (wSheet == null)
{
throw new Exception("工作表为空");
}
Range eRange = ((Range)wSheet.Rows[rows.ToString() + ":" + rows.ToString(), System.Type.Missing]);
eRange.Interior.ColorIndex = rColor;
}
catch (Exception excep)
{
throw new Exception("设置指定行背景色失败,可能原因为:" + excep.Message);
}
}
/// <summary>
/// 指定单元格的背景色
/// </summary>
/// <param name="wSheet"></param>
/// <param name="rows"></param>
/// <param name="cols"></param>
/// <param name="rColor"></param>
public void SetCellBackgroundColor(Worksheet wSheet, int rows, int cols, ExcelColorIndex rColor)
{
try
{
if (wSheet == null)
{
throw new Exception("工作表为空");
}
//Excel.Range eRange = wSheet.get_Range(wSheet.Cells[rows, cols], wSheet.Cells[rows, cols]);
Range eRange = (Range)wSheet.Cells.get_Item(rows, cols);
eRange.Interior.ColorIndex = rColor;
}
catch (Exception excep)
{
throw new Exception("设置指定单元格背景色失败,可能原因为:" + excep.Message);
}
}
public void SetRowFontColor(Worksheet wSheet, int iRow, ExcelColorIndex rColor)
{
try
{
if (wSheet == null)
{
throw new Exception("工作表为空");
}
int iCol = GetColumnsCount(wSheet);
Range eRange = ((Range)wSheet.get_Range(wSheet.Cells[iRow, 1], wSheet.Cells[iRow, iCol]));
eRange.Font.ColorIndex = rColor;
}
catch (Exception excep)
{
throw new Exception("设置指定行背景色失败,可能原因为:" + excep.Message);
}
}