poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r589232 - in /poi/trunk/src/documentation/content/xdocs: changes.xml hssf/quick-guide.xml status.xml
Date Sat, 27 Oct 2007 22:49:58 GMT
Author: nick
Date: Sat Oct 27 15:49:57 2007
New Revision: 589232

URL: http://svn.apache.org/viewvc?rev=589232&view=rev
Log:
Update changes list, and add text extraction to the HSSF docs

Modified:
    poi/trunk/src/documentation/content/xdocs/changes.xml
    poi/trunk/src/documentation/content/xdocs/hssf/quick-guide.xml
    poi/trunk/src/documentation/content/xdocs/status.xml

Modified: poi/trunk/src/documentation/content/xdocs/changes.xml
URL: http://svn.apache.org/viewvc/poi/trunk/src/documentation/content/xdocs/changes.xml?rev=589232&r1=589231&r2=589232&view=diff
==============================================================================
--- poi/trunk/src/documentation/content/xdocs/changes.xml (original)
+++ poi/trunk/src/documentation/content/xdocs/changes.xml Sat Oct 27 15:49:57 2007
@@ -36,6 +36,7 @@
 
 		<!-- Don't forget to update status.xml too! -->
         <release version="3.0.2-FINAL" date="2007-??-??">
+            <action dev="POI-DEVELOPERS" type="add">Include an Excel text extractor,
and put all existing text extractors under a common superclass</action>
             <action dev="POI-DEVELOPERS" type="add">Improvements to the LZW compression
engine used by HDGF</action>
             <action dev="POI-DEVELOPERS" type="add">HSSFPicture.resize() - a handy
method to reset a picture to its original width and height</action>
             <action dev="POI-DEVELOPERS" type="add">Add a getSheetIndex(HSSFSheet)
method to HSSFWorkbook, and allow a HSSFSheet to get at its parent HSSFWorkbook</action>

Modified: poi/trunk/src/documentation/content/xdocs/hssf/quick-guide.xml
URL: http://svn.apache.org/viewvc/poi/trunk/src/documentation/content/xdocs/hssf/quick-guide.xml?rev=589232&r1=589231&r2=589232&view=diff
==============================================================================
--- poi/trunk/src/documentation/content/xdocs/hssf/quick-guide.xml (original)
+++ poi/trunk/src/documentation/content/xdocs/hssf/quick-guide.xml Sat Oct 27 15:49:57 2007
@@ -41,6 +41,7 @@
                     <li><link href="#CreateCells">How to create cells</link></li>
                     <li><link href="#CreateDateCells">How to create date cells</link></li>
                     <li><link href="#CellTypes">Working with different types
of cells</link></li>
+                    <li><link href="#TextExtraction">Text Extraction</link></li>
                     <li><link href="#Alignment">Aligning cells</link></li>
                     <li><link href="#Borders">Working with borders</link></li>
                     <li><link href="#FrillsAndFills">Fills and color</link></li>
@@ -232,6 +233,24 @@
     wb.write(fileOut);
     fileOut.close();
                     </source>
+                </section>
+                <anchor id="TextExtraction"/>
+                <section><title>Text Extraction</title>
+					<p>For most text extraction requirements, the standard
+					ExcelExtractor class should provide all you need.</p>
+					<source>
+	InputStream inp = new FileInputStream("workbook.xls");
+    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inp));
+	ExcelExtractor extractor = new ExcelExtractor(wb);
+
+	extractor.setFormulasNotResults(true);
+	extractor.setIncludeSheetNames(false);
+	String text = extractor.getText();
+					</source>
+					<p>For very fancy text extraction, XLS to CSV etc, 
+					take a look at
+					<em>/src/scratchpad/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java</em>
+					</p>
                 </section>
                 <anchor id="FillsAndFrills"/>
                 <section><title>Fills and colors</title>

Modified: poi/trunk/src/documentation/content/xdocs/status.xml
URL: http://svn.apache.org/viewvc/poi/trunk/src/documentation/content/xdocs/status.xml?rev=589232&r1=589231&r2=589232&view=diff
==============================================================================
--- poi/trunk/src/documentation/content/xdocs/status.xml (original)
+++ poi/trunk/src/documentation/content/xdocs/status.xml Sat Oct 27 15:49:57 2007
@@ -33,6 +33,7 @@
 	<!-- Don't forget to update changes.xml too! -->
     <changes>
         <release version="3.0.2-FINAL" date="2007-??-??">
+            <action dev="POI-DEVELOPERS" type="add">Include an Excel text extractor,
and put all existing text extractors under a common superclass</action>
             <action dev="POI-DEVELOPERS" type="add">Improvements to the LZW compression
engine used by HDGF</action>
             <action dev="POI-DEVELOPERS" type="add">HSSFPicture.resize() - a handy
method to reset a picture to its original width and height</action>
             <action dev="POI-DEVELOPERS" type="add">Add a getSheetIndex(HSSFSheet)
method to HSSFWorkbook, and allow a HSSFSheet to get at its parent HSSFWorkbook</action>



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message