conditionalformattingdata.html

永中OFFICE二次开发帮助文档

 <b>例子：</b>
 <pre>
 //在单元格区域"C7:F14"中，将单元格数值介于0.3至0.6的单元格上，下，左，右边框的宽度设置为0.5。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 BorderAttribute border = new BorderAttribute();
 border.setApplyType(BorderAndShadingConstants.APPLY_CELL);
 border.setBorderType(BorderAndShadingConstants.BORDERTYPE_NONE);
 border.setBorderLineType(BorderAndShadingConstants.LEFT,0);
 border.setBorderLineWidth(BorderAndShadingConstants.LEFT,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.TOP,0);
 border.setBorderLineWidth(BorderAndShadingConstants.TOP,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.RIGHT,0);
 border.setBorderLineWidth(BorderAndShadingConstants.RIGHT,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.BOTTOM,0);
 border.setBorderLineWidth(BorderAndShadingConstants.BOTTOM,0.5f);
 formattingData.setBorderAttribute(border);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFontAttribute(application.workbooks.workbook.style.font.FontAttribute)"><!-- --></A><H3>
setFontAttribute</H3>
<PRE>
public void <B>setFontAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A>&nbsp;font)</PRE>
<DL>
<DD>设置条件格式化的字体。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>font</CODE> - 条件格式化的字体
 <p>
 <b>例子：</b>
 <pre>
 //将符合条件格式区域的字体前景色设置为红色。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 FontAttribute font = new FontAttribute();
 font.setForeground(Color.red);
 formattingData.setFontAttribute(font);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFormula1(java.lang.String)"><!-- --></A><H3>
setFormula1</H3>
<PRE>
public void <B>setFormula1</B>(java.lang.String&nbsp;value)</PRE>
<DL>
<DD>设置与条件格式相关的表达式或数值，可为常量、字符串、单元格引用或公式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 与条件格式相关的表达式或数值
 <p>
 <b>例子：</b>
 <pre>
 //在"C7:F14"单元格区域中，将单元格值介于0.3至0.6的单元格内容的前景色设为红色。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 FontAttribute font = new FontAttribute();
 font.setForeground(Color.red);
 formattingData.setFontAttribute(font);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFormula2(java.lang.String)"><!-- --></A><H3>
setFormula2</H3>
<PRE>
public void <B>setFormula2</B>(java.lang.String&nbsp;value)</PRE>
<DL>
<DD>当运算符为“介于”或“未介于”时，设置与条件格式第二部分相关的表达式或数值（否则，则忽略本参数）。可为常量、字符串、单元格引用或公式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 与条件格式相关的表达式或数值
 <p>
 <b>例子：</b>
 <pre>
 //设置条件格式为介于0.3至0.6。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 FontAttribute font = new FontAttribute();
 font.setForeground(Color.red);
 formattingData.setFontAttribute(font);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setHowIndex(int)"><!-- --></A><H3>
setHowIndex</H3>
<PRE>
public void <B>setHowIndex</B>(int&nbsp;index)</PRE>
<DL>
<DD>设置条件运算符类型。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>index</CODE> - 条件运算符类型,如果条件格式是基于表达式，则设置无效，其取值为如下常量: 
 <pre>
     BETWEEN -- 介于
     NOT_BETWEEN -- 不介于  
     EQUALS -- 等于
     NOT_EQUALS -- 不等于  
     GREATER_THAN -- 大于
     LESS_THAN -- 小于  
     GREATER_THAN_OR_EQUALS -- 大于等于
     LESS_THAN_OR_EQUALS -- 小于等于  
 </pre>
 <p>
 <b>例子：</b>
 <pre>
 //设置条件运算符类型为介于。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 FontAttribute font = new FontAttribute();
 font.setForeground(Color.red);
 formattingData.setFontAttribute(font);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="setWhatIndex(int)"><!-- --></A><H3>
setWhatIndex</H3>
<PRE>
public void <B>setWhatIndex</B>(int&nbsp;type)</PRE>
<DL>
<DD>指定条件格式是基于单元格值还是基于表达式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 类型，其取值为如下常量:  
 <pre>
     VALUE_IS  基于单元格值
     FORMULA_IS  基于表达式  
 <p>
 <b>例子：</b>
 <pre>
 //设置基于单元格的条件格式。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("C7:F14");
 range.fillRandom();
 ConditionalFormatting conditionalFormatting = new ConditionalFormatting();
 ConditionalFormattingData  formattingData = new ConditionalFormattingData();
 formattingData.setWhatIndex(ConditionConstants.VALUE_IS);
 formattingData.setHowIndex(ConditionConstants.BETWEEN);
 formattingData.setFormula1("0.3");
 formattingData.setFormula2("0.6");
 FontAttribute font = new FontAttribute();
 font.setForeground(Color.red);
 formattingData.setFontAttribute(font);
 conditionalFormatting.add(formattingData);
 range.setConditionalFormatting(conditionalFormatting);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="跳过导航链接"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>概述</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>软件包</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>类</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>树</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>索引</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>帮助</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/ConditionalFormatting.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>下一个类</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?application/workbooks/workbook/worksheets/worksheet/ConditionalFormattingData.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="ConditionalFormattingData.html" target="_top"><B>无框架</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>所有类</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>所有类</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  摘要：&nbsp;嵌套&nbsp;|&nbsp;字段&nbsp;|&nbsp;<A HREF="#constructor_summary">构造方法</A>&nbsp;|&nbsp;<A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息：&nbsp;字段&nbsp;|&nbsp;<A HREF="#constructor_detail">构造方法</A>&nbsp;|&nbsp;<A HREF="#method_detail">方法</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>
版权所有 2001-2006 无锡永中科技有限公司
</BODY>
</HTML>