sortproperties.html

永中OFFICE二次开发帮助文档

 sortProperties.setOrder1(true);
 sortProperties.setCustomListOrder(0);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setMatchCase(boolean)"><!-- --></A><H3>
setMatchCase</H3>
<PRE>
public void <B>setMatchCase</B>(boolean&nbsp;match)</PRE>
<DL>
<DD>设置排序时是否区分大小写。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setMatchCase</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>match</CODE> - 布尔型值，如为true，则排序时区分大小写；否则，不区分大小写
 <p>
 <b>例子：</b>
 <pre>  
 //此例设置排序时区分大小写。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setMatchCase(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setOrder1(boolean)"><!-- --></A><H3>
setOrder1</H3>
<PRE>
public void <B>setOrder1</B>(boolean&nbsp;order1)</PRE>
<DL>
<DD>设置主关键字排序方式。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setOrder1</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>order1</CODE> - 主关键字排序方式，布尔型值，其常量和相应的如下：
 <pre>
       SortOrderConstants.ASCENDING = true （按升序进行排序）
       SortOrderConstants.DECENDING = false（按降序进行排序）
 </pre>
 <p>
 <b>例子：</b>
 <pre> 
 //此例设置排序主关键字的索引值为1，并且排序方式为升序。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/SortOrderConstants.html" title="application.constants 中的接口"><CODE>SortOrderConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setOrder2(boolean)"><!-- --></A><H3>
setOrder2</H3>
<PRE>
public void <B>setOrder2</B>(boolean&nbsp;order2)</PRE>
<DL>
<DD>设置次要关键字排序方式。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setOrder2</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>order2</CODE> - 次要关键字排序方式，其常量和相应的如下：
 <pre>
       SortOrderConstants.ASCENDING = true（按升序进行排序）
       SortOrderConstants.DECENDING = false（按降序进行排序）
 </pre>
 <p>
 <b>例子：</b>
 <pre>
 //此例设置排序次要关键字的索引值为3，并且排序方式为升序。 
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setSortKey2(3);
 sortProperties.setOrder2(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/SortOrderConstants.html" title="application.constants 中的接口"><CODE>SortOrderConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setOrder3(boolean)"><!-- --></A><H3>
setOrder3</H3>
<PRE>
public void <B>setOrder3</B>(boolean&nbsp;order3)</PRE>
<DL>
<DD>设置第三关键字排序方式。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setOrder3</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>order3</CODE> - 第三关键字排序方式，其常量和相应的如下：
 <pre>
       SortOrderConstants.ASCENDING = true（按升序进行排序）
       SortOrderConstants.DECENDING =false（按降序进行排序）
 </pre>
 <p>
 <b>例子：</b>
 <pre>  
 //此例设置排序的第三关键字的索引值为2，并且排序方式为降序。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setSortKey2(3);
 sortProperties.setOrder2(true);
 sortProperties.setSortKey3(2);
 sortProperties.setOrder3(false);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/SortOrderConstants.html" title="application.constants 中的接口"><CODE>SortOrderConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setOrientation(boolean)"><!-- --></A><H3>
setOrientation</H3>
<PRE>
public void <B>setOrientation</B>(boolean&nbsp;orientation)</PRE>
<DL>
<DD>设置排序方向。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setOrientation</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>orientation</CODE> - 布尔型值，如为true，则按行排序；否则，按列排序
 <p>
 <b>例子：</b>
 <pre> 
 //此例设置排序方向为按列排序。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setOrientation(false);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setRowHeader(boolean)"><!-- --></A><H3>
setRowHeader</H3>
<PRE>
public void <B>setRowHeader</B>(boolean&nbsp;hasRowHeader)</PRE>
<DL>
<DD>设置是否包含标题行。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setRowHeader</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>hasRowHeader</CODE> - 布尔型值，如为true，则包含标题行；否则，不包含标题行 
 <p>
 <b>例子：</b>
 <pre>   
 //此例设置排序主关键字索引值为1，并且按升序排列，包含标题行。 
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);     
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSortKey1(int)"><!-- --></A><H3>
setSortKey1</H3>
<PRE>
public void <B>setSortKey1</B>(int&nbsp;key1)</PRE>
<DL>
<DD>设置排序主关键字。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setSortKey1</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>key1</CODE> - 排序主关键字索引
 <p>
 <b>例子：</b>
 <pre>
 //此例设置排序主关键字索引为1，并且排序方式为升序。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSortKey2(int)"><!-- --></A><H3>
setSortKey2</H3>
<PRE>
public void <B>setSortKey2</B>(int&nbsp;key2)</PRE>
<DL>
<DD>设置排序次要关键字。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setSortKey2</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>key2</CODE> - 次要关键字索引值
 <p>
 <b>例子：</b>
 <pre>   
 //此例设置排序次要关键字的索引值为3，并且排序方式为升序。 
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setSortKey2(3);
 sortProperties.setOrder2(true);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSortKey3(int)"><!-- --></A><H3>
setSortKey3</H3>
<PRE>
public void <B>setSortKey3</B>(int&nbsp;key3)</PRE>
<DL>
<DD>设置排序第三关键字。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.SortProperties</CODE> 中的 <CODE>setSortKey3</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>key3</CODE> - 第三关键字索引值
 <p>
 <b>例子：</b>
 <pre>
 //此例设置排序的第三关键字的索引值为2，并且排序方式为降序。
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = sheet.getRange("B4:E16");
 range.fillRandom();
 String[] heading = {"aa", "bb", "cc", "dd"};
 sheet.setCellValue(3, 2, heading, true);
 range = sheet.getRange("B3:E16");    
 SortProperties sortProperties = new SortProperties();
 sortProperties.setSortKey1(1);
 sortProperties.setOrder1(true);
 sortProperties.setSortKey2(3);
 sortProperties.setOrder2(true);
 sortProperties.setSortKey3(2);
 sortProperties.setOrder3(false);
 sortProperties.setRowHeader(true);
 range.sort(sortProperties);
 </pre></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/Rows.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/SsPictureFormat.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/SortProperties.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="SortProperties.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>