You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2015/12/14 16:37:44 UTC
svn commit: r1719940 - in /poi/site: publish/spreadsheet/limitations.html
src/documentation/content/xdocs/spreadsheet/limitations.xml
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