📄 rows.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<!-- Generated by javadoc (build 1.6.0) on Fri Feb 29 09:23:18 CST 2008 -->
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<TITLE>
Rows (永中集成Office二次开发API文档)
</TITLE>
<META NAME="date" CONTENT="2008-02-29">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">
<SCRIPT type="text/javascript">
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="Rows (永中集成Office二次开发API文档)";
}
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>
</HEAD>
<BODY BGCOLOR="white" onload="windowTitle();">
<HR>
<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="跳过导航链接"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_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> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>软件包</B></FONT></A> </TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>类</B></FONT> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>树</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>索引</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>帮助</B></FONT></A> </TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>上一个类</B></A>
<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/SortProperties.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/Rows.html" target="_top"><B>框架</B></A>
<A HREF="Rows.html" target="_top"><B>无框架</B></A>
<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">
摘要： 嵌套 | 字段 | 构造方法 | <A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息： 字段 | 构造方法 | <A HREF="#method_detail">方法</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->
<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
application.workbooks.workbook.worksheets.worksheet</FONT>
<BR>
类 Rows</H2>
<PRE>
java.lang.Object
<IMG SRC="../../../../../resources/inherit.gif" ALT="继承者 "><B>application.workbooks.workbook.worksheets.worksheet.Rows</B>
</PRE>
<HR>
<DL>
<DT><PRE>public class <B>Rows</B><DT>extends java.lang.Object</DL>
</PRE>
<P>
该类为整行对象定义了插入行，设置行高和隐藏行等方法。 <p>
<P>
<P>
<DL>
<DT><B>从以下版本开始：</B></DT>
<DD>V1.1 <p></DD>
</DL>
<HR>
<P>
<!-- ========== METHOD SUMMARY =========== -->
<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>方法摘要</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#applyStandardRowHeight()">applyStandardRowHeight</A></B>()</CODE>
<BR>
应用标准行高。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#autoFit()">autoFit</A></B>()</CODE>
<BR>
为该选定行设置最佳行高。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Rows</A>[]</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getAllRows()">getAllRows</A></B>()</CODE>
<BR>
如果当前选定区域包含多个子区域，返回所有的选定区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getCount()">getCount</A></B>()</CODE>
<BR>
返回当前选定行的数目。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getEndRow()">getEndRow</A></B>()</CODE>
<BR>
得到结束行行号。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getRange()">getRange</A></B>()</CODE>
<BR>
取得对应的Range对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getStartRow()">getStartRow</A></B>()</CODE>
<BR>
获得起始行的行号。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../application/workbooks/workbook/worksheets/Worksheet.html" title="application.workbooks.workbook.worksheets 中的类">Worksheet</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#getWorksheet()">getWorksheet</A></B>()</CODE>
<BR>
返回所属的Worksheet对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#hasMultiRows()">hasMultiRows</A></B>()</CODE>
<BR>
返回当前选定区域是否包含多个子区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#isRowHidden()">isRowHidden</A></B>()</CODE>
<BR>
判断行是否被隐藏。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#select()">select</A></B>()</CODE>
<BR>
选中指定行。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setBorderAttribute(application.workbooks.workbook.style.border.BorderAttribute)">setBorderAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/border/BorderAttribute.html" title="application.workbooks.workbook.style.border 中的类">BorderAttribute</A> ba)</CODE>
<BR>
设置边框属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setFillAttribute(application.workbooks.workbook.style.fill.FillAttribute)">setFillAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A> fa)</CODE>
<BR>
设置填充属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setFontAttribute(application.workbooks.workbook.style.font.FontAttribute)">setFontAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A> fa)</CODE>
<BR>
设置字体属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setFormatCellAttribute(application.workbooks.workbook.worksheets.FormatCellAttribute)">setFormatCellAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/FormatCellAttribute.html" title="application.workbooks.workbook.worksheets 中的类">FormatCellAttribute</A> attr)</CODE>
<BR>
设置单元格格式。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setRowHeight(double)">setRowHeight</A></B>(double height)</CODE>
<BR>
设置该选定行的行高(默认度量单位:磅)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html#setRowHidden(boolean)">setRowHidden</A></B>(boolean hide)</CODE>
<BR>
隐藏该选定行。</TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>从类 java.lang.Object 继承的方法</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
<P>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>方法详细信息</B></FONT></TH>
</TR>
</TABLE>
<A NAME="applyStandardRowHeight()"><!-- --></A><H3>
applyStandardRowHeight</H3>
<PRE>
public void <B>applyStandardRowHeight</B>()</PRE>
<DL>
<DD>应用标准行高。 <p> <b>例子：</b> <pre> //对第三行至第五行应用标准行高。 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); Rows rows = worksheet.getRows(3,5); rows.applyStandardRowHeight(); </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="autoFit()"><!-- --></A><H3>
autoFit</H3>
<PRE>
public void <B>autoFit</B>()</PRE>
<DL>
<DD>为该选定行设置最佳行高。 <p> <b>例子：</b> <pre> //为第三行至第五行设置最佳行高。 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); Rows rows = worksheet.getRows(3,5); rows.autoFit(); </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getAllRows()"><!-- --></A><H3>
getAllRows</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Rows</A>[] <B>getAllRows</B>()</PRE>
<DL>
<DD>如果当前选定区域包含多个子区域，返回所有的选定区域。 <p>
<P>
<DD><DL>
<DT><B>返回：</B><DD>所有的选定区域 <p> <b>例子：</b> <pre> //本示例将在当前活动的工作表中选择“1行至2行，6行至10行”，输出当前选定区域中每个子区域的起始行和终止行。 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); Rows row = worksheet.getRows("1:2,6:10"); row.select(); Rows[] rows = row.getAllRows(); </pre></DL>
</DD>
</DL>
<HR>
<A NAME="getCount()"><!-- --></A><H3>
getCount</H3>
<PRE>
public int <B>getCount</B>()</PRE>
<DL>
<DD>返回当前选定行的数目。 <p> 当应用于含多个选定区域的 Rows 对象时，该属性只返回该区域中第一个子区域内的行。 <p> 例如，如果 Rows 对象有两个子区域：1:2 和 3:4，则 getCount 返回 2 而不是 4。 <p> 若要在一个可能包含多个选定区域的区域中使用该属性，请测试 hasMultiRows 来判断该区域是否包含多个子区域。 <p>
<P>
<DD><DL>
<DT><B>返回：</B><DD>选定行的数目 <p> <b>例子：</b> <pre> //返回第三行至第五行的行的数目。 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); int count = worksheet.getRows(1,3).getCount(); System.out.println(count); </pre></DL>
</DD>
</DL>
<HR>
<A NAME="getEndRow()"><!-- --></A><H3>
getEndRow</H3>
<PRE>
public int <B>getEndRow</B>()</PRE>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -