/// <summary>
/// 设置条件格式.
/// </summary>
/// <param name="fromSheetName"> 需要设置条件格式的 Sheet 名字.</param>
/// <param name="baseAddress"> 基准地址. </param>
/// <param name="startAddress"> 起始地址. </param>
/// <param name="subRow"> 结束行递减数量. </param>
/// <param name="subCol"> 结束列递减数量. </param>
/// <param name="oper"> 公式的判断方式. </param>
/// <param name="formula1"> 条件公式. </param>
/// <param name="bold"> 满足条件后的行 是否粗体. </param>
/// <param name="italic"> 满足条件后的行 是否斜体. </param>
/// <param name="color"> 满足条件后的行 字体的颜色. </param>
public void SetFormatConditionsCellValueLessEqual(
string fromSheetName,
string baseAddress,
string startAddress,
int subRow,
int subCol,
ExcelFormatConditionOperator oper,
string formula1,
bool bold,
bool italic,
int color)
{
// 选择源工作表.
Excel.Worksheet mySheet = (Excel.Worksheet)xlBook.Sheets.get_Item(fromSheetName);
// 选择
mySheet.Select();
// 范围选择.
string finishAddress = GetEndAddress(mySheet, baseAddress, subRow, subCol);
Excel.Range myRange = mySheet.Range[startAddress, finishAddress];
// 设置公式.
Excel.FormatCondition myCond = myRange.FormatConditions.Add(
Excel.XlFormatConditionType.xlCellValue,
oper,
formula1);
// 设置条件字体.
myCond.Font.Bold = bold;
myCond.Font.Italic = italic;
myCond.Font.Color = color;
}
/// <summary>
/// 设置条件格式.
/// </summary>
/// <param name="fromSheetName"> 需要设置条件格式的 Sheet 名字.</param>
/// <param name="baseAddress"> 基准地址. </param>
/// <param name="startAddress"> 起始地址. </param>
/// <param name="subRow"> 结束行递减数量. </param>
/// <param name="subCol"> 结束列递减数量. </param>
/// <param name="oper"> 公式的判断方式. </param>
/// <param name="formula1"> 条件公式. </param>
/// <param name="bold"> 满足条件后的行 是否粗体. </param>
/// <param name="italic"> 满足条件后的行 是否斜体. </param>
/// <param name="color"> 满足条件后的行 字体的颜色. </param>
public void SetFormatConditionsCellValueLessEqual(
string fromSheetName,
string baseAddress,
string startAddress,
int subRow,
int subCol,
ExcelFormatConditionOperator oper,
string formula1,
bool bold,
bool italic,
int color)
{
// 选择源工作表.
Excel.Worksheet mySheet = (Excel.Worksheet)xlBook.Sheets.get_Item(fromSheetName);
// 选择
mySheet.Select();
// 范围选择.
string finishAddress = GetEndAddress(mySheet, baseAddress, subRow, subCol);
Excel.Range myRange = mySheet.Range[startAddress, finishAddress];
// 设置公式.
Excel.FormatCondition myCond = myRange.FormatConditions.Add(
Excel.XlFormatConditionType.xlCellValue,
oper,
formula1);
// 设置条件字体.
myCond.Font.Bold = bold;
myCond.Font.Italic = italic;
myCond.Font.Color = color;
}
