poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cen...@apache.org
Subject svn commit: r1719940 - in /poi/site: publish/spreadsheet/limitations.html src/documentation/content/xdocs/spreadsheet/limitations.xml
Date Mon, 14 Dec 2015 15:37:44 GMT
Author: centic
Date: Mon Dec 14 15:37:44 2015
New Revision: 1719940

URL: http://svn.apache.org/viewvc?rev=1719940&view=rev
Log:
Add a section for "file size/main memory" to the page about limitations in POI regarding Excel
files.

Modified:
    poi/site/publish/spreadsheet/limitations.html
    poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml

Modified: poi/site/publish/spreadsheet/limitations.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/limitations.html?rev=1719940&r1=1719939&r2=1719940&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/limitations.html (original)
+++ poi/site/publish/spreadsheet/limitations.html Mon Dec 14 15:37:44 2015
@@ -198,6 +198,46 @@ if (VERSION > 3) {
 <ul>
                 
 <li>
+                    File sizes/Memory usage<br>
+<br>
+					
+<ul>
+						
+<li>
+							There are some inherent limits in the Excel file formats. These are defined in class

+							<a href="https://poi.apache.org/apidocs/org/apache/poi/ss/SpreadsheetVersion.html">SpreadsheetVersion</a>.

+							As long as you have enough main-memory, you should be able to handle files up to these
limits. For huge files 
+							using the default POI classes you will likely need a very large amount of memory.
+							<br>
+							
+<br>
+							There are ways to overcome the main-memory limitations if needed:
+							<br>
+							
+<ul>
+								
+<li>
+									For writing very huge files, there is <a href="http://poi.apache.org/spreadsheet/index.html">SXSSFWorkbook</a>

+									which allows to do a streaming write of data out to files (with certain limitations
on what you can do as only 
+									parts of the file are held in memory).
+								</li>
+								
+<li>
+									For reading very huge files, take a look at the sample 
+									<a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java">XLSX2CSV</a>

+									which shows how you can read a file in streaming fashion (again with some limitations
on what information you 
+									can read out of the file, but there are ways to get at most of it if necessary).
+								</li>
+							
+</ul>
+						
+</li>
+					
+</ul>
+                
+</li>
+                
+<li>
                     Charts<br>
 <br>
 					

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml?rev=1719940&r1=1719939&r2=1719940&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml Mon Dec 14 15:37:44
2015
@@ -36,6 +36,34 @@
             </p>
             <ul>
                 <li>
+                    File sizes/Memory usage<br/><br/>
+					<ul>
+						<li>
+							There are some inherent limits in the Excel file formats. These are defined in class

+							<link href="https://poi.apache.org/apidocs/org/apache/poi/ss/SpreadsheetVersion.html">SpreadsheetVersion</link>.

+							As long as you have enough main-memory, you should be able to handle files up to these
limits. For huge files 
+							using the default POI classes you will likely need a very large amount of memory.
+							<br/>
+							<br/>
+							There are ways to overcome the main-memory limitations if needed:
+							<br/>
+							<ul>
+								<li>
+									For writing very huge files, there is <link href="http://poi.apache.org/spreadsheet/index.html">SXSSFWorkbook</link>

+									which allows to do a streaming write of data out to files (with certain limitations
on what you can do as only 
+									parts of the file are held in memory).
+								</li>
+								<li>
+									For reading very huge files, take a look at the sample 
+									<link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java">XLSX2CSV</link>

+									which shows how you can read a file in streaming fashion (again with some limitations
on what information you 
+									can read out of the file, but there are ways to get at most of it if necessary).
+								</li>
+							</ul>
+						</li>
+					</ul>
+                </li>
+                <li>
                     Charts<br/><br/>
 					<ul>
 						<li>



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


Mime
View raw message