range.html
来自「永中OFFICE二次开发帮助文档」· HTML 代码 · 共 1,358 行 · 第 1/5 页
HTML
1,358 行
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Range.html#paste(boolean)">paste</A></B>(boolean withFormat)</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/Range.html#pasteAsHyperlink()">pasteAsHyperlink</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/Range.html#pasteLink()">pasteLink</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/Range.html#pasteLink(boolean)">pasteLink</A></B>(boolean withFormat)</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/Range.html#pasteSpecial(int, int, boolean, boolean)">pasteSpecial</A></B>(int pasteFlag,
int operationFlag,
boolean skipFlag,
boolean transposeFlag)</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/Range.html#protect(int, java.lang.String)">protect</A></B>(int type,
java.lang.String password)</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/Range.html#removeDuplicatedItems(int[], boolean, boolean, boolean)">removeDuplicatedItems</A></B>(int[] items,
boolean hasTitle,
boolean blank,
boolean output)</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/Range.html#removeSubtotal()">removeSubtotal</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/Range.html#replaceAllWith(java.lang.String, java.lang.String)">replaceAllWith</A></B>(java.lang.String findWhat,
java.lang.String replaceWith)</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/Range.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/Range.html#setAlternateBackground(application.workbooks.workbook.style.fill.FillAttribute)">setAlternateBackground</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/Range.html#setAutoFilter()">setAutoFilter</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/Range.html#setAutoFormat(int)">setAutoFormat</A></B>(int index)</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/Range.html#setAutoFormat(int, boolean, boolean, boolean, boolean, boolean, boolean)">setAutoFormat</A></B>(int index,
boolean number,
boolean font,
boolean alignment,
boolean border,
boolean pattern,
boolean widthHight)</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/Range.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/Range.html#setConditionalFormatting(application.workbooks.workbook.worksheets.worksheet.ConditionalFormatting)">setConditionalFormatting</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/ConditionalFormatting.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">ConditionalFormatting</A> cf)</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/Range.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/Range.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/Range.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/Range.html#setFormulaArray(java.lang.String)">setFormulaArray</A></B>(java.lang.String value)</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/Range.html#setName(java.lang.String)">setName</A></B>(java.lang.String name)</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/Range.html#setOutline(boolean, boolean)">setOutline</A></B>(boolean isRowSelected,
boolean isColumnSelected)</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/Range.html#setValidation(application.workbooks.workbook.worksheets.worksheet.ValidationProperties)">setValidation</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/ValidationProperties.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">ValidationProperties</A> validationProperties)</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/Range.html#setValue(boolean)">setValue</A></B>(boolean value)</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/Range.html#setValue(double)">setValue</A></B>(double value)</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/Range.html#setValue(long)">setValue</A></B>(long value)</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/Range.html#setValue(java.lang.String)">setValue</A></B>(java.lang.String value)</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/Range.html#showDetail()">showDetail</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/Range.html#sort(application.workbooks.workbook.worksheets.worksheet.SortProperties)">sort</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/SortProperties.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">SortProperties</A> sortProperties)</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/Range.html#subtotal(int, int, int[], boolean, boolean, boolean, java.lang.String)">subtotal</A></B>(int fieldIndex,
int styleIndex,
int[] item,
boolean change,
boolean pageBreak,
boolean result,
java.lang.String aimAddress)</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/Range.html#textSplitting(application.workbooks.workbook.worksheets.worksheet.TextSplittingProperties)">textSplitting</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/TextSplittingProperties.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">TextSplittingProperties</A> textSplitting)</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/Range.html#ungroup(boolean)">ungroup</A></B>(boolean isRow)</CODE>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?