poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1703574 [2/2] - in /poi/site: publish/ publish/apidocs/ publish/apidocs/org/apache/poi/hssf/usermodel/ publish/apidocs/org/apache/poi/ss/usermodel/ publish/apidocs/org/apache/poi/ss/usermodel/class-use/ publish/apidocs/org/apache/poi/xssf/...
Date Thu, 17 Sep 2015 11:14:50 GMT
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml Thu Sep 17 11:14:47 2015
@@ -214,11 +214,10 @@ if (cell!=null) {
 FileInputStream fis = new FileInputStream("/somepath/test.xls");
 Workbook wb = new HSSFWorkbook(fis); //or new XSSFWorkbook("/somepath/test.xls")
 FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
-for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
-    Sheet sheet = wb.getSheetAt(sheetNum);
-    for(Row r : sheet) {
-        for(Cell c : r) {
-            if(c.getCellType() == Cell.CELL_TYPE_FORMULA) {
+for (Sheet sheet : wb) {
+    for (Row r : sheet) {
+        for (Cell c : r) {
+            if (c.getCellType() == Cell.CELL_TYPE_FORMULA) {
                 evaluator.evaluateFormulaCell(c);
             }
         }

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml Thu Sep 17 11:14:47
2015
@@ -324,22 +324,22 @@
                 </section>
                 <anchor id="Iterator"/>
                 <section><title>Iterate over rows and cells</title>
-				<p>Sometimes, you'd like to just iterate over all the rows in
-				a sheet, or all the cells in a row. This is possible with
-				a simple for loop.</p>
-				<p>Luckily, this is very easy. Row defines a 
-				<em>CellIterator</em> inner class to handle iterating over 
-				the cells (get one with a call to <em>row.cellIterator()</em>),
-				and Sheet provides a <em>rowIterator()</em> method to
-				give an iterator over all the rows. These implement the 
-            <em>java.lang.Iterable</em> interface to allow foreach loops.</p>
+				<p>Sometimes, you'd like to just iterate over all the sheets in 
+				a workbook, all the rows in a sheet, or all the cells in a row.
+				This is possible with a simple for loop.</p>
+				<p>These iterators are available by calling <em>workbook.sheetIterator()</em>,
+				<em>sheet.rowIterator()</em>, and <em>row.cellIterator()</em>,
or
+				implicitly using a for-each loop.
+				Note that a rowIterator and cellIterator iterate over rows or
+				cells that have been created, skipping empty rows and cells.</p>
 
 				<source>
-    Sheet sheet = wb.getSheetAt(0);
-    for (Row row : sheet) {
-      for (Cell cell : row) {
-        // Do something here
-      }
+    for (Sheet sheet : wb ) {
+        for (Row row : sheet) {
+            for (Cell cell : row) {
+                // Do something here
+            }
+        }
     }
 				</source>
             </section>

Modified: poi/site/src/documentation/content/xdocs/status.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/status.xml?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/status.xml (original)
+++ poi/site/src/documentation/content/xdocs/status.xml Thu Sep 17 11:14:47 2015
@@ -39,6 +39,7 @@
     </devs>
 
     <release version="3.13-beta2" date="2015-10-??">
+        <action dev="PD" type="add" fixes-bug="58245">Workbook support for iterating
over Sheets</action>
         <action dev="PD" type="fix" fixes-bug="58353">Return correct value in Match-Function
with match-type == -1</action>
         <action dev="PD" type="fix" fixes-bug="58315">Avoid NPE for RichTextString
without font-details</action>
         <action dev="PD" type="fix" fixes-bug="53275">XSSFFont: reset indexed color
flag when setting a non-indexed color</action>



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


Mime
View raw message