You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2015/09/17 13:14:50 UTC
svn commit: r1703574 [1/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/...
Author: nick
Date: Thu Sep 17 11:14:47 2015
New Revision: 1703574
URL: http://svn.apache.org/r1703574
Log:
Site updates + javadocs from Javen ONeal from bug #58245 - Make Workbook support iterating over Sheets
Modified:
poi/site/publish/apidocs/deprecated-list.html
poi/site/publish/apidocs/index-all.html
poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Workbook.html
poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html
poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-tree.html
poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/package-tree.html
poi/site/publish/apidocs/overview-tree.html
poi/site/publish/changes.html
poi/site/publish/changes.rss
poi/site/publish/spreadsheet/eval.html
poi/site/publish/spreadsheet/quick-guide.html
poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml
poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
poi/site/src/documentation/content/xdocs/status.xml
Modified: poi/site/publish/apidocs/deprecated-list.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/deprecated-list.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/deprecated-list.html (original)
+++ poi/site/publish/apidocs/deprecated-list.html Thu Sep 17 11:14:47 2015
@@ -1429,6 +1429,9 @@
<tr class="altColor">
<td class="colOne"><a href="org/apache/poi/hwpf/model/CHPBinTable.html#writeTo(org.apache.poi.hwpf.model.io.HWPFFileSystem,%20int,%20org.apache.poi.hwpf.model.CharIndexTranslator)">org.apache.poi.hwpf.model.CHPBinTable.writeTo(HWPFFileSystem, int, CharIndexTranslator)</a></td>
</tr>
+<tr class="rowColor">
+<td class="colOne"><a href="org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">org.apache.poi.xssf.usermodel.XSSFWorkbook.xssfSheetIterator()</a></td>
+</tr>
</tbody>
</table>
</li>
Modified: poi/site/publish/apidocs/index-all.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/index-all.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/index-all.html (original)
+++ poi/site/publish/apidocs/index-all.html Thu Sep 17 11:14:47 2015
@@ -47839,6 +47839,11 @@
<div class="block">Alias for <a href="./org/apache/poi/hssf/usermodel/HSSFSheet.html#rowIterator()"><code>HSSFSheet.rowIterator()</code></a> to allow
foreach loops</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFWorkbook.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a></dt>
+<dd>
+<div class="block">Alias for <a href="./org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()"><code>HSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/hwpf/sprm/SprmBuffer.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.hwpf.sprm.<a href="./org/apache/poi/hwpf/sprm/SprmBuffer.html" title="class in org.apache.poi.hwpf.sprm">SprmBuffer</a></dt>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/openxml4j/opc/PackageRelationshipCollection.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.openxml4j.opc.<a href="./org/apache/poi/openxml4j/opc/PackageRelationshipCollection.html" title="class in org.apache.poi.openxml4j.opc">PackageRelationshipCollection</a></dt>
@@ -47896,6 +47901,11 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFSheet.html" title="class in org.apache.poi.xssf.streaming">SXSSFSheet</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFWorkbook.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFWorkbook.html" title="class in org.apache.poi.xssf.streaming">SXSSFWorkbook</a></dt>
+<dd>
+<div class="block">Alias for <a href="./org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()"><code>SXSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops</div>
+</dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFRow.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a></dt>
<dd>
<div class="block">Alias for <a href="./org/apache/poi/xssf/usermodel/XSSFRow.html#cellIterator()"><code>XSSFRow.cellIterator()</code></a> to allow foreach loops:
@@ -47912,7 +47922,11 @@
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
<dd>
-<div class="block">Allows foreach loops:</div>
+<div class="block">Alias for <a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>XSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops
+
+ <code>Iterator<XSSFSheet> iterator()<code> was replaced with <code>Iterator<Sheet> iterator()</code>
+ to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.</div>
</dd>
<dt><span class="strong"><a href="./org/apache/poi/xwpf/usermodel/XWPFFootnote.html#iterator()">iterator()</a></span> - Method in class org.apache.poi.xwpf.usermodel.<a href="./org/apache/poi/xwpf/usermodel/XWPFFootnote.html" title="class in org.apache.poi.xwpf.usermodel">XWPFFootnote</a></dt>
<dd> </dd>
@@ -73895,6 +73909,26 @@ Compound Document Format.</div>
<dd> </dd>
<dt><span class="strong"><a href="./org/apache/poi/ss/formula/SheetIdentifier.html#SheetIdentifier(java.lang.String,%20org.apache.poi.ss.formula.NameIdentifier)">SheetIdentifier(String, NameIdentifier)</a></span> - Constructor for class org.apache.poi.ss.formula.<a href="./org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula">SheetIdentifier</a></dt>
<dd> </dd>
+<dt><span class="strong"><a href="./org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()">sheetIterator()</a></span> - Method in class org.apache.poi.hssf.usermodel.<a href="./org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a></dt>
+<dd>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator()</a></span> - Method in interface org.apache.poi.ss.usermodel.<a href="./org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dt>
+<dd>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()">sheetIterator()</a></span> - Method in class org.apache.poi.xssf.streaming.<a href="./org/apache/poi/xssf/streaming/SXSSFWorkbook.html" title="class in org.apache.poi.xssf.streaming">SXSSFWorkbook</a></dt>
+<dd>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()">sheetIterator()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
+<dd>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</dd>
<dt><a href="./org/apache/poi/ss/formula/SheetNameFormatter.html" title="class in org.apache.poi.ss.formula"><span class="strong">SheetNameFormatter</span></a> - Class in <a href="./org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></dt>
<dd>
<div class="block">Formats sheet names for use in formula expressions.</div>
@@ -84640,6 +84674,10 @@ the order they are declared.</div>
<dd>
<div class="block">XSSF Conditional Formattings</div>
</dd>
+<dt><span class="strong"><a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">xssfSheetIterator()</a></span> - Method in class org.apache.poi.xssf.usermodel.<a href="./org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></dt>
+<dd>
+<div class="block"><span class="strong">Deprecated.</span></div>
+</dd>
<dt><a href="./org/apache/poi/xssf/eventusermodel/XSSFSheetXMLHandler.html" title="class in org.apache.poi.xssf.eventusermodel"><span class="strong">XSSFSheetXMLHandler</span></a> - Class in <a href="./org/apache/poi/xssf/eventusermodel/package-summary.html">org.apache.poi.xssf.eventusermodel</a></dt>
<dd>
<div class="block">This class handles the processing of a sheet#.xml
Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html Thu Sep 17 11:14:47 2015
@@ -99,7 +99,7 @@
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
-<dd>java.io.Closeable, java.lang.AutoCloseable, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
+<dd>java.io.Closeable, java.lang.AutoCloseable, java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>>, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
</dl>
<hr>
<br>
@@ -603,6 +603,13 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String name,
<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</code>
@@ -610,25 +617,25 @@ implements <a href="../../../../../org/a
the specified external workbook to be added to this one.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#removeName(int)">removeName</a></strong>(int index)</code>
<div class="block">Remove the defined name at the specified index</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#removeName(java.lang.String)">removeName</a></strong>(java.lang.String name)</code>
<div class="block">Remove a defined name by name</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#removePrintArea(int)">removePrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Delete the printarea for the sheet specified</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code>
<div class="block">Removes sheet at the given index.<p/>
@@ -637,14 +644,14 @@ implements <a href="../../../../../org/a
the workbook.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#resetFontCache()">resetFontCache</a></strong>()</code>
<div class="block">Reset the fonts cache, causing all new calls
to getFontAt() to create new objects.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#resolveNameXText(int,%20int)">resolveNameXText</a></strong>(int refIndex,
int definedNameIndex)</code>
@@ -654,19 +661,19 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setActiveSheet(int)">setActiveSheet</a></strong>(int index)</code>
<div class="block">Convenience method to set the active sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setBackupFlag(boolean)">setBackupFlag</a></strong>(boolean backupValue)</code>
<div class="block">determine whether the Excel GUI will backup the workbook when saving.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setDisplayedTab(short)">setDisplayedTab</a></strong>(short index)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -674,31 +681,31 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></strong>(int index)</code>
<div class="block">sets the first tab that is displayed in the list of tabs
in excel.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Whether the application shall perform a full recalculation when the workbook is opened.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy)">setMissingCellPolicy</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="class in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a> missingCellPolicy)</code>
<div class="block">Sets the policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setPrintArea(int,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex,
int startColumn,
@@ -708,14 +715,14 @@ implements <a href="../../../../../org/a
<div class="block">For the Convenience of Java Programmers maintaining pointers.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setPrintArea(int,%20java.lang.String)">setPrintArea</a></strong>(int sheetIndex,
java.lang.String reference)</code>
<div class="block">Sets the printarea for the sheet provided</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setRepeatingRowsAndColumns(int,%20int,%20int,%20int,%20int)">setRepeatingRowsAndColumns</a></strong>(int sheetIndex,
int startColumn,
@@ -728,13 +735,13 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSelectedTab(int)">setSelectedTab</a></strong>(int index)</code>
<div class="block">Selects a single sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSelectedTab(short)">setSelectedTab</a></strong>(short index)</code>
<div class="block"><strong>Deprecated.</strong>
@@ -742,38 +749,45 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSelectedTabs(int[])">setSelectedTabs</a></strong>(int[] indexes)</code> </td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSheetHidden(int,%20boolean)">setSheetHidden</a></strong>(int sheetIx,
boolean hidden)</code>
<div class="block">Hide or unhide a sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSheetHidden(int,%20int)">setSheetHidden</a></strong>(int sheetIx,
int hidden)</code>
<div class="block">Hide or unhide a sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSheetName(int,%20java.lang.String)">setSheetName</a></strong>(int sheetIx,
java.lang.String name)</code>
<div class="block">Set the sheet name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setSheetOrder(java.lang.String,%20int)">setSheetOrder</a></strong>(java.lang.String sheetname,
int pos)</code>
<div class="block">sets the order of appearance for a given sheet.</div>
</td>
</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#unwriteProtectWorkbook()">unwriteProtectWorkbook</a></strong>()</code>
@@ -1511,6 +1525,36 @@ public java.lang.String resolv
or workbook already contains a sheet with this name</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/util/WorkbookUtil.html#createSafeSheetName(java.lang.String)"><code>WorkbookUtil.createSafeSheetName(String nameProposal)</code></a></dd></dl>
</li>
</ul>
+<a name="sheetIterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>sheetIterator</h4>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> sheetIterator()</pre>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order. Includes hidden and very hidden sheets.</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
+</li>
+</ul>
+<a name="iterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>iterator</h4>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> iterator()</pre>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code>iterator</code> in interface <code>java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></dd>
+</dl>
+</li>
+</ul>
<a name="getNumberOfSheets()">
<!-- -->
</a>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Workbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Workbook.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Workbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Workbook.html Thu Sep 17 11:14:47 2015
@@ -86,7 +86,7 @@
<li class="blockList">
<dl>
<dt>All Superinterfaces:</dt>
-<dd>java.lang.AutoCloseable, java.io.Closeable</dd>
+<dd>java.lang.AutoCloseable, java.io.Closeable, java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></dd>
</dl>
<dl>
<dt>All Known Implementing Classes:</dt>
@@ -95,7 +95,7 @@
<hr>
<br>
<pre>public interface <span class="strong">Workbook</span>
-extends java.io.Closeable</pre>
+extends java.io.Closeable, java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></pre>
<div class="block">High level representation of a Excel workbook. This is the first object most users
will construct whether they are reading or writing a workbook. It is also the
top level object for creating new sheets/etc.</div>
@@ -529,12 +529,26 @@ extends java.io.Closeable</pre>
</td>
</tr>
<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#write(java.io.OutputStream)">write</a></strong>(java.io.OutputStream stream)</code>
<div class="block">Write out this workbook to an Outputstream.</div>
</td>
</tr>
</table>
+<ul class="blockList">
+<li class="blockList"><a name="methods_inherited_from_class_java.lang.Iterable">
+<!-- -->
+</a>
+<h3>Methods inherited from interface java.lang.Iterable</h3>
+<code>iterator</code></li>
+</ul>
</li>
</ul>
</li>
@@ -871,6 +885,18 @@ extends java.io.Closeable</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>Sheet representing the cloned sheet.</dd></dl>
</li>
</ul>
+<a name="sheetIterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>sheetIterator</h4>
+<pre>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> sheetIterator()</pre>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order. Includes hidden and very hidden sheets.</div>
+<dl><dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
+</li>
+</ul>
<a name="getNumberOfSheets()">
<!-- -->
</a>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/Sheet.html Thu Sep 17 11:14:47 2015
@@ -128,6 +128,29 @@
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a> that return types with arguments of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">HSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
+<div class="block">Alias for <a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()"><code>HSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">HSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+</tbody>
+</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
@@ -204,6 +227,22 @@
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> that return types with arguments of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">Workbook.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+</tbody>
+</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
@@ -431,6 +470,29 @@
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/streaming/package-summary.html">org.apache.poi.xssf.streaming</a> that return types with arguments of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">SXSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
+<div class="block">Alias for <a href="../../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()"><code>SXSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">SXSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+</tbody>
+</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/streaming/package-summary.html">org.apache.poi.xssf.streaming</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
@@ -492,6 +554,32 @@
</tr>
</tbody>
</table>
+<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
+<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a> that return types with arguments of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tbody>
+<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
+<div class="block">Alias for <a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>XSSFWorkbook.sheetIterator()</code></a> to allow
+ foreach loops
+
+ <code>Iterator<XSSFSheet> iterator()<code> was replaced with <code>Iterator<Sheet> iterator()</code>
+ to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.</div>
+</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+</tbody>
+</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a> with parameters of type <a href="../../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></span><span class="tabEnd"> </span></caption>
<tr>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-tree.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-tree.html Thu Sep 17 11:14:47 2015
@@ -109,7 +109,7 @@
<ul>
<li type="circle">java.io.Closeable
<ul>
-<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a></li>
+<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a> (also extends java.lang.Iterable<T>)</li>
</ul>
</li>
</ul>
@@ -152,6 +152,7 @@
<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">CellRange</span></a><C></li>
<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Row</span></a></li>
<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Sheet</span></a></li>
+<li type="circle">org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a> (also extends java.io.Closeable)</li>
</ul>
</li>
<li type="circle">org.apache.poi.ss.usermodel.charts.<a href="../../../../../org/apache/poi/ss/usermodel/charts/ManuallyPositionable.html" title="interface in org.apache.poi.ss.usermodel.charts"><span class="strong">ManuallyPositionable</span></a>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html Thu Sep 17 11:14:47 2015
@@ -94,7 +94,7 @@
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
-<dd>java.io.Closeable, java.lang.AutoCloseable, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
+<dd>java.io.Closeable, java.lang.AutoCloseable, java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>>, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
</dl>
<hr>
<br>
@@ -446,6 +446,13 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops</div>
+</td>
+</tr>
+<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#linkExternalWorkbook(java.lang.String,%20org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</a></strong>(java.lang.String name,
<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a> workbook)</code>
@@ -453,66 +460,66 @@ implements <a href="../../../../../org/a
the specified external workbook to be added to this one.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeName(int)">removeName</a></strong>(int index)</code>
<div class="block">Remove the defined name at the specified index</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeName(java.lang.String)">removeName</a></strong>(java.lang.String name)</code>
<div class="block">Remove a defined name by name</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removePrintArea(int)">removePrintArea</a></strong>(int sheetIndex)</code>
<div class="block">Delete the printarea for the sheet specified</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#removeSheetAt(int)">removeSheetAt</a></strong>(int index)</code>
<div class="block">Removes sheet at the given index</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setActiveSheet(int)">setActiveSheet</a></strong>(int sheetIndex)</code>
<div class="block">Convenience method to set the active sheet.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setCompressTempFiles(boolean)">setCompressTempFiles</a></strong>(boolean compress)</code>
<div class="block">Set whether temp files should be compressed.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setFirstVisibleTab(int)">setFirstVisibleTab</a></strong>(int sheetIndex)</code>
<div class="block">Sets the first tab that is displayed in the list of tabs in excel.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code>
<div class="block">Whether the application shall perform a full recalculation when the workbook is opened.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setHidden(boolean)">setHidden</a></strong>(boolean hiddenFlag)</code> </td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy)">setMissingCellPolicy</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="class in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a> missingCellPolicy)</code>
<div class="block">Sets the policy on what to do when
getting missing or blank cells from a row.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setPrintArea(int,%20int,%20int,%20int,%20int)">setPrintArea</a></strong>(int sheetIndex,
int startColumn,
@@ -522,14 +529,14 @@ implements <a href="../../../../../org/a
<div class="block">For the Convenience of Java Programmers maintaining pointers.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setPrintArea(int,%20java.lang.String)">setPrintArea</a></strong>(int sheetIndex,
java.lang.String reference)</code>
<div class="block">Sets the printarea for the sheet provided</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setRepeatingRowsAndColumns(int,%20int,%20int,%20int,%20int)">setRepeatingRowsAndColumns</a></strong>(int sheetIndex,
int startColumn,
@@ -542,13 +549,13 @@ implements <a href="../../../../../org/a
</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSelectedTab(int)">setSelectedTab</a></strong>(int index)</code>
<div class="block">Sets the tab whose data is actually seen when the sheet is opened.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetHidden(int,%20boolean)">setSheetHidden</a></strong>(int sheetIx,
boolean hidden)</code>
@@ -558,27 +565,34 @@ implements <a href="../../../../../org/a
created workbook or the one set via setActiveSheet()) cannot be hidden.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetHidden(int,%20int)">setSheetHidden</a></strong>(int sheetIx,
int hidden)</code>
<div class="block">Hide or unhide a sheet.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetName(int,%20java.lang.String)">setSheetName</a></strong>(int sheet,
java.lang.String name)</code>
<div class="block">Set the sheet name.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#setSheetOrder(java.lang.String,%20int)">setSheetOrder</a></strong>(java.lang.String sheetname,
int pos)</code>
<div class="block">Sets the order of appearance for a given sheet.</div>
</td>
</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#write(java.io.OutputStream)">write</a></strong>(java.io.OutputStream stream)</code>
@@ -1053,6 +1067,36 @@ implements <a href="../../../../../org/a
<dt><span class="strong">Returns:</span></dt><dd>the number of sheets</dd></dl>
</li>
</ul>
+<a name="sheetIterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>sheetIterator</h4>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> sheetIterator()</pre>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order. Includes hidden and very hidden sheets.</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
+</li>
+</ul>
+<a name="iterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>iterator</h4>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> iterator()</pre>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/streaming/SXSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code>iterator</code> in interface <code>java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></dd>
+</dl>
+</li>
+</ul>
<a name="getSheetAt(int)">
<!-- -->
</a>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html Thu Sep 17 11:14:47 2015
@@ -104,13 +104,13 @@
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
-<dd>java.io.Closeable, java.lang.AutoCloseable, java.lang.Iterable<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>>, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
+<dd>java.io.Closeable, java.lang.AutoCloseable, java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>>, <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></dd>
</dl>
<hr>
<br>
<pre>public class <span class="strong">XSSFWorkbook</span>
extends <a href="../../../../../org/apache/poi/POIXMLDocument.html" title="class in org.apache.poi">POIXMLDocument</a>
-implements <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>, java.lang.Iterable<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></pre>
+implements <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></pre>
<div class="block">High level representation of a SpreadsheetML workbook. This is the first object most users
will construct whether they are reading or writing a workbook. It is also the
top level object for creating new sheets/etc.</div>
@@ -578,9 +578,13 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
-<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></td>
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
-<div class="block">Allows foreach loops:</div>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops
+
+ <code>Iterator<XSSFSheet> iterator()<code> was replaced with <code>Iterator<Sheet> iterator()</code>
+ to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.</div>
</td>
</tr>
<tr class="rowColor">
@@ -793,43 +797,56 @@ implements <a href="../../../../../org/a
</td>
</tr>
<tr class="altColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()">sheetIterator</a></strong>()</code>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order.</div>
+</td>
+</tr>
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLock()">unLock</a></strong>()</code>
<div class="block">Removes the workbook protection settings</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLockRevision()">unLockRevision</a></strong>()</code>
<div class="block">Unlocks the workbook for revisions.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLockStructure()">unLockStructure</a></strong>()</code>
<div class="block">Unlocks the structure of workbook.</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#unLockWindows()">unLockWindows</a></strong>()</code>
<div class="block">Unlocks the windows that comprise the workbook.</div>
</td>
</tr>
-<tr class="altColor">
+<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#validateRevisionsPassword(java.lang.String)">validateRevisionsPassword</a></strong>(java.lang.String password)</code>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
by the existing password attributes</div>
</td>
</tr>
-<tr class="rowColor">
+<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#validateWorkbookPassword(java.lang.String)">validateWorkbookPassword</a></strong>(java.lang.String password)</code>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
by the existing password attributes</div>
</td>
</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">xssfSheetIterator</a></strong>()</code>
+<div class="block"><strong>Deprecated.</strong> </div>
+</td>
+</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_org.apache.poi.POIXMLDocument">
@@ -1611,24 +1628,102 @@ public org.openxmlformats.schemas.s
<dt><span class="strong">Returns:</span></dt><dd>Sheet name</dd></dl>
</li>
</ul>
+<a name="sheetIterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>sheetIterator</h4>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> sheetIterator()</pre>
+<div class="block">Returns an iterator of the sheets in the workbook
+ in sheet order. Includes hidden and very hidden sheets.
+
+ Note: remove() is not supported on this iterator.
+ Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removeSheetAt(int)"><code>removeSheetAt(int)</code></a> to remove sheets instead.</div>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#sheetIterator()">sheetIterator</a></code> in interface <code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
+</li>
+</ul>
<a name="iterator()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>iterator</h4>
-<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>> iterator()</pre>
-<div class="block">Allows foreach loops:
- <pre><code>
- XSSFWorkbook wb = new XSSFWorkbook(package);
- for(XSSFSheet sheet : wb){
-
- }
- </code></pre></div>
+<pre>public java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>> iterator()</pre>
+<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#sheetIterator()"><code>sheetIterator()</code></a> to allow
+ foreach loops
+
+ <code>Iterator<XSSFSheet> iterator()<code> was replaced with <code>Iterator<Sheet> iterator()</code>
+ to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.
+ This breaks backwards compatibility and may affect your code.
+ See <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()"><code>xssfSheetIterator()</code></a> for how to upgrade your code to be compatible
+ with the new interface.
+
+ Note: remove() is not supported on this iterator.
+ Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#removeSheetAt(int)"><code>removeSheetAt(int)</code></a> to remove sheets instead.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
-<dd><code>iterator</code> in interface <code>java.lang.Iterable<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></dd>
-</dl>
+<dd><code>iterator</code> in interface <code>java.lang.Iterable<<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
+</li>
+</ul>
+<a name="xssfSheetIterator()">
+<!-- -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>xssfSheetIterator</h4>
+<pre>@Deprecated
+public java.util.Iterator<<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>> xssfSheetIterator()</pre>
+<div class="block"><span class="strong">Deprecated.</span> </div>
+<div class="block">xssfSheetIterator was added to make transitioning to the new Iterator<Sheet> iterator()
+ interface less painful for projects currently using POI.
+
+ If your code was written using a for-each loop:
+ <pre><code>
+ for (XSSFSheet sh : wb) {
+ sh.createRow(0);
+ }
+ </code></pre>
+
+ There are two ways to upgrade your code:
+ // Option A:
+ <pre><code>
+ for (XSSFSheet sh : (Iterable<XSSFSheet>) (Iterable<? extends Sheet>) wb) {
+ sh.createRow(0);
+ }
+ </code></pre>
+
+ // Option B (preferred for new code):
+ <pre><code>
+ for (Sheet sh : wb) {
+ sh.createRow(0);
+ }
+ </code></pre>
+
+
+
+ If your code was written using an iterator variable:
+ <pre><code>
+ Iterator<XSSFSheet> it = wb.iterator();
+ XSSFSheet sh = it.next();
+ sh.createRow(0);
+ </code></pre>
+
+ There are three ways to upgrade your code:
+ // Option A:
+ <pre><code>
+ Iterator<XSSFSheet> it = (Iterator<XSSFSheet>) (Iterator<? extends Sheet>) wb.iterator();
+ XSSFSheet sh = it.next();
+ sh.createRow(0);
+ </code></pre>
+
+ // Option B:
+ <pre><code></div>
+<dl><dt><span class="strong">Returns:</span></dt><dd>an iterator of the sheets.</dd></dl>
</li>
</ul>
<a name="isMacroEnabled()">
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/class-use/XSSFSheet.html Thu Sep 17 11:14:47 2015
@@ -221,8 +221,8 @@
<tbody>
<tr class="altColor">
<td class="colFirst"><code>java.util.Iterator<<a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheet</a>></code></td>
-<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#iterator()">iterator</a></strong>()</code>
-<div class="block">Allows foreach loops:</div>
+<td class="colLast"><span class="strong">XSSFWorkbook.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#xssfSheetIterator()">xssfSheetIterator</a></strong>()</code>
+<div class="block"><strong>Deprecated.</strong> </div>
</td>
</tr>
</tbody>
Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/package-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/package-tree.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/package-tree.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/package-tree.html Thu Sep 17 11:14:47 2015
@@ -91,7 +91,7 @@
<ul>
<li type="circle">org.apache.poi.<a href="../../../../../org/apache/poi/POIXMLDocument.html" title="class in org.apache.poi"><span class="strong">POIXMLDocument</span></a> (implements java.io.Closeable)
<ul>
-<li type="circle">org.apache.poi.xssf.usermodel.<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFWorkbook</span></a> (implements java.lang.Iterable<T>, org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>)</li>
+<li type="circle">org.apache.poi.xssf.usermodel.<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFWorkbook</span></a> (implements org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>)</li>
</ul>
</li>
<li type="circle">org.apache.poi.xssf.usermodel.<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFChart.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFChart</span></a> (implements org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Chart.html" title="interface in org.apache.poi.ss.usermodel">Chart</a>, org.apache.poi.ss.usermodel.charts.<a href="../../../../../org/apache/poi/ss/usermodel/charts/ChartAxisFactory.html" title="interface in org.apache.poi.ss.usermodel.charts">ChartAxisFactory</a>)</li>
Modified: poi/site/publish/apidocs/overview-tree.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/overview-tree.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/apidocs/overview-tree.html (original)
+++ poi/site/publish/apidocs/overview-tree.html Thu Sep 17 11:14:47 2015
@@ -1528,7 +1528,7 @@
<ul>
<li type="circle">org.apache.poi.xslf.usermodel.<a href="org/apache/poi/xslf/usermodel/XMLSlideShow.html" title="class in org.apache.poi.xslf.usermodel"><span class="strong">XMLSlideShow</span></a> (implements org.apache.poi.sl.usermodel.<a href="org/apache/poi/sl/usermodel/SlideShow.html" title="interface in org.apache.poi.sl.usermodel">SlideShow</a><S,P>)</li>
<li type="circle">org.apache.poi.xslf.<a href="org/apache/poi/xslf/XSLFSlideShow.html" title="class in org.apache.poi.xslf"><span class="strong">XSLFSlideShow</span></a></li>
-<li type="circle">org.apache.poi.xssf.usermodel.<a href="org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFWorkbook</span></a> (implements java.lang.Iterable<T>, org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>)</li>
+<li type="circle">org.apache.poi.xssf.usermodel.<a href="org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">XSSFWorkbook</span></a> (implements org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a>)</li>
<li type="circle">org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/XWPFDocument.html" title="class in org.apache.poi.xwpf.usermodel"><span class="strong">XWPFDocument</span></a> (implements org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/Document.html" title="interface in org.apache.poi.xwpf.usermodel">Document</a>, org.apache.poi.xwpf.usermodel.<a href="org/apache/poi/xwpf/usermodel/IBody.html" title="interface in org.apache.poi.xwpf.usermodel">IBody</a>)</li>
</ul>
</li>
@@ -2734,10 +2734,10 @@
<ul>
<li type="circle">java.io.Closeable
<ul>
-<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a></li>
+<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a> (also extends java.lang.Iterable<T>)</li>
</ul>
</li>
-<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a></li>
+<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a> (also extends java.io.Closeable, java.lang.Iterable<T>)</li>
</ul>
</li>
<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">AutoFilter</span></a></li>
@@ -2998,6 +2998,7 @@
<li type="circle">org.apache.poi.sl.usermodel.<a href="org/apache/poi/sl/usermodel/TextBox.html" title="interface in org.apache.poi.sl.usermodel"><span class="strong">TextBox</span></a><S,P></li>
</ul>
</li>
+<li type="circle">org.apache.poi.ss.usermodel.<a href="org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Workbook</span></a> (also extends java.io.Closeable)</li>
<li type="circle">org.apache.poi.xslf.usermodel.<a href="org/apache/poi/xslf/usermodel/XSLFShapeContainer.html" title="interface in org.apache.poi.xslf.usermodel"><span class="strong">XSLFShapeContainer</span></a></li>
</ul>
</li>
Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Thu Sep 17 11:14:47 2015
@@ -261,6 +261,9 @@ if (VERSION > 3) {
<ul>
<li>
+<img class="icon" alt="add" src="images/add.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58245">58245</a> - Workbook support for iterating over Sheets</li>
+
+<li>
<img class="icon" alt="fix" src="images/fix.jpg"> <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58353">58353</a> - Return correct value in Match-Function with match-type == -1</li>
<li>
Modified: poi/site/publish/changes.rss
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Thu Sep 17 11:14:47 2015
@@ -1,3 +1,3 @@
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd">
-<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> fix(bug 58353)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58353) - Return correct value in Match-Function with match-type == -1</description></item><item><title> fix(bug 58315)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58315) - Avoid NPE for RichTextString without font-details</description></item><item><title> fix(bug 53275)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 53275) - XSSFFont: reset indexed color flag when setting a non-indexed color</description></item><item><title> fix(bug 58039)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 58039) - Make DGet and DMin function implementations thread-safe</descri
ption></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - Fix DAYS360 handling for US/EU method</description></item><item><title> fix(bug 58254)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58254) - CellFormatResult.text should check for nulls as per the javadoc</description></item><item><title> fix(bug 58260)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58260) - Fix checks for limit on number of styles in XSSF/SXSSF, fix more than 32k styles in SXSSF workbooks</description></item><item><title> fix(bug 58262)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 58262) - ReadOnlySharedStringsTable now handles workbooks with an empty SST part</description></item><item><title> fix(bug 52111)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 521
11) - Intersection formulae are now supported in XSSF</description></item><item><title> fix(bug 58253)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58253) - CellReference upper-case check for #REF!, and javadoc improvements</description></item><item><title> fix(bug 58252)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58252) - More CellReference unit testing coverage</description></item><item><title> fix(bug 54938)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 54938) - Throw InvalidFormatException as documented instead of IllegalArgumentException in WorkbookFactory.create()</description></item><item><title> fix(bug 58237)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58237) - When adding a picture to a XWPF header or footer, attach it to the right part</description></item><item><title> fix(
bug 58220)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58220) - Improve the javadocs for XSSFFont and Font getFontHeight methods</description></item><item><title> fix(bug 56479)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56479) - Don't hardcode dcterms as namespace alias in the attribute, but expect the actual alias that is used in the corresponding element</description></item><item><title> fix(bug 56519)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56519) - XSLFSlide.draw is not working with text embeded in PPTX</description></item><item><title> fix(bug 58205)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58205) - getSlideMasters() returns the master slides in the incorrect order</description></item><item><title> fix(bug 57786)</title><link>http://poi.apache.org/changes.html</link><d
escription> fix by POI Developers (bug 57786) - XSLFFreeformShape ignores quadratic bezier curves</description></item><item><title> fix(bug 58206)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58206) - provide a mechanism to find slide layouts by name</description></item><item><title> fix(bug 58204)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58204) - STYLE: ShapeContainer interface makes internal getShapesList() redundant</description></item><item><title> add(bug 58190)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58190) - The current picture handling uses raw integers for types and index, replace with enum and reference</description></item><item><title> fix(bug 58203)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58203) - Apparently Maven uses plurals for all artifacts except javadocs,
so tweak our naming to make it happy</description></item><item><title> add(bug 58193)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58193) - Use input stream rather than byte array for checksum etc.</description></item><item><title> add(bug 58200)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58200) - SXSSF support for evaluating formula cells, provided the cell and all its references are within the current window</description></item><item><title> fix(bug 58098)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58098) - Avoid NPE in cleanup if NPOIFSFileSystem is opened on a locked File under Windows</description></item><item><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - Merged common_sl branch to trunk</description></item><item><title> fix(bug 57571)</title><link>http://poi.apache.or
g/changes.html</link><description> fix by POI Developers (bug 57571) - Fix creating comments for XSSF/SXSSF, regression was introduced via bug 54920</description></item><item><title> fix(bug 58175)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58175) - Fix creating comments for XSSF/SXSSF, regression was introduced via bug 54920</description></item><item><title> fix(bug 58156)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58156) - Possible data corruption in hasPOIFSHeader and hasOOXMLHeader</description></item><item><title> add(bug 57484)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57484) - Allow processing of non-OOXML core namespace packages</description></item><item><title> add(bug 58130)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58130) - Conditional Formatting support for DataBar
s, Icon Sets / Multi-States, and Color Scales</description></item></channel></rss>
\ No newline at end of file
+<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> add(bug 58245)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58245) - Workbook support for iterating over Sheets</description></item><item><title> fix(bug 58353)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58353) - Return correct value in Match-Function with match-type == -1</description></item><item><title> fix(bug 58315)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58315) - Avoid NPE for RichTextString without font-details</description></item><item><title> fix(bug 53275)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 53275) - XSSFFont: reset indexed color flag when setting a non-indexed color</description></it
em><item><title> fix(bug 58039)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 58039) - Make DGet and DMin function implementations thread-safe</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - Fix DAYS360 handling for US/EU method</description></item><item><title> fix(bug 58254)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58254) - CellFormatResult.text should check for nulls as per the javadoc</description></item><item><title> fix(bug 58260)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58260) - Fix checks for limit on number of styles in XSSF/SXSSF, fix more than 32k styles in SXSSF workbooks</description></item><item><title> fix(bug 58262)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 58262) - ReadOnlySharedString
sTable now handles workbooks with an empty SST part</description></item><item><title> fix(bug 52111)</title><link>http://poi.apache.org/changes.html</link><description> fix by David North (bug 52111) - Intersection formulae are now supported in XSSF</description></item><item><title> fix(bug 58253)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58253) - CellReference upper-case check for #REF!, and javadoc improvements</description></item><item><title> fix(bug 58252)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58252) - More CellReference unit testing coverage</description></item><item><title> fix(bug 54938)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 54938) - Throw InvalidFormatException as documented instead of IllegalArgumentException in WorkbookFactory.create()</description></item><item><title> fix(bug 58237)</title><link>http://poi.
apache.org/changes.html</link><description> fix by POI Developers (bug 58237) - When adding a picture to a XWPF header or footer, attach it to the right part</description></item><item><title> fix(bug 58220)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58220) - Improve the javadocs for XSSFFont and Font getFontHeight methods</description></item><item><title> fix(bug 56479)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56479) - Don't hardcode dcterms as namespace alias in the attribute, but expect the actual alias that is used in the corresponding element</description></item><item><title> fix(bug 56519)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56519) - XSLFSlide.draw is not working with text embeded in PPTX</description></item><item><title> fix(bug 58205)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI D
evelopers (bug 58205) - getSlideMasters() returns the master slides in the incorrect order</description></item><item><title> fix(bug 57786)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57786) - XSLFFreeformShape ignores quadratic bezier curves</description></item><item><title> fix(bug 58206)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58206) - provide a mechanism to find slide layouts by name</description></item><item><title> fix(bug 58204)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58204) - STYLE: ShapeContainer interface makes internal getShapesList() redundant</description></item><item><title> add(bug 58190)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58190) - The current picture handling uses raw integers for types and index, replace with enum and reference</description></item><
item><title> fix(bug 58203)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58203) - Apparently Maven uses plurals for all artifacts except javadocs, so tweak our naming to make it happy</description></item><item><title> add(bug 58193)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58193) - Use input stream rather than byte array for checksum etc.</description></item><item><title> add(bug 58200)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58200) - SXSSF support for evaluating formula cells, provided the cell and all its references are within the current window</description></item><item><title> fix(bug 58098)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58098) - Avoid NPE in cleanup if NPOIFSFileSystem is opened on a locked File under Windows</description></item><item><title> add</title><lin
k>http://poi.apache.org/changes.html</link><description> add by POI Developers - Merged common_sl branch to trunk</description></item><item><title> fix(bug 57571)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57571) - Fix creating comments for XSSF/SXSSF, regression was introduced via bug 54920</description></item><item><title> fix(bug 58175)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58175) - Fix creating comments for XSSF/SXSSF, regression was introduced via bug 54920</description></item><item><title> fix(bug 58156)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 58156) - Possible data corruption in hasPOIFSHeader and hasOOXMLHeader</description></item><item><title> add(bug 57484)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 57484) - Allow processing of non-OOXML core namespace packages
</description></item><item><title> add(bug 58130)</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers (bug 58130) - Conditional Formatting support for DataBars, Icon Sets / Multi-States, and Color Scales</description></item></channel></rss>
\ No newline at end of file
Modified: poi/site/publish/spreadsheet/eval.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/eval.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/eval.html (original)
+++ poi/site/publish/spreadsheet/eval.html Thu Sep 17 11:14:47 2015
@@ -423,11 +423,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/publish/spreadsheet/quick-guide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1703574&r1=1703573&r2=1703574&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Thu Sep 17 11:14:47 2015
@@ -669,24 +669,24 @@ if (VERSION > 3) {
<h2>Iterate over rows and cells</h2>
</div>
-<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>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>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>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>
<pre class="code">
- 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
+ }
+ }
}
</pre>
@@ -1737,7 +1737,7 @@ Examples:
<a name="Outlining"></a>
- <a name="Outlining-N103E0"></a>
+ <a name="Outlining-N103DD"></a>
<div class="h2">
<h2>Outlining</h2>
</div>
@@ -1784,7 +1784,7 @@ Examples:
<a name="Images"></a>
- <a name="Images-N103FD"></a>
+ <a name="Images-N103FA"></a>
<div class="h3">
<h3>Images</h3>
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org