textsplittingproperties.html

永中OFFICE二次开发帮助文档

 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);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界<DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/TextSplittingConstants.html" title="application.constants 中的接口"><CODE>TextSplittingConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setDimilitersAsOne(boolean)"><!-- --></A><H3>
setDimilitersAsOne</H3>
<PRE>
public void <B>setDimilitersAsOne</B>(boolean&nbsp;conDimilitersAsOne)</PRE>
<DL>
<DD>设置连续分隔符作为单个处理。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>conDimilitersAsOne</CODE> - 布尔型，如果为true，则将连续分隔符作为单个处理；否则，取消设置
 <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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFieldWidths(int[])"><!-- --></A><H3>
setFieldWidths</H3>
<PRE>
public void <B>setFieldWidths</B>(int[]&nbsp;fieldWidths)</PRE>
<DL>
<DD>设置固定宽度。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fieldWidths</CODE> - 宽度值数组
 <p>
 <b>例子：</b>
 <pre>
 //此例应用设置固定宽度{1,2,2,0,0}来进行文本分列。
 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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFileName(java.lang.String)"><!-- --></A><H3>
setFileName</H3>
<PRE>
public void <B>setFileName</B>(java.lang.String&nbsp;fileName)</PRE>
<DL>
<DD>如从文件导入则设置文件名。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fileName</CODE> - 文件名
 <p>
 <b>例子：</b>
 <pre>
 //从文件导入，并设置文件名为"d:\\temp\\newmail.txt"。
 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);
 textSplitting.setTextQualifier(TextSplittingConstants.QUALIFIER_DOUBLE_QUOTES);
 textSplitting.setDecimalSeparator(TextSplittingConstants.SEPARATOR_POINT);
 textSplitting.setThousandsSeparator(TextSplittingConstants.SEPARATOR_COMMA);
 textSplitting.setDataFormat(new int[]{0, 0, 0, 0, 0, 0, 0});
 textSplitting.setCell(4,2);
 range.textSplitting(textSplitting);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当要导入的文件找不到</DL>
</DD>
</DL>
<HR>

<A NAME="setOther(boolean)"><!-- --></A><H3>
setOther</H3>
<PRE>
public void <B>setOther</B>(boolean&nbsp;other)</PRE>
<DL>
<DD>设置其它分隔符号。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>other</CODE> - 布尔型，如果为true，则用自定义符号分隔；否则，取消设置
 <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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setOtherDelimiters(char)"><!-- --></A><H3>
setOtherDelimiters</H3>
<PRE>
public void <B>setOtherDelimiters</B>(char&nbsp;otherDelimiters)</PRE>
<DL>
<DD>设置其它分隔符号。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>otherDelimiters</CODE> - 使用的其他分隔符号
 <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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSemicolon(boolean)"><!-- --></A><H3>
setSemicolon</H3>
<PRE>
public void <B>setSemicolon</B>(boolean&nbsp;semicolon)</PRE>
<DL>
<DD>设置分号为分隔符号。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>semicolon</CODE> - 布尔型，如果为true，用分号分隔；否则，取消设置
 <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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSpace(boolean)"><!-- --></A><H3>
setSpace</H3>
<PRE>
public void <B>setSpace</B>(boolean&nbsp;space)</PRE>
<DL>
<DD>设置空格为分隔符号。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>space</CODE> - 布尔型，如果为true，则用空格分隔；否则，取消设置
 <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);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSplittingType(int)"><!-- --></A><H3>
setSplittingType</H3>
<PRE>
public void <B>setSplittingType</B>(int&nbsp;splittingType)</PRE>
<DL>
<DD>设置分列方式（默认为分隔符号）。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>splittingType</CODE> - 分列方式，其常量和相应的值如下：
 <pre>
 TextSplittingConstants.DELIMITED = 0（分隔符号）；
 TextSplittingConstants.FIXED_WIDTH = 1（固定宽度）
 </pre>
 <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.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);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类