columns.html

永中OFFICE二次开发帮助文档

public int <B>getEndColumn</B>()</PRE>
<DL>
<DD>获取结束列列号。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>结束列列号，为整型数值
 <p>
 <b>例子：</b>
 <pre>
 //获取第三列至第五列的结束列的列号。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 int end = columns.getEndColumn();
 System.out.println(end);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getRange()"><!-- --></A><H3>
getRange</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> <B>getRange</B>()</PRE>
<DL>
<DD>取得对应的Range对象。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>Range对象
 <p>
 <b>例子：</b>
 <pre>
 //取得第三列至第五列所对应的Range对象。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 Range range = columns.getRange();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getStartColumn()"><!-- --></A><H3>
getStartColumn</H3>
<PRE>
public int <B>getStartColumn</B>()</PRE>
<DL>
<DD>获取起始列列号。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>起始列号，为整型数值
 <p>
 <b>例子：</b>
 <pre>
 //获取第三列至第五列的起始列的列号。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 int start = columns.getStartColumn();
 System.out.println(start);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getWorksheet()"><!-- --></A><H3>
getWorksheet</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/Worksheet.html" title="application.workbooks.workbook.worksheets 中的类">Worksheet</A> <B>getWorksheet</B>()</PRE>
<DL>
<DD>返回所属的Worksheet对象。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>Worksheet对象
 <p>
 <b>例子：</b>
 <pre>
 //返回第一列至第三列所属的Worksheet对象。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns("a:c");
 columns.getWorksheet();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasMultiColumns()"><!-- --></A><H3>
hasMultiColumns</H3>
<PRE>
public boolean <B>hasMultiColumns</B>()</PRE>
<DL>
<DD>返回选定区域是否包含多个子区域。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>是否含有多个选定区域
 <p>
 <b>例子：</b>
 <pre>
 //本示例将在当前活动的工作表中选择“a列至b列，f列至k列”，输出当前选定区域是否包含多个子区域
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns("a:b,f:k"); 
 System.out.println(columns.hasMultiColumns());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="isColumnHidden()"><!-- --></A><H3>
isColumnHidden</H3>
<PRE>
public boolean <B>isColumnHidden</B>()</PRE>
<DL>
<DD>判断列是否被隐藏。
 <p>
<P>
<DD><DL>

<DT><B>返回：</B><DD>布尔型值，如果当前列被隐藏，返回true；否则返回false
 <p>
 <b>例子：</b>
 <pre>
 //判断第三列至第五列是否被隐藏。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 boolean hidden = columns.isColumnHidden();
 System.out.println(hidden);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="select()"><!-- --></A><H3>
select</H3>
<PRE>
public void <B>select</B>()</PRE>
<DL>
<DD>选中指定列。
 <p>
 <b>例子：</b>
 <pre>
 //选中第一列至第三列。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns("a:c");
 columns.select();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setBorderAttribute(application.workbooks.workbook.style.border.BorderAttribute)"><!-- --></A><H3>
setBorderAttribute</H3>
<PRE>
public void <B>setBorderAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/border/BorderAttribute.html" title="application.workbooks.workbook.style.border 中的类">BorderAttribute</A>&nbsp;ba)</PRE>
<DL>
<DD>设置边框属性。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>ba</CODE> - 边框属性   
 <p>
 <b>例子：</b>
 <pre>
 //设置第三列至第五列单元格的边框属性。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 BorderAttribute border = new BorderAttribute();
 border.setApplyType(BorderAndShadingConstants.APPLY_CELL);
 border.setBorderType(BorderAndShadingConstants.BORDERTYPE_CUSTOM);
 border.setBorderLineType(BorderAndShadingConstants.LEFT,0);
 border.setBorderLineWidth(BorderAndShadingConstants.LEFT,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.RIGHT,0);
 border.setBorderLineWidth(BorderAndShadingConstants.RIGHT,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.MIDDLE_VERTICAL,0);
 border.setBorderLineWidth(BorderAndShadingConstants.MIDDLE_VERTICAL,0.5f);
 columns.setBorderAttribute(border);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setColumnHidden(boolean)"><!-- --></A><H3>
setColumnHidden</H3>
<PRE>
public void <B>setColumnHidden</B>(boolean&nbsp;hide)</PRE>
<DL>
<DD>隐藏列。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>hide</CODE> - 布尔型值，如为true，隐藏当前列；否则不隐藏当前列
 <p>
 <b>例子：</b>
 <pre>
 //隐第三列至第五列。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 columns.setColumnHidden(true);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setColumnWidth(double)"><!-- --></A><H3>
setColumnWidth</H3>
<PRE>
public void <B>setColumnWidth</B>(double&nbsp;width)</PRE>
<DL>
<DD>为当前列设置列宽(默认度量单位:磅)。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>width</CODE> - 设置的列宽，为double型,单位:磅,其取值范围在0至1530.0 磅
 <p>
 <b>例子：</b>
 <pre>
 //设置第三列至第五列的列宽为20毫米。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 double ptValue = Utilities.otherToPoint(20.0,UnitConstants.MILLIMETER);
 columns.setColumnWidth(ptValue);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="setFillAttribute(application.workbooks.workbook.style.fill.FillAttribute)"><!-- --></A><H3>
setFillAttribute</H3>
<PRE>
public void <B>setFillAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A>&nbsp;fa)</PRE>
<DL>
<DD>设置填充属性。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fa</CODE> - 填充属性    
 <p>
 <b>例子：</b>
 <pre>
 //设置第三列至第五列的填充属性。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 FillAttribute fill = new FillAttribute();
 fill.setTexture(255,204,153);
 columns.setFillAttribute(fill);
 </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;ca)</PRE>
<DL>
<DD>设置字体属性。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>ca</CODE> - 字体属性   
 <p>
 <b>例子：</b>
 <pre>
 //设置第三列至第五列单元格的字体属性。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 FontAttribute font = new FontAttribute();
 font.setBold(true);
 font.setForeground(255,0,0);
 font.setStrikeThrough(true);
 columns.setFontAttribute(font);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFormatCellAttribute(application.workbooks.workbook.worksheets.FormatCellAttribute)"><!-- --></A><H3>
setFormatCellAttribute</H3>
<PRE>
public void <B>setFormatCellAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/FormatCellAttribute.html" title="application.workbooks.workbook.worksheets 中的类">FormatCellAttribute</A>&nbsp;attr)</PRE>
<DL>
<DD>设置单元格格式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>attr</CODE> - 单元格格式   
 <p>
 <b>例子：</b>
 <pre>
 //设置第三列至第五列单元格的格式。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Columns columns = worksheet.getColumns(3,5);
 FormatCellAttribute fcAttribute = new FormatCellAttribute();
 fcAttribute.setHorizontalIndex(CellFormatConstants.HOR_MIDDLE);
 columns.setFormatCellAttribute(fcAttribute);
 </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/Characters.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;下一个类</FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?application/workbooks/workbook/worksheets/worksheet/Columns.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="Columns.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;构造方法&nbsp;|&nbsp;<A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息：&nbsp;字段&nbsp;|&nbsp;构造方法&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>