📄 textsplittingproperties.html
字号:
<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/TextSplittingProperties.html#setFileName(java.lang.String)">setFileName</A></B>(java.lang.String fileName)</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/TextSplittingProperties.html#setOther(boolean)">setOther</A></B>(boolean other)</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/TextSplittingProperties.html#setOtherDelimiters(char)">setOtherDelimiters</A></B>(char otherDelimiters)</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/TextSplittingProperties.html#setSemicolon(boolean)">setSemicolon</A></B>(boolean semicolon)</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/TextSplittingProperties.html#setSpace(boolean)">setSpace</A></B>(boolean space)</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/TextSplittingProperties.html#setSplittingType(int)">setSplittingType</A></B>(int splittingType)</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/TextSplittingProperties.html#setStartRow(int)">setStartRow</A></B>(int startRow)</CODE>
<BR>
设置导入起始行（默认为1）。</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/TextSplittingProperties.html#setTab(boolean)">setTab</A></B>(boolean tab)</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/TextSplittingProperties.html#setTextQualifier(int)">setTextQualifier</A></B>(int textQualifier)</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/TextSplittingProperties.html#setThousandsSeparator(int)">setThousandsSeparator</A></B>(int thousandsSeparator)</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>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<A NAME="constructor_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="TextSplittingProperties()"><!-- --></A><H3>
TextSplittingProperties</H3>
<PRE>
public <B>TextSplittingProperties</B>()</PRE>
<DL>
<DD>默认构件器。
<P>
</DL>
<!-- ============ 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="getColumn()"><!-- --></A><H3>
getColumn</H3>
<PRE>
public int <B>getColumn</B>()</PRE>
<DL>
<DD>得到单元格列号。
<P>
<DD><DL>
<DT><B>返回：</B><DD>列号 <p> <b>例子：</b> <pre> //在控制台输出应用文本分裂属性单元格的列号。 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); sheet.setCellValue(3,7,"a b c"); sheet.setCellValue(4,7,"x y z"); Range range = sheet.getRange("G3:G4"); TextSplittingProperties textSplitting = new TextSplittingProperties(); textSplitting.setSplittingType(TextSplittingConstants.DELIMITED); textSplitting.setTab(true); textSplitting.setSpace(true); textSplitting.setSemicolon(false); textSplitting.setComma(false); textSplitting.setOther(false); textSplitting.setOtherDelimiters(' '); textSplitting.setDimilitersAsOne(false); textSplitting.setTextQualifier(TextSplittingConstants.QUALIFIER_DOUBLE_QUOTES); textSplitting.setDecimalSeparator(TextSplittingConstants.SEPARATOR_POINT); textSplitting.setThousandsSeparator(TextSplittingConstants.SEPARATOR_COMMA); textSplitting.setDataFormat(new int[]{0,0,0}); textSplitting.setCell(7,3); range.textSplitting(textSplitting); System.out.println(textSplitting.getColumn()); </pre></DL>
</DD>
</DL>
<HR>
<A NAME="getDataFormat()"><!-- --></A><H3>
getDataFormat</H3>
<PRE>
public int[] <B>getDataFormat</B>()</PRE>
<DL>
<DD>获取表示数据格式的整型数组。
<P>
<DD><DL>
<DT><B>返回：</B><DD>表示数据格式的整型数组，其常量和相应的值如下： <pre> TextSplittingConstants.GENERAL_TYPE = 0（数据格式为常规）； TextSplittingConstants.TEXT_TYPE = 1（数据格式为文本）； TextSplittingConstants.MDY_TYPE = 20（日期格式为“月日年”）； TextSplittingConstants.DMY_TYPE = 21（日期格式为“日月年”）； TextSplittingConstants.YMD_TYPE = 22（日期格式为“年月日”）； TextSplittingConstants.MYD_TYPE = 23（日期格式为“月日年”）； TextSplittingConstants.DYM_TYPE = 24（日期格式为“日年月”）； TextSplittingConstants.YDM_TYPE = 25（日期格式为“年日月”）； TextSplittingConstants.SKIP_TYPE = 3跳过数据格式(不导入) </pre> <p> <b>例子：</b> <pre> //此例在控制台输出表示数据格式的整型数组。 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); sheet.setCellValue(3,7,"a b c"); sheet.setCellValue(4,7,"x y z"); Range range = sheet.getRange("G3:G4"); TextSplittingProperties textSplitting = new TextSplittingProperties(); textSplitting.setSplittingType(TextSplittingConstants.DELIMITED); textSplitting.setTab(true); textSplitting.setSpace(true); textSplitting.setSemicolon(false); textSplitting.setComma(false); textSplitting.setOther(false); textSplitting.setOtherDelimiters(' '); textSplitting.setDimilitersAsOne(false); textSplitting.setTextQualifier(TextSplittingConstants.QUALIFIER_DOUBLE_QUOTES); textSplitting.setDecimalSeparator(TextSplittingConstants.SEPARATOR_POINT); textSplitting.setThousandsSeparator(TextSplittingConstants.SEPARATOR_COMMA); textSplitting.setDataFormat(new int[]{0,0,0}); textSplitting.setCell(7,3); range.textSplitting(textSplitting); int i = textSplitting.getDataFormat()[0]; int j = textSplitting.getDataFormat()[1]; int k = textSplitting.getDataFormat()[2]; System.out.println(i+","+j+","+k); </pre></DL>
</DD>
</DL>
<HR>
<A NAME="getDecimalSeparator()"><!-- --></A><H3>
getDecimalSeparator</H3>
<PRE>
public int <B>getDecimalSeparator</B>()</PRE>
<DL>
<DD>得到小数位分隔符。
<P>
<DD><DL>
<DT><B>返回：</B><DD>小数位分隔符，其常量和相应的值如下： <pre> TextSplittingConstants.SEPARATOR_COMMA = 0（逗号为分隔符）； TextSplittingConstants.SEPARATOR_POINT = 1（点为分隔符） </pre> <p> <b>例子：</b> <pre> // Worksheet sheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); sheet.setCellValue(3,7,"a b c"); sheet.setCellValue(4,7,"x y z"); Range range = sheet.getRange("G3:G4"); TextSplittingProperties textSplitting = new TextSplittingProperties(); textSplitting.setSplittingType(TextSplittingConstants.DELIMITED); textSplitting.setTab(true); textSplitting.setSpace(true); textSplitting.setSemicolon(false); textSplitting.setComma(false); textSplitting.setOther(false); textSplitting.setOtherDelimiters(' '); textSplitting.setDimilitersAsOne(false); textSplitting.setTextQualifier(TextSplittingConstants.QUALIFIER_DOUBLE_QUOTES); textSplitting.setDecimalSeparator(TextSplittingConstants.SEPARATOR_POINT); textSplitting.setThousandsSeparator(TextSplittingConstants.SEPARATOR_COMMA); textSplitting.setDataFormat(new int[]{0,0,0}); textSplitting.setCell(7,3); range.textSplitting(textSplitting); System.out.println(textSplitting.getDecimalSeparator()); </pre><DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/TextSplittingConstants.html" title="application.constants 中的接口"><CODE>TextSplittingConstants</CODE></A></DL>
</DD>
</DL>
<HR>
<A NAME="getFieldWidths()"><!-- --></A><H3>
getFieldWidths</H3>
<PRE>
public int[] <B>getFieldWidths</B>()</PRE>
<DL>
<DD>取得固定宽度值。
<P>
<DD><DL>
<DT><B>返回：</B><DD>宽度值数组 <p> <b>例子：</b> <pre> //此例在控制台输出设置文本分列参数时所应用的固定宽度的值。 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); String[] aa = {"a b c","x y z"}; sheet.setCellValue(3,7,aa,false); Range range = sheet.getRange("G3:G4"); TextSplittingProperties textSplitting = new TextSplittingProperties(); textSplitting.setSplittingType(TextSplittingConstants.FIXED_WIDTH); textSplitting.setFieldWidths(new int[]{1,2,2,0,0}); textSplitting.setDecimalSeparator(TextSplittingConstants.SEPARATOR_POINT); textSplitting.setThousandsSeparator(TextSplittingConstants.SEPARATOR_COMMA); textSplitting.setDataFormat(new int[]{0,0,0}); textSplitting.setCell(12,3); range.textSplitting(textSplitting); int i = textSplitting.getFieldWidths()[0]; int j = textSplitting.getFieldWidths()[1]; int k = textSplitting.getFieldWidths()[2]; int l = textSplitting.getFieldWidths()[3]; int m = textSplitting.getFieldWidths()[4]; System.out.println(i+","+j+","+k+","+l+","+m);</DL>
</DD>
</DL>
<HR>
<A NAME="getFileName()"><!-- --></A><H3>
getFileName</H3>
<PRE>
public java.lang.String <B>getFileName</B>()</PRE>
<DL>
<DD>取得导入文件名。
<P>
<DD><DL>
<DT><B>返回：</B><DD>文件名 <P> <b>例子：</b> <pre> //此例在控制台输出导入的文件名。 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); Range range = sheet.getRange("D2"); TextSplittingProperties textSplitting = new TextSplittingProperties(); textSplitting.setFileName("d:\\temp\\newmail.txt"); textSplitting.setStartRow(1); textSplitting.setSplittingType(TextSplittingConstants.DELIMITED); textSplitting.setTab(true); textSplitting.setSpace(true); textSplitting.setSemicolon(true); textSplitting.setComma(true); textSplitting.setOther(false); textSplitting.setOtherDelimiters(' '); textSplitting.setDimilitersAsOne(false);⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -