Copied: poi/site/publish/help/faq.html (from r1836243, poi/site/publish/faq.html) URL: http://svn.apache.org/viewvc/poi/site/publish/help/faq.html?p2=poi/site/publish/help/faq.html&p1=poi/site/publish/faq.html&r1=1836243&r2=1836244&rev=1836244&view=diff ============================================================================== --- poi/site/publish/faq.html (original) +++ poi/site/publish/help/faq.html Wed Jul 18 23:27:21 2018 @@ -1,418 +1,155 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> +<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> -<!--*** This is a generated file. Do not edit. ***--> -<link rel="stylesheet" href="skin/tigris.css" type="text/css"> -<link rel="stylesheet" href="skin/mysite.css" type="text/css"> -<link rel="stylesheet" href="skin/site.css" type="text/css"> -<link media="print" rel="stylesheet" href="skin/print.css" type="text/css"> +<meta content="Apache Forrest" name="Generator"> +<meta name="Forrest-version" content="0.9"> +<meta name="Forrest-skin-name" content="pelt"> <title>Frequently Asked Questions</title> +<link type="text/css" href="../skin/basic.css" rel="stylesheet"> +<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet"> +<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet"> +<link type="text/css" href="../skin/profile.css" rel="stylesheet"> +<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script> +<link rel="shortcut icon" href="../images/favicon.ico"> </head> -<body bgcolor="white" class="composite"> -<!--================= start Banner ==================--> -<div id="banner"> -<table width="100%" cellpadding="8" cellspacing="0" summary="banner" border="0"> -<tbody> -<tr> -<!--================= start Group Logo ==================--> -<td width="50%" align="left"> -<div class="groupLogo"> -<a href="https://www.apache.org";><img border="0" class="logoImage" alt="The Apache Software Foundation" src="resources/images/asf_logo.png"></a> -</div> -</td> -<!--================= end Group Logo ==================--> -<!--================= start Project Logo ==================--><td width="50%" align="right"> -<div align="right" class="projectLogo"> -<a href="https://donate.apache.org/";><img border="0" class="logoImage" alt="Support Apache" src="resources/images/support-asf.png" width="120" height="120" title="Your donation helps The Apache Software Foundation ensure its community-driven software remains available to billions of users at absolutely no cost."></a><a href="https://poi.apache.org/";><img border="0" class="logoImage" alt="Apache POI" src="resources/images/pb-poi.png" width="120" height="120" title="Apache POI - the Java API for Microsoft Documents"></a> -</div> -</td> -<!--================= end Project Logo ==================--> -</tr> -</tbody> -</table> -</div> -<!--================= end Banner ==================--> -<!--================= start Main ==================--> -<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" id="breadcrumbs"> -<tbody> -<!--================= start Status ==================--> -<tr class="status"> -<td> -<!--================= start BreadCrumb ==================--><a href="https://www.apache.org/";>Apache</a> | <a href="https://poi.apache.org/";>POI</a><a href=""></a> -<!--================= end BreadCrumb ==================--></td><td id="tabs"> -<!--================= start Tabs ==================--> -<div class="tab"> -<span class="selectedTab"><a class="base-selected" href="index.html">Home</a></span> | <script language="Javascript" type="text/javascript"> -function printit() { -if (window.print) { - window.print() ; -} else { - var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>'; -document.body.insertAdjacentHTML('beforeEnd', WebBrowser); - WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box WebBrowser1.outerHTML = ""; -} -} -</script><script language="Javascript" type="text/javascript"> -var NS = (navigator.appName == "Netscape"); -var VERSION = parseInt(navigator.appVersion); -if (VERSION > 3) { - document.write(' <a title="PRINT this page OUT" href="javascript:printit()">PRINT</a>'); -} -</script> -</div> -<!--================= end Tabs ==================--> -</td> -</tr> -</tbody> -</table> -<!--================= end Status ==================--> -<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" border="0"> -<tbody> -<tr valign="top"> -<!--================= start Menu ==================--> -<td id="leftcol"> -<div id="navcolumn"> -<div class="menuBar"> -<div class="menu"> -<span class="menuLabel">Overview</span> - -<div class="menuItem"> -<a href="index.html">Home</a> -</div> - -<div class="menuItem"> -<a href="download.html">Download</a> -</div> - -<div class="menuItem"> -<a href="overview.html">Components</a> -</div> - -<div class="menuItem"> -<a href="text-extraction.html">Text Extraction</a> -</div> - -<div class="menuItem"> -<a href="encryption.html">Encryption support</a> -</div> - -<div class="menuItem"> -<a href="casestudies.html">Case Studies</a> -</div> - -<div class="menuItem"> -<a href="related-projects.html">Related projects</a> -</div> - -<div class="menuItem"> -<a href="legal.html">Legal</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Help</span> - -<div class="menuItem"> -<a href="apidocs/index.html">Javadocs</a> -</div> - -<div class="menuItem"> -<span class="menuSelected">FAQ</span> -</div> - -<div class="menuItem"> -<a href="mailinglists.html">Mailing Lists</a> -</div> - -<div class="menuItem"> -<a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug Database</a> -</div> - -<div class="menuItem"> -<a href="changes.html">Changelog</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Getting Involved</span> - -<div class="menuItem"> -<a href="subversion.html">Subversion Repository</a> -</div> - -<div class="menuItem"> -<a href="howtobuild.html">How To Build</a> -</div> - -<div class="menuItem"> -<a href="guidelines.html">Contribution Guidelines</a> -</div> - -<div class="menuItem"> -<a href="who.html">Who We Are</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Component APIs</span> - -<div class="menuItem"> -<a href="spreadsheet/index.html">Excel (SS=HSSF+XSSF+SXSSF)</a> -</div> - -<div class="menuItem"> -<a href="slideshow/index.html">PowerPoint (SL=HSLF+XSLF)</a> -</div> - -<div class="menuItem"> -<a href="document/index.html">Word (WP=HWPF+XWPF)</a> -</div> - -<div class="menuItem"> -<a href="hsmf/index.html">Outlook (HSMF)</a> -</div> - -<div class="menuItem"> -<a href="diagram/index.html">Visio (HDGF+XDGF)</a> -</div> - -<div class="menuItem"> -<a href="hpbf/index.html">Publisher (HPBF)</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Low-level Component APIs</span> - -<div class="menuItem"> -<a href="poifs/index.html">OLE2 Filesystem (POIFS)</a> -</div> - -<div class="menuItem"> -<a href="hpsf/index.html">OLE2 Document Props (HPSF)</a> -</div> - -<div class="menuItem"> -<a href="hmef/index.html">TNEF (HMEF) for winmail.dat</a> -</div> - -<div class="menuItem"> -<a href="oxml4j/index.html">OpenXML4J (OOXML)</a> -</div> - -<div class="menuItem"> -<a href="logging.html">Logging framework</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Apache Wide</span> - -<div class="menuItem"> -<a href="https://www.apache.org/";>Apache Software Foundation</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/licenses/";>License</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/thanks.html";>Thanks</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/security/";>Security</a> -</div> - -</div> -<center> -<a href="https://www.apache.org/events/current-event.html";><img src="https://www.apache.org/events/current-event-125x125.png";></a> -</center> -</div> -</div> -<form target="_blank" action="https://www.google.com/search"; method="get"> -<table summary="search" border="0" cellspacing="0" cellpadding="0"> -<tr> -<td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"> - Search Apache POI<br> -<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" name="q" id="query" type="text"><img height="1" width="5" alt="" src="skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" type="submit"></td><td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td> -</tr> -<tr> -<td colspan="3"><img height="7" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td> -</tr> -<tr> -<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td class="bottom-right-thick"></td> -</tr> -</table> +<body onload="init()"> +<script type="text/javascript">ndeSetTextSize();</script> +<div id="top"> +<!--+ + |breadtrail + +--> +<div class="breadtrail"> +<a href="https://www.apache.org";>Apache Software Foundation</a> > <a href="https://poi.apache.org";>Apache POI</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script> +</div> +<!--+ + |header + +--> +<div class="header"> +<!--+ + |start group logo + +--> +<div class="grouplogo"> +<a href="https://www.apache.org";><img class="logoImage" alt="Apache Software Foundation" src="../images/group-logo.png" title="The Apache Software Foundation is a cornerstone of the modern Open Source software ecosystem – supporting some of the most widely used and important software solutions powering today's Internet economy."></a> +</div> +<!--+ + |end group logo + +--> +<!--+ + |start Project Logo + +--> +<div class="projectlogo"> +<a href="https://poi.apache.org";><img class="logoImage" alt="Apache POI" src="../images/project-logo.png" title="Apache POI is well-known in the Java field as a library for reading and writing Microsoft Office file formats, such as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the older (OLE2) and new (OOXML - Office Open XML) formats."></a> +</div> +<!--+ + |end Project Logo + +--> +<!--+ + |start Search + +--> +<div class="searchbox"> +<form action="http://www.google.com/search"; method="get" class="roundtopsmall"> +<input value="poi.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google"> + <input name="Search" value="Search" type="submit"> </form> -</td> -<!--================= end Menu ==================--> -<!--================= start Content ==================--><td> -<div id="bodycol"> -<div class="app"> -<div align="center"> -<h1>Frequently Asked Questions</h1> </div> -<div class="h3"> -<a name="Questions"></a> -<div class="h3"> -<h3>Questions<a title="Permanent link" class="headerlink" href="#Questions">#</a> -</h3> -</div> -<ol> -<li> -<a name="faq-N10006-menu"></a><a href="#faq-N10006"> - My code uses some new feature, compiles fine but fails when live with a "MethodNotFoundException" or "IncompatibleClassChangeError" - </a> -</li> -<li> -<a name="faq-N10019-menu"></a><a href="#faq-N10019"> - My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException" - </a> -</li> -<li> -<a name="faq-N10025-menu"></a><a href="#faq-N10025"> - I'm using the poi-ooxml-schemas jar, but my code is failing with "java.lang.NoClassDefFoundError: org/openxmlformats/schemas/*something*" - </a> -</li> -<li> -<a name="faq-N100B6-menu"></a><a href="#faq-N100B6"> - Why is reading a simple sheet taking so long? - </a> -</li> -<li> -<a name="faq-N100C2-menu"></a><a href="#faq-N100C2"> - What is the HSSF "eventmodel"? - </a> -</li> -<li> -<a name="faq-N100CE-menu"></a><a href="#faq-N100CE"> - Why can't read the document I created using Star Office 5.1? - </a> -</li> -<li> -<a name="faq-N100DA-menu"></a><a href="#faq-N100DA"> - Why am I getting an exception each time I attempt to read my spreadsheet? - </a> -</li> -<li> -<a name="faq-N100E9-menu"></a><a href="#faq-N100E9"> - How do you tell if a spreadsheet cell contains a date? - </a> -</li> -<li> -<a name="faq-N100F9-menu"></a><a href="#faq-N100F9"> - I'm trying to stream an XLS file from a servlet and I'm having some trouble. What's the problem? - </a> -</li> -<li> -<a name="faq-N10123-menu"></a><a href="#faq-N10123"> - I want to set a cell format (Data format of a cell) of a excel sheet as ###,###,###.#### or ###,###,###.0000. Is it possible using POI ? - </a> -</li> -<li> -<a name="faq-N10133-menu"></a><a href="#faq-N10133"> - I want to set a cell format (Data format of a cell) of a excel sheet as text. Is it possible using POI ? - </a> -</li> -<li> -<a name="faq-N1013F-menu"></a><a href="#faq-N1013F"> - How do I add a border around a merged cell? - </a> -</li> -<li> -<a name="faq-N1014B-menu"></a><a href="#faq-N1014B"> - I am using styles when creating a workbook in POI, but Excel refuses to open the file, complaining about "Too Many Styles". - </a> -</li> -<li> -<a name="faq-N10165-menu"></a><a href="#faq-N10165"> - I think POI is using too much memory! What can I do? - </a> -</li> -<li> -<a name="faq-N10192-menu"></a><a href="#faq-N10192"> - I can't seem to find the source for the OOXML CT.. classes, where do they - come from? - </a> -</li> +<!--+ + |end search + +--> +<!--+ + |start Tabs + +--> +<ul id="tabs"> <li> -<a name="faq-N101BA-menu"></a><a href="#faq-N101BA"> - An OLE2 ("binary") file is giving me problems, but I can't share it. How can I investigate the problem on my own? - </a> +<a class="unselected" href="../index.html">Home</a> </li> -<li> -<a name="faq-N101D4-menu"></a><a href="#faq-N101D4"> - An OOXML ("xml") file is giving me problems, but I can't share it. How can I investigate the problem on my own? - </a> +<li class="current"> +<a class="selected" href="../help/index.html">Help</a> </li> <li> -<a name="faq-N101E6-menu"></a><a href="#faq-N101E6"> - Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory() - </a> +<a class="unselected" href="../components/index.html">Component APIs</a> </li> <li> -<a name="faq-N10204-menu"></a><a href="#faq-N10204"> - Can I mix POI jars from different versions? - </a> +<a class="unselected" href="../devel/index.html">Getting Involved</a> </li> -<li> -<a name="faq-N10224-menu"></a><a href="#faq-N10224"> - Can I access/modify workbooks/documents/slideshows in multiple threads? - What are the multi-threading guarantees that Apache POI makes - </a> -</li> -<li> -<a name="faq-N1023C-menu"></a><a href="#faq-N1023C"> - What are the advantages and disadvantages of the different constructor and - write methods? - </a> -</li> -<li> -<a name="faq-N1029C-menu"></a><a href="#faq-N1029C"> - Can POI be used with OSGI? - </a> -</li> -<li> -<a name="faq-N102B0-menu"></a><a href="#faq-N102B0"> - Can Apache POI be compiled/used with Java 9? - </a> -</li> -<li> -<a name="faq-N102C9-menu"></a><a href="#faq-N102C9"> - Can Apache POI be compiled/used with Java 10 or newer? - </a> -</li> -</ol> -<a name="Answers"></a> -<div class="h3"> -<h3>Answers<a title="Permanent link" class="headerlink" href="#Answers">#</a> -</h3> +</ul> +<!--+ + |end Tabs + +--> +</div> +</div> +<div id="main"> +<div id="publishedStrip"> +<!--+ + |start Subtabs + +--> +<div id="level2tabs"></div> +<!--+ + |end Endtabs + +--> +<script type="text/javascript"><!-- +document.write("Last Published: " + document.lastModified); +// --></script> +</div> +<!--+ + |breadtrail + +--> +<div class="breadtrail"> + + + </div> +<!--+ + |start Menu, mainarea + +--> +<!--+ + |start Menu + +--> +<div id="menu"> +<div onclick="SwitchMenu('menu_selected_1.1', '../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Help</div> +<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;"> +<div class="menuitem"> +<a href="../help/index.html">Mailing Lists</a> +</div> +<div class="menupage"> +<div class="menupagetitle">FAQ</div> +</div> +<div class="menuitem"> +<a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug Database</a> +</div> </div> +<div id="credit"></div> +<div id="roundbottom"> +<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div> +<!--+ + |alternative credits + +--> +<div id="credit2"> +<a href="https://donate.apache.org/";><img border="0" title="Support Apache" alt="Support Apache - logo" src="../images/support-asf.png" style="width: 125px;height: 125px;"></a> +</div> +</div> +<!--+ + |end Menu + +--> +<!--+ + |start content + +--> +<div id="content"> +<h1>Frequently Asked Questions</h1> +<div id="front-matter"></div> <a name="faq-N10006"></a> -<div class="h4"> -<h4>1. +<h2 class="boxed">1. My code uses some new feature, compiles fine but fails when live with a "MethodNotFoundException" or "IncompatibleClassChangeError" - <a title="Permanent link" class="headerlink" href="#faq-N10006">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>You almost certainly have an older version of Apache POI on your classpath. Quite a few runtimes and other packages will ship older version of Apache POI, so this is an easy problem to hit without your realising. Some will ship just one old jar, some may ship a full set of old POI jars.</p> - <p>The best way to identify the offending earlier jar files is with a few lines of java. These will load a Core POI class, an OOXML class and a Scratchpad class, and report where they all came from.</p> - <pre class="code"> ClassLoader classloader = org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader(); @@ -431,39 +168,31 @@ res = classloader.getResource("org/apach path = res.getPath(); System.out.println("POI Scratchpad came from " + path); </pre> - +</div> <a name="faq-N10019"></a> -<div class="h4"> -<h4>2. +<h2 class="boxed">2. My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException" - <a title="Permanent link" class="headerlink" href="#faq-N10019">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>You almost certainly have an older version earlier on your classpath. See the prior answer.</p> - +</div> <a name="faq-N10025"></a> -<div class="h4"> -<h4>3. +<h2 class="boxed">3. I'm using the poi-ooxml-schemas jar, but my code is failing with "java.lang.NoClassDefFoundError: org/openxmlformats/schemas/*something*" - <a title="Permanent link" class="headerlink" href="#faq-N10025">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>To use the new OOXML file formats, POI requires a jar containing the file format XSDs, as compiled by <a href="https://xmlbeans.apache.org/";>XMLBeans</a>. These XSDs, once compiled into Java classes, live in the <em>org.openxmlformats.schemas</em> namespace.</p> - <p>There are two jar files available, as described in - <a href="overview.html">the components overview section</a>. + <a href="../components/">the components overview section</a>. The <em>full jar of all of the schemas is ooxml-schemas-1.3.jar</em>, and it is currently around 15mb. The <em>smaller poi-ooxml-schemas jar</em> is only about 4mb. This latter jar file only contains the typically used parts though.</p> - <p>Many users choose to use the smaller poi-ooxml-schemas jar to save space. However, the poi-ooxml-schemas jar only contains the XSDs and classes that are typically used, as identified by the unit tests. @@ -473,27 +202,23 @@ System.out.println("POI Scratchpad came you may also wish to submit a new unit test which uses the extra parts of the XSDs, so that a future poi-ooxml-schemas jar will include them.</p> - <p>There are a number of ways to get the full ooxml-schemas-1.3.jar. If you are a maven user, see the - <a href="overview.html">the components overview section</a> + <a href="../components/">the components overview section</a> for the artifact details to have maven download it for you. If you download the source release of POI, and/or checkout the - source code from <a href="subversion.html">subversion</a>, + source code from <a href="../devel/subversion.html">subversion</a>, then you can run the ant task "compile-ooxml-xsds" to have the OOXML schemas downloaded and compiled for you (This will also give you the XMLBeans generated source code, in case you wish to look at this). Finally, you can download the jar by hand from the <a href="http://mirrors.ibiblio.org/apache/poi/";>POI Maven Repository</a>.</p> - <p>Note that historically, different versions of ooxml-schemas were used</p> - - -<table class="ForrestTable" cellspacing="1" cellpadding="4"> +<table class="POITable autosize"> -<tr class="b"> +<tr> <th colspan="1" rowspan="1">Version of ooxml-schemas</th> <th colspan="1" rowspan="1">Version of POI</th> @@ -501,7 +226,7 @@ System.out.println("POI Scratchpad came </tr> -<tr class="a"> +<tr> <td colspan="1" rowspan="1">ooxml-schemas-1.0.jar</td> <td colspan="1" rowspan="1">POI 3.5 and 3.6</td> @@ -509,7 +234,7 @@ System.out.println("POI Scratchpad came </tr> -<tr class="b"> +<tr> <td colspan="1" rowspan="1">ooxml-schemas-1.1.jar</td> <td colspan="1" rowspan="1">POI 3.7 to POI 3.13</td> @@ -517,7 +242,7 @@ System.out.println("POI Scratchpad came </tr> -<tr class="a"> +<tr> <td colspan="1" rowspan="1">ooxml-schemas-1.2.jar</td> <td colspan="1" rowspan="1">-</td> @@ -525,7 +250,7 @@ System.out.println("POI Scratchpad came </tr> -<tr class="b"> +<tr> <td colspan="1" rowspan="1">ooxml-schemas-1.3.jar</td> <td colspan="1" rowspan="1">POI 3.14 and newer</td> @@ -534,72 +259,56 @@ System.out.println("POI Scratchpad came </tr> </table> - -<a name="faq-N100B6"></a> -<div class="h4"> -<h4>4. - Why is reading a simple sheet taking so long? - <a title="Permanent link" class="headerlink" href="#faq-N100B6">#</a> -</h4> </div> - +<a name="faq-N100B7"></a> +<h2 class="boxed">4. + Why is reading a simple sheet taking so long? + </h2> +<div class="section"> <p>You've probably enabled logging. Logging is intended only for autopsy style debugging. Having it enabled will reduce performance by a factor of at least 100. Logging is helpful for understanding why POI can't read some file or developing POI itself. Important errors are thrown as exceptions, which means you probably don't need logging.</p> - -<a name="faq-N100C2"></a> -<div class="h4"> -<h4>5. - What is the HSSF "eventmodel"? - <a title="Permanent link" class="headerlink" href="#faq-N100C2">#</a> -</h4> </div> - +<a name="faq-N100C3"></a> +<h2 class="boxed">5. + What is the HSSF "eventmodel"? + </h2> +<div class="section"> <p>The SS eventmodel package is an API for reading Excel files without loading the whole spreadsheet into memory. It does require more knowledge on the part of the user, but reduces memory consumption by more than tenfold. It is based on the AWT event model in combination with SAX. If you need read-only access, this is the best way to do it.</p> - -<a name="faq-N100CE"></a> -<div class="h4"> -<h4>6. - Why can't read the document I created using Star Office 5.1? - <a title="Permanent link" class="headerlink" href="#faq-N100CE">#</a> -</h4> </div> - +<a name="faq-N100CF"></a> +<h2 class="boxed">6. + Why can't read the document I created using Star Office 5.1? + </h2> +<div class="section"> <p>Star Office 5.1 writes some records using the older BIFF standard. This causes some problems with POI which supports only BIFF8.</p> - -<a name="faq-N100DA"></a> -<div class="h4"> -<h4>7. - Why am I getting an exception each time I attempt to read my spreadsheet? - <a title="Permanent link" class="headerlink" href="#faq-N100DA">#</a> -</h4> </div> - +<a name="faq-N100DB"></a> +<h2 class="boxed">7. + Why am I getting an exception each time I attempt to read my spreadsheet? + </h2> +<div class="section"> <p>It's possible your spreadsheet contains a feature that is not currently supported by POI. If you encounter this then please create the simplest file that demonstrates the trouble and submit it to <a href="https://issues.apache.org/bugzilla/buglist.cgi?product=POI";>Bugzilla.</a> </p> - -<a name="faq-N100E9"></a> -<div class="h4"> -<h4>8. - How do you tell if a spreadsheet cell contains a date? - <a title="Permanent link" class="headerlink" href="#faq-N100E9">#</a> -</h4> </div> - +<a name="faq-N100EA"></a> +<h2 class="boxed">8. + How do you tell if a spreadsheet cell contains a date? + </h2> +<div class="section"> <p>Excel stores dates as numbers therefore the only way to determine if a cell is actually stored as a date is to look at the formatting. There is a helper method in HSSFDateUtil that checks for this. Thanks to Jason Hoffman for providing the solution.</p> - <pre class="code"> case HSSFCell.CELL_TYPE_NUMERIC: double d = cell.getNumericCellValue(); @@ -614,25 +323,20 @@ System.out.println("POI Scratchpad came cellText; } </pre> - -<a name="faq-N100F9"></a> -<div class="h4"> -<h4>9. - I'm trying to stream an XLS file from a servlet and I'm having some trouble. What's the problem? - <a title="Permanent link" class="headerlink" href="#faq-N100F9">#</a> -</h4> </div> - +<a name="faq-N100FA"></a> +<h2 class="boxed">9. + I'm trying to stream an XLS file from a servlet and I'm having some trouble. What's the problem? + </h2> +<div class="section"> <p> The problem usually manifests itself as the junk characters being shown on screen. The problem persists even though you have set the correct mime type. </p> - <p> The short answer is, don't depend on IE to display a binary file type properly if you stream it via a servlet. Every minor version of IE has different bugs on this issue. </p> - <p> The problem in most versions of IE is that it does not use the mime type on the HTTP response to determine the file type; rather it uses the file extension @@ -645,76 +349,58 @@ System.out.println("POI Scratchpad came <em>http://yourserver.com/myServelet?param1=xx&dummy=file.xls</em> is also known to work. </p> - <p> To guarantee opening the file properly in Excel from IE, write out your file to a temporary file under your web root from your servlet. Then send an http response to the browser to do a client side redirection to your temp file. (Note that using a server side redirect using RequestDispatcher will not be effective in this case) </p> - <p> Note also that when you request a document that is opened with an external handler, IE sometimes makes two requests to the webserver. So if your generating process is heavy, it makes sense to write out to a temporary file, so that multiple requests happen for a static file. </p> - <p> None of this is particular to Excel. The same problem arises when you try to generate any binary file dynamically to an IE client. For example, if you generate pdf files using <a href="https://xml.apache.org/fop";>FOP</a>, you will come across many of the same issues. </p> - - -<a name="faq-N10123"></a> -<div class="h4"> -<h4>10. - I want to set a cell format (Data format of a cell) of a excel sheet as ###,###,###.#### or ###,###,###.0000. Is it possible using POI ? - <a title="Permanent link" class="headerlink" href="#faq-N10123">#</a> -</h4> </div> - +<a name="faq-N10124"></a> +<h2 class="boxed">10. + I want to set a cell format (Data format of a cell) of a excel sheet as ###,###,###.#### or ###,###,###.0000. Is it possible using POI ? + </h2> +<div class="section"> <p> - Yes. You first need to get a DataFormat object from the workbook and call getFormat with the desired format. Some examples are <a href="spreadsheet/quick-guide.html#DataFormats">here</a>. + Yes. You first need to get a DataFormat object from the workbook and call getFormat with the desired format. Some examples are <a href="../components/spreadsheet/quick-guide.html#DataFormats">here</a>. </p> - -<a name="faq-N10133"></a> -<div class="h4"> -<h4>11. - I want to set a cell format (Data format of a cell) of a excel sheet as text. Is it possible using POI ? - <a title="Permanent link" class="headerlink" href="#faq-N10133">#</a> -</h4> </div> - +<a name="faq-N10134"></a> +<h2 class="boxed">11. + I want to set a cell format (Data format of a cell) of a excel sheet as text. Is it possible using POI ? + </h2> +<div class="section"> <p> Yes. This is a built-in format for excel that you can get from DataFormat object using the format string "@". Also, the string "text" will alias this format. </p> - -<a name="faq-N1013F"></a> -<div class="h4"> -<h4>12. - How do I add a border around a merged cell? - <a title="Permanent link" class="headerlink" href="#faq-N1013F">#</a> -</h4> </div> - +<a name="faq-N10140"></a> +<h2 class="boxed">12. + How do I add a border around a merged cell? + </h2> +<div class="section"> <p>Add blank cells around where the cells normally would have been and set the borders individually for each cell. We will probably enhance HSSF in the future to make this process easier.</p> - -<a name="faq-N1014B"></a> -<div class="h4"> -<h4>13. - I am using styles when creating a workbook in POI, but Excel refuses to open the file, complaining about "Too Many Styles". - <a title="Permanent link" class="headerlink" href="#faq-N1014B">#</a> -</h4> </div> - +<a name="faq-N1014C"></a> +<h2 class="boxed">13. + I am using styles when creating a workbook in POI, but Excel refuses to open the file, complaining about "Too Many Styles". + </h2> +<div class="section"> <p>You just create the styles OUTSIDE of the loop in which you create cells.</p> - <p>GOOD:</p> - <pre class="code"> HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("new sheet"); @@ -751,9 +437,7 @@ System.out.println("POI Scratchpad came wb.write(fileOut); fileOut.close(); </pre> - <p>BAD:</p> - <pre class="code"> HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("new sheet"); @@ -789,26 +473,21 @@ System.out.println("POI Scratchpad came wb.write(fileOut); fileOut.close(); </pre> - -<a name="faq-N10165"></a> -<div class="h4"> -<h4>14. - I think POI is using too much memory! What can I do? - <a title="Permanent link" class="headerlink" href="#faq-N10165">#</a> -</h4> </div> - +<a name="faq-N10166"></a> +<h2 class="boxed">14. + I think POI is using too much memory! What can I do? + </h2> +<div class="section"> <p>This one comes up quite a lot, but often the reason isn't what you might initially think. So, the first thing to check is - what's the source of the problem? Your file? Your code? Your environment? Or Apache POI?</p> - <p>(If you're here, you probably think it's Apache POI. However, it often isn't! A moderate laptop, with a decent but not excessive heap size, from a standing start, can normally read or write a file with 100 columns and 100,000 rows in under a couple of seconds, including the time to start the JVM).</p> - <p>Apache POI ships with a few programs and a few example programs, which can be used to do some basic performance checks. For testing file generation, the class to use is in the examples package, @@ -820,7 +499,6 @@ System.out.println("POI Scratchpad came in HSSF and SXSSF in under 3 seconds, and XSSF in under 20 seconds (and ideally all 3 in less than that!), then the problem is with your environment.</p> - <p>Next, use the example program <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a> (<a href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>viewvc</a>) @@ -833,16 +511,13 @@ System.out.println("POI Scratchpad came processed (POI makes some assumptions that might not always be right on all files). If these tests are fast, then performance problems likely are in your code.</p> - -<a name="faq-N10192"></a> -<div class="h4"> -<h4>15. +</div> +<a name="faq-N10193"></a> +<h2 class="boxed">15. I can't seem to find the source for the OOXML CT.. classes, where do they come from? - <a title="Permanent link" class="headerlink" href="#faq-N10192">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>The OOXML support in Apache POI is built on top of the file format XML Schemas, as compiled into Java using <a href="https://xmlbeans.apache.org/";>XMLBeans</a>. Currently, @@ -851,12 +526,10 @@ System.out.println("POI Scratchpad came 2.3 runtime, or any later version of XMLBeans. If you are currently using XMLBeans 2.2 or earlier, you will unfortunately have to upgrade, but this isn't common any more).</p> - <p>All of the <em>org.openxmlformats.schemas.spreadsheetml.x2006</em> CT... classes are auto-generated by XMLBeans. The resulting generated Java goes in the <em>ooxml-schemas-src</em> jar, and the compiled version into the <em>ooxml-schemas</em> jar.</p> - <p>The full <em>ooxml-schemas</em> jar is distributed with Apache POI, along with the cut-down <em>poi-ooxml-schemas</em> jar containing just the common parts. The source jar isn't normally distributed with POI. @@ -865,15 +538,12 @@ System.out.println("POI Scratchpad came the POI source distribution (or checkout from SVN) and build, Ant will automatically download the specification XML Schema, and compile it for you to generate the source and binary ooxml-schemas jars.</p> - -<a name="faq-N101BA"></a> -<div class="h4"> -<h4>16. - An OLE2 ("binary") file is giving me problems, but I can't share it. How can I investigate the problem on my own? - <a title="Permanent link" class="headerlink" href="#faq-N101BA">#</a> -</h4> </div> - +<a name="faq-N101BB"></a> +<h2 class="boxed">16. + An OLE2 ("binary") file is giving me problems, but I can't share it. How can I investigate the problem on my own? + </h2> +<div class="section"> <p>The first thing to try is running the <a href="https://blogs.msdn.com/b/officeinteroperability/archive/2011/07/12/microsoft-office-binary-file-format-validator-is-now-available.aspx";>Binary File Format Validator</a> from Microsoft against the file, which will report if the file @@ -882,51 +552,41 @@ System.out.println("POI Scratchpad came should probably in this case speak to whoever is generating the file, and have them fix it there. If your POI generated file is identified as having an issue, and you're on the - <a href="howtobuild.html">latest codebase</a>, report a new + <a href="../devel/index.html">latest codebase</a>, report a new POI bug and include the details of the validation failure.</p> - <p>Another thing to try, especially if the file is valid but POI isn't behaving as expected, are the POI Dev Tools for the component you're using. For example, HSSF has <em>org.apache.poi.hssf.dev.BiffViewer</em> which will allow you to view the file as POI does. This will often allow you to check that things are being read as you expect, and narrow in on problem records and structures.</p> - -<a name="faq-N101D4"></a> -<div class="h4"> -<h4>17. - An OOXML ("xml") file is giving me problems, but I can't share it. How can I investigate the problem on my own? - <a title="Permanent link" class="headerlink" href="#faq-N101D4">#</a> -</h4> </div> - +<a name="faq-N101D5"></a> +<h2 class="boxed">17. + An OOXML ("xml") file is giving me problems, but I can't share it. How can I investigate the problem on my own? + </h2> +<div class="section"> <p>There's not currently a simple validator tool as there is for the OLE2 based (binary) file formats, but checking the basics of a file is generally much easier.</p> - <p>Files such as .xlsx, .docx and .pptx are actually a zip file of XML files, with a special structure. Your first step in diagnosing the issues with the input or output file will likely be to unzip the file, and look at the XML of it. Newer versions of Office will normally tell you which area of the file is problematic, so narrow in on there. Looking at the XML, does it look correct?</p> - <p>When reporting bugs, ideally include the whole file, but if you're unable to then include the snippet of XML for the problem area, and reference the OOXML standard for what it should contain.</p> - -<a name="faq-N101E6"></a> -<div class="h4"> -<h4>18. - Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory() - <a title="Permanent link" class="headerlink" href="#faq-N101E6">#</a> -</h4> </div> - +<a name="faq-N101E7"></a> +<h2 class="boxed">18. + Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory() + </h2> +<div class="section"> <p>This error indicates that the class XMLEventFactory does not provide functionality which POI is depending upon. There can be a number of different reasons for this:</p> - <ul> <li>Outdated xml-apis.jar, stax-apis.jar or xercesImpl.jar:<br> @@ -949,45 +609,35 @@ System.out.println("POI Scratchpad came </li> </ul> - -<a name="faq-N10204"></a> -<div class="h4"> -<h4>19. - Can I mix POI jars from different versions? - <a title="Permanent link" class="headerlink" href="#faq-N10204">#</a> -</h4> </div> - +<a name="faq-N10205"></a> +<h2 class="boxed">19. + Can I mix POI jars from different versions? + </h2> +<div class="section"> <p>No. This is not supported.</p> - <p>All POI jars in use must come from the same version. A combination such as <em>poi-3.11.jar</em> and <em>poi-ooxml-3.9.jar</em> is not supported, and will fail to work in unpredictable ways.</p> - <p>If you're not sure which POI jars you're using at runtime, and/or you suspect it might not be the one you intended, see <a href="#faq-N10006">this FAQ entry</a> for details on diagnosing it. If you aren't sure what POI jars you need, see the - <a href="overview.html#components">Components Overview</a> + <a href="../components/">Components Overview</a> for details</p> - -<a name="faq-N10224"></a> -<div class="h4"> -<h4>20. +</div> +<a name="faq-N10225"></a> +<h2 class="boxed">20. Can I access/modify workbooks/documents/slideshows in multiple threads? What are the multi-threading guarantees that Apache POI makes - <a title="Permanent link" class="headerlink" href="#faq-N10224">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>In short: <em>Handling different document-objects in different threads will work. Accessing the same document in multiple threads will not work.</em> </p> - <p>This means the workbook/document/slideshow objects are not checked for thread safety, but any globally held object like global caches or other data structures are guarded against multi threaded access accordingly.</p> - <p>There have been <a href="https://mail-archives.apache.org/mod_mbox/poi-user/201109.mbox/%[email protected]%3E";>discussions</a> about accessing different Workbook-sheets @@ -997,69 +647,57 @@ System.out.println("POI Scratchpad came is under high load, i.e. in production use! Also it might break in future versions of Apache POI as we do not specifically test using the library this way.</p> - -<a name="faq-N1023C"></a> -<div class="h4"> -<h4>21. +</div> +<a name="faq-N1023D"></a> +<h2 class="boxed">21. What are the advantages and disadvantages of the different constructor and write methods? - <a title="Permanent link" class="headerlink" href="#faq-N1023C">#</a> -</h4> -</div> - + </h2> +<div class="section"> <p>Across most of the UserModel classes ( -<a href="/apidocs/org/apache/poi/POIDocument.html">POIDocument</a> +<a href="../apidocs/org/apache/poi/POIDocument.html">POIDocument</a> and -<a href="/apidocs/org/apache/poi/POIXMLDocument.html">POIXMLDocument</a>), +<a href="../apidocs/org/apache/poi/POIXMLDocument.html">POIXMLDocument</a>), you can open the document from a read-only <em>File</em>, a read-write <em>File</em> or an <em>InputStream</em>. You can always write out to an <em>OutputStream</em>, and increasing also to a <em>File</em>. </p> - <p>Opening your document from a <em>File</em> is suggested wherever possible. This will always be quicker and lower memory then using an <em>InputStream</em>, as the latter has to buffer things in memory.</p> - <p>When writing, you can use an <em>OutputStream</em> to write to a new file, or overwrite an existing one (provided it isn't already open!). On slow links / disks, wrapping with a <em>BufferedOutputStream</em> is suggested. To write like this, use -<a href="/apidocs/org/apache/poi/POIDocument.html#write(java.io.OutputStream)">write(OutputStream)</a>. +<a href="../apidocs/org/apache/poi/POIDocument.html#write(java.io.OutputStream)">write(OutputStream)</a>. </p> - <p>To write to the currently open file (an in-place write / replace), you need to have opened your document from a <em>File</em>, not an <em>InputStream</em>. In addition, you need to have opened from the <em>File</em> in read-write mode, not read-only mode. To write to the currently open file, on formats that support it (not all do), use -<a href="/apidocs/org/apache/poi/POIDocument.html#write()">write()</a>. +<a href="../apidocs/org/apache/poi/POIDocument.html#write()">write()</a>. </p> - <p>You can also write out to a new <em>File</em>. This is available no matter how you opened the document, and will create/replace a new file. It is faster and lower memory than writing to an <em>OutputStream</em>. However, you can't use this to replace the currently open file, only files not currently open. To write to a new / different file, use -<a href="/apidocs/org/apache/poi/POIDocument.html#write(java.io.File)">write(File)</a> +<a href="../apidocs/org/apache/poi/POIDocument.html#write(java.io.File)">write(File)</a> </p> - <p>More information is also available in the -<a href="/spreadsheet/quick-guide.html#FileInputStream">HSSF and XSSF documentation</a>, +<a href="../components/spreadsheet/quick-guide.html#FileInputStream">HSSF and XSSF documentation</a>, which largely applies to the other formats too. </p> - <p>Note that currenly (POI 3.15 beta 3), not all of the write methods are available for the OOXML formats yet. </p> - -<a name="faq-N1029C"></a> -<div class="h4"> -<h4>22. - Can POI be used with OSGI? - <a title="Permanent link" class="headerlink" href="#faq-N1029C">#</a> -</h4> </div> - +<a name="faq-N1029D"></a> +<h2 class="boxed">22. + Can POI be used with OSGI? + </h2> +<div class="section"> <p>Starting with POI 3.16 there's a workaround for OSGIs context classloader handling, i.e. it replaces the threads current context classloader with an implementation of limited class view. This will lead to IllegalStateExceptions, as xmlbeans can't find @@ -1072,26 +710,21 @@ and <em> POIXMLTypeLoader.setClassLoader(CTTable.class.getClassLoader());</em> </p> - -<a name="faq-N102B0"></a> -<div class="h4"> -<h4>23. - Can Apache POI be compiled/used with Java 9? - <a title="Permanent link" class="headerlink" href="#faq-N102B0">#</a> -</h4> </div> - +<a name="faq-N102B1"></a> +<h2 class="boxed">23. + Can Apache POI be compiled/used with Java 9? + </h2> +<div class="section"> <p>Running the existing binaries with Java 9 should work. You may see some warnings about illegal reflective access, but it should work fine despite those. We are working on getting the code changed so we avoid these discouraged accesses. </p> - <p>We also did some work to verify that compilation with Java 9 is working and that all unit-tests pass. So Apache POI should be ready to be used with current Java 9 releases. </p> - <p>NOTE: Apache POI does not yet fully support the Java 9 module system as Apache POI is still supporting previous Java versions and the module system cannot be fully supported while maintaining such support. @@ -1099,12 +732,10 @@ and not trivial as Apache POI currently uses the same package in different jar-files which Java 9/Modules/Automatic Modules does not allow any more! </p> - <p>For compiling Apache POI, you should set some additional options as follows to open up some modules that are needed and to unset some compiler options which are not supported any more. </p> - <pre class="code"> # requires Ant >= 1.9.5 due to https://bz.apache.org/bugzilla/show_bug.cgi?id=58271 export ANT_HOME=/opt/apache/apache-ant/apache-ant-1.9.7 @@ -1130,63 +761,45 @@ and -Dcoverage.enabled=true \ test-all </pre> - - -<a name="faq-N102C9"></a> -<div class="h4"> -<h4>24. - Can Apache POI be compiled/used with Java 10 or newer? - <a title="Permanent link" class="headerlink" href="#faq-N102C9">#</a> -</h4> </div> - +<a name="faq-N102CA"></a> +<h2 class="boxed">24. + Can Apache POI be compiled/used with Java 10 or newer? + </h2> +<div class="section"> <p>Apache POI is not yet fully supported on Java 10 or newer. The binary formats (.xls, .doc, .ppt, ...) should mostly work, but unfortunately reading the newer XML-based formats (.xlsx, .docx, pptx, ...) is broken by a change to the ZIP file handling in Java 10, see <a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62187";>bug 62187</a> for details and the latest state. </p> - </div> </div> +<!--+ + |end content + +--> +<div class="clearboth"> </div> </div> -</td> -<!--================= end Content ==================--> -</tr> -</tbody> -</table> -<!--================= end Main ==================--> -<!--================= start Footer ==================--> <div id="footer"> -<table summary="footer" cellspacing="0" cellpadding="4" width="100%" border="0"> -<tbody> -<tr> -<!--================= start Copyright ==================--> -<td colspan="2"> -<div align="center"> -<div class="copyright"> - Copyright © 2002-2018 The Apache Software Foundation. All rights reserved.<br> - Apache, Apache POI, and the Apache POI logo are registered trademarks or - trademarks of The Apache Software Foundation in the U.S. and/or other countries. - </div> +<!--+ + |start bottomstrip + +--> +<div class="lastmodified"> +<script type="text/javascript"><!-- +document.write("Last Published: " + document.lastModified); +// --></script> </div> -</td> -<!--================= end Copyright ==================--> -</tr> -<tr> -<td align="left"> -<!--================= start Host ==================--> -<!--================= end Host ==================--></td><td align="right"> -<!--================= start Credits ==================--> -<div align="right"> -<div class="credit"></div> +<div class="copyright"> + Copyright © + 2001-2018 <a href="https://www.apache.org/";>The Apache Software Foundation</a> </div> -<!--================= end Credits ==================--> -</td> -</tr> -</tbody> -</table> +<div id="feedback"> + Send feedback about the website to: + <a id="feedbackto" href="mailto:[email protected]?subject=Feedback%C2%A0help/faq.html";>[email protected]</a> +</div> +<!--+ + |end bottomstrip + +--> </div> -<!--================= end Footer ==================--> </body> </html>
Copied: poi/site/publish/help/index.html (from r1836243, poi/site/publish/mailinglists.html) URL: http://svn.apache.org/viewvc/poi/site/publish/help/index.html?p2=poi/site/publish/help/index.html&p1=poi/site/publish/mailinglists.html&r1=1836243&r2=1836244&rev=1836244&view=diff ============================================================================== --- poi/site/publish/mailinglists.html (original) +++ poi/site/publish/help/index.html Wed Jul 18 23:27:21 2018 @@ -1,274 +1,148 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> +<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> -<!--*** This is a generated file. Do not edit. ***--> -<link rel="stylesheet" href="skin/tigris.css" type="text/css"> -<link rel="stylesheet" href="skin/mysite.css" type="text/css"> -<link rel="stylesheet" href="skin/site.css" type="text/css"> -<link media="print" rel="stylesheet" href="skin/print.css" type="text/css"> +<meta content="Apache Forrest" name="Generator"> +<meta name="Forrest-version" content="0.9"> +<meta name="Forrest-skin-name" content="pelt"> <title>Mailing Lists</title> +<link type="text/css" href="../skin/basic.css" rel="stylesheet"> +<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet"> +<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet"> +<link type="text/css" href="../skin/profile.css" rel="stylesheet"> +<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script> +<link rel="shortcut icon" href="../images/favicon.ico"> </head> -<body bgcolor="white" class="composite"> -<!--================= start Banner ==================--> -<div id="banner"> -<table width="100%" cellpadding="8" cellspacing="0" summary="banner" border="0"> -<tbody> -<tr> -<!--================= start Group Logo ==================--> -<td width="50%" align="left"> -<div class="groupLogo"> -<a href="https://www.apache.org";><img border="0" class="logoImage" alt="The Apache Software Foundation" src="resources/images/asf_logo.png"></a> -</div> -</td> -<!--================= end Group Logo ==================--> -<!--================= start Project Logo ==================--><td width="50%" align="right"> -<div align="right" class="projectLogo"> -<a href="https://donate.apache.org/";><img border="0" class="logoImage" alt="Support Apache" src="resources/images/support-asf.png" width="120" height="120" title="Your donation helps The Apache Software Foundation ensure its community-driven software remains available to billions of users at absolutely no cost."></a><a href="https://poi.apache.org/";><img border="0" class="logoImage" alt="Apache POI" src="resources/images/pb-poi.png" width="120" height="120" title="Apache POI - the Java API for Microsoft Documents"></a> -</div> -</td> -<!--================= end Project Logo ==================--> -</tr> -</tbody> -</table> -</div> -<!--================= end Banner ==================--> -<!--================= start Main ==================--> -<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" id="breadcrumbs"> -<tbody> -<!--================= start Status ==================--> -<tr class="status"> -<td> -<!--================= start BreadCrumb ==================--><a href="https://www.apache.org/";>Apache</a> | <a href="https://poi.apache.org/";>POI</a><a href=""></a> -<!--================= end BreadCrumb ==================--></td><td id="tabs"> -<!--================= start Tabs ==================--> -<div class="tab"> -<span class="selectedTab"><a class="base-selected" href="index.html">Home</a></span> | <script language="Javascript" type="text/javascript"> -function printit() { -if (window.print) { - window.print() ; -} else { - var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>'; -document.body.insertAdjacentHTML('beforeEnd', WebBrowser); - WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box WebBrowser1.outerHTML = ""; -} -} -</script><script language="Javascript" type="text/javascript"> -var NS = (navigator.appName == "Netscape"); -var VERSION = parseInt(navigator.appVersion); -if (VERSION > 3) { - document.write(' <a title="PRINT this page OUT" href="javascript:printit()">PRINT</a>'); -} -</script> -</div> -<!--================= end Tabs ==================--> -</td> -</tr> -</tbody> -</table> -<!--================= end Status ==================--> -<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" border="0"> -<tbody> -<tr valign="top"> -<!--================= start Menu ==================--> -<td id="leftcol"> -<div id="navcolumn"> -<div class="menuBar"> -<div class="menu"> -<span class="menuLabel">Overview</span> - -<div class="menuItem"> -<a href="index.html">Home</a> -</div> - -<div class="menuItem"> -<a href="download.html">Download</a> -</div> - -<div class="menuItem"> -<a href="overview.html">Components</a> -</div> - -<div class="menuItem"> -<a href="text-extraction.html">Text Extraction</a> -</div> - -<div class="menuItem"> -<a href="encryption.html">Encryption support</a> -</div> - -<div class="menuItem"> -<a href="casestudies.html">Case Studies</a> -</div> - -<div class="menuItem"> -<a href="related-projects.html">Related projects</a> -</div> - -<div class="menuItem"> -<a href="legal.html">Legal</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Help</span> - -<div class="menuItem"> -<a href="apidocs/index.html">Javadocs</a> +<body onload="init()"> +<script type="text/javascript">ndeSetTextSize();</script> +<div id="top"> +<!--+ + |breadtrail + +--> +<div class="breadtrail"> +<a href="https://www.apache.org";>Apache Software Foundation</a> > <a href="https://poi.apache.org";>Apache POI</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script> +</div> +<!--+ + |header + +--> +<div class="header"> +<!--+ + |start group logo + +--> +<div class="grouplogo"> +<a href="https://www.apache.org";><img class="logoImage" alt="Apache Software Foundation" src="../images/group-logo.png" title="The Apache Software Foundation is a cornerstone of the modern Open Source software ecosystem – supporting some of the most widely used and important software solutions powering today's Internet economy."></a> +</div> +<!--+ + |end group logo + +--> +<!--+ + |start Project Logo + +--> +<div class="projectlogo"> +<a href="https://poi.apache.org";><img class="logoImage" alt="Apache POI" src="../images/project-logo.png" title="Apache POI is well-known in the Java field as a library for reading and writing Microsoft Office file formats, such as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the older (OLE2) and new (OOXML - Office Open XML) formats."></a> +</div> +<!--+ + |end Project Logo + +--> +<!--+ + |start Search + +--> +<div class="searchbox"> +<form action="http://www.google.com/search"; method="get" class="roundtopsmall"> +<input value="poi.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google"> + <input name="Search" value="Search" type="submit"> +</form> </div> - -<div class="menuItem"> -<a href="faq.html">FAQ</a> +<!--+ + |end search + +--> +<!--+ + |start Tabs + +--> +<ul id="tabs"> +<li> +<a class="unselected" href="../index.html">Home</a> +</li> +<li class="current"> +<a class="selected" href="../help/index.html">Help</a> +</li> +<li> +<a class="unselected" href="../components/index.html">Component APIs</a> +</li> +<li> +<a class="unselected" href="../devel/index.html">Getting Involved</a> +</li> +</ul> +<!--+ + |end Tabs + +--> +</div> +</div> +<div id="main"> +<div id="publishedStrip"> +<!--+ + |start Subtabs + +--> +<div id="level2tabs"></div> +<!--+ + |end Endtabs + +--> +<script type="text/javascript"><!-- +document.write("Last Published: " + document.lastModified); +// --></script> +</div> +<!--+ + |breadtrail + +--> +<div class="breadtrail"> + + + </div> +<!--+ + |start Menu, mainarea + +--> +<!--+ + |start Menu + +--> +<div id="menu"> +<div onclick="SwitchMenu('menu_selected_1.1', '../skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('../skin/images/chapter_open.gif');">Help</div> +<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;"> +<div class="menupage"> +<div class="menupagetitle">Mailing Lists</div> </div> - -<div class="menuItem"> -<span class="menuSelected">Mailing Lists</span> +<div class="menuitem"> +<a href="../help/faq.html">FAQ</a> </div> - -<div class="menuItem"> +<div class="menuitem"> <a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug Database</a> </div> - -<div class="menuItem"> -<a href="changes.html">Changelog</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Getting Involved</span> - -<div class="menuItem"> -<a href="subversion.html">Subversion Repository</a> -</div> - -<div class="menuItem"> -<a href="howtobuild.html">How To Build</a> -</div> - -<div class="menuItem"> -<a href="guidelines.html">Contribution Guidelines</a> -</div> - -<div class="menuItem"> -<a href="who.html">Who We Are</a> </div> - -</div> -<div class="menu"> -<span class="menuLabel">Component APIs</span> - -<div class="menuItem"> -<a href="spreadsheet/index.html">Excel (SS=HSSF+XSSF+SXSSF)</a> -</div> - -<div class="menuItem"> -<a href="slideshow/index.html">PowerPoint (SL=HSLF+XSLF)</a> -</div> - -<div class="menuItem"> -<a href="document/index.html">Word (WP=HWPF+XWPF)</a> -</div> - -<div class="menuItem"> -<a href="hsmf/index.html">Outlook (HSMF)</a> -</div> - -<div class="menuItem"> -<a href="diagram/index.html">Visio (HDGF+XDGF)</a> -</div> - -<div class="menuItem"> -<a href="hpbf/index.html">Publisher (HPBF)</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Low-level Component APIs</span> - -<div class="menuItem"> -<a href="poifs/index.html">OLE2 Filesystem (POIFS)</a> -</div> - -<div class="menuItem"> -<a href="hpsf/index.html">OLE2 Document Props (HPSF)</a> -</div> - -<div class="menuItem"> -<a href="hmef/index.html">TNEF (HMEF) for winmail.dat</a> -</div> - -<div class="menuItem"> -<a href="oxml4j/index.html">OpenXML4J (OOXML)</a> -</div> - -<div class="menuItem"> -<a href="logging.html">Logging framework</a> -</div> - -</div> -<div class="menu"> -<span class="menuLabel">Apache Wide</span> - -<div class="menuItem"> -<a href="https://www.apache.org/";>Apache Software Foundation</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/licenses/";>License</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/thanks.html";>Thanks</a> -</div> - -<div class="menuItem"> -<a href="https://www.apache.org/security/";>Security</a> -</div> - -</div> -<center> -<a href="https://www.apache.org/events/current-event.html";><img src="https://www.apache.org/events/current-event-125x125.png";></a> -</center> -</div> -</div> -<form target="_blank" action="https://www.google.com/search"; method="get"> -<table summary="search" border="0" cellspacing="0" cellpadding="0"> -<tr> -<td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"> - Search Apache POI<br> -<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" name="q" id="query" type="text"><img height="1" width="5" alt="" src="skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" type="submit"></td><td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td> -</tr> -<tr> -<td colspan="3"><img height="7" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td> -</tr> -<tr> -<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td class="bottom-right-thick"></td> -</tr> -</table> -</form> -</td> -<!--================= end Menu ==================--> -<!--================= start Content ==================--><td> -<div id="bodycol"> -<div class="app"> -<div align="center"> +<div id="credit"> +<hr> +<a href="https://www.apache.org/events/current-event.html";><img border="0" title="Apache Event" alt="Apache Event - logo" src="http://www.apache.org/events/current-event-125x125.png"; style="width: 125px;height: 125px;"></a> +</div> +<div id="roundbottom"> +<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div> +<!--+ + |alternative credits + +--> +<div id="credit2"> +<a href="https://donate.apache.org/";><img border="0" title="Support Apache" alt="Support Apache - logo" src="../images/support-asf.png" style="width: 125px;height: 125px;"></a> +</div> +</div> +<!--+ + |end Menu + +--> +<!--+ + |start content + +--> +<div id="content"> <h1>Mailing Lists</h1> -</div> -<div class="h3"> - - - +<div id="front-matter"></div> <a name="Mailing+Lists+-+Guidelines"></a> -<div class="h3"> -<h3>Mailing Lists - Guidelines<a title="Permanent link" class="headerlink" href="#Mailing+Lists+-+Guidelines">#</a> -</h3> -</div> - +<h2 class="boxed">Mailing Lists - Guidelines</h2> +<div class="section"> <p> <strong>Before subscribing or participating in any of the mailing @@ -276,7 +150,6 @@ if (VERSION > 3) { guidelines:</strong> </p> - <ul> <li> @@ -292,20 +165,13 @@ if (VERSION > 3) { </li> </ul> - +</div> <a name="Lists"></a> -<div class="h3"> -<h3>Lists<a title="Permanent link" class="headerlink" href="#Lists">#</a> -</h3> -</div> - +<h2 class="boxed">Lists</h2> +<div class="section"> <a name="The+POI+Developer+List"></a> -<div class="h4"> -<h4>The POI Developer List<a title="Permanent link" class="headerlink" href="#The+POI+Developer+List">#</a> -</h4> -</div> - +<h3 class="boxed">The POI Developer List</h3> <p> <strong>Medium Traffic</strong> @@ -313,7 +179,6 @@ if (VERSION > 3) { Participate and Subscribe to the Dev List</a> </p> - <p> This is the list where participating developers of the POI project meet and discuss issues, code changes/additions, etc. @@ -323,26 +188,19 @@ if (VERSION > 3) { configuration problems. Use the <a href="#The+POI+User+List">POI User List</a> or community sites such as <a href="#Stack+Overflow">Stack Overflow</a>, instead.</strong> -</p> - +</p> <p> Alternate options: - <a href="mailto:[email protected]";>Subscribe</a> - <a href="mailto:[email protected]";>Unsubscribe</a> + <a href="mailto:dev-subscribe.at.poi.apache.org";>Subscribe</a> + <a href="mailto:dev-unsubscribe.at.poi.apache.org";>Unsubscribe</a> <a href="https://mail-archives.apache.org/mod_mbox/poi-dev/";>Old Archive</a> <a href="http://news.gmane.org/gmane.comp.jakarta.poi.devel";>gmane.org</a> <a href="http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html";>Nabble</a> <a href="http://markmail.org/search/org.apache.poi.dev+list:org.apache.poi.dev";>MarkMail</a> -</p> - - +</p> <a name="The+POI+User+List"></a> -<div class="h4"> -<h4>The POI User List<a title="Permanent link" class="headerlink" href="#The+POI+User+List">#</a> -</h4> -</div> - +<h3 class="boxed">The POI User List</h3> <p> <strong>Low Traffic</strong> @@ -350,31 +208,23 @@ if (VERSION > 3) { Participate and Subscribe to the User List</a> </p> - <p> This list is for users of POI to ask questions, share knowledge, and discuss issues. POI developers are also expected to be lurking on this list to offer support to users of POI. </p> - <p> Alternate options: - <a href="mailto:[email protected]";>Subscribe</a> - <a href="mailto:[email protected]";>Unsubscribe</a> + <a href="mailto:user-subscribe.at.poi.apache.org";>Subscribe</a> + <a href="mailto:user-unsubscribe.at.poi.apache.org";>Unsubscribe</a> <a href="https://mail-archives.apache.org/mod_mbox/poi-user/";>Old Archive</a> <a href="http://news.gmane.org/thread.php?group=gmane.comp.jakarta.poi.user";>gmane.org</a> <a href="http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html";>Nabble</a> <a href="http://markmail.org/search/org.apache.poi.user+list:org.apache.poi.user";>MarkMail</a> -</p> - - +</p> <a name="The+POI+General+List"></a> -<div class="h4"> -<h4>The POI General List<a title="Permanent link" class="headerlink" href="#The+POI+General+List">#</a> -</h4> -</div> - +<h3 class="boxed">The POI General List</h3> <p> <strong>Very Low Traffic</strong> @@ -382,110 +232,88 @@ if (VERSION > 3) { Participate and Subscribe to the General List</a> </p> - <p> This list exists for general discussions on POI, not specific to code or problems with code. Used for discussion of general matters relating to all of the POI project, such as the website and changes in procedures. - </p> - + </p> <p> Alternate options: - <a href="mailto:[email protected]";>Subscribe</a> - <a href="mailto:[email protected]";>Unsubscribe</a> + <a href="mailto:general-subscribe.at.poi.apache.org";>Subscribe</a> + <a href="mailto:general-unsubscribe.at.poi.apache.org";>Unsubscribe</a> <a href="https://mail-archives.apache.org/mod_mbox/poi-general/";>Old Archive</a> -</p> - - +</p> +</div> <a name="IRC"></a> -<div class="h3"> -<h3>IRC<a title="Permanent link" class="headerlink" href="#IRC">#</a> -</h3> -</div> - +<h2 class="boxed">IRC</h2> +<div class="section"> <p>The #apache-poi channel on the <a href="https://webchat.freenode.net/?channels=#apache-poi";>irc.freenode.net</a> IRC network is a good place for quick questions. If your questions require a more in-depth answer, you will likely be encouraged to move the question to the mailing list. </p> - +</div> <a name="Stack+Overflow+and+other+communities"></a> -<div class="h3"> -<h3>Stack Overflow and other communities<a title="Permanent link" class="headerlink" href="#Stack+Overflow+and+other+communities">#</a> -</h3> -</div> - +<h2 class="boxed">Stack Overflow and other communities</h2> +<div class="section"> <p> There are many POI users in the Stack Overflow community who have asked and answered questions that may be similar to the problem you are facing. Search for the <a href="http://stackoverflow.com/questions/tagged/apache-poi";>apache-poi</a> tag on Stack Overflow. </p> - <p>Regardless of which community you seek help from, remember to be courteous. Short, working code examples, an explanation of observed and expected behavior, the version of POI you are using, and genuine troubleshooting and research effort on your part go a long way towards getting a helpful answer. </p> - -<p>Please read through the <a href="faq.html">FAQ</a>, - <a href="spreadsheet/quick-guide.html">Quick Guide</a>, - <a href="spreadsheet/how-to.html">How To</a> or - <a href="slideshow/xslf-cookbook.html">Cookbook</a>, and - <a href="spreadsheet/examples.html">Examples</a> +<p>Please read through the <a href="../help/faq.html">FAQ</a>, + <a href="../components/spreadsheet/quick-guide.html">Quick Guide</a>, + <a href="../components/spreadsheet/how-to.html">How To</a> or + <a href="../components/slideshow/xslf-cookbook.html">Cookbook</a>, and + <a href="../components/spreadsheet/examples.html">Examples</a> of the POI module that you are trying to use before consulting help. You may also find your question has already been answered on the POI <a href="#The+POI+Developer+List">dev</a> or <a href="#The+POI+User+List">user</a> mailing lists, <a href="https://bz.apache.org/bugzilla/describecomponents.cgi?product=POI";>bugzilla</a>, </p> - - - - -<div id="authors" align="right">by Nick Burch</div> </div> + +<p align="right"> +<font size="-2">by Nick Burch</font> +</p> </div> +<!--+ + |end content + +--> +<div class="clearboth"> </div> </div> -</td> -<!--================= end Content ==================--> -</tr> -</tbody> -</table> -<!--================= end Main ==================--> -<!--================= start Footer ==================--> <div id="footer"> -<table summary="footer" cellspacing="0" cellpadding="4" width="100%" border="0"> -<tbody> -<tr> -<!--================= start Copyright ==================--> -<td colspan="2"> -<div align="center"> +<!--+ + |start bottomstrip + +--> +<div class="lastmodified"> +<script type="text/javascript"><!-- +document.write("Last Published: " + document.lastModified); +// --></script> +</div> <div class="copyright"> - Copyright © 2002-2018 The Apache Software Foundation. All rights reserved.<br> - Apache, Apache POI, and the Apache POI logo are registered trademarks or - trademarks of The Apache Software Foundation in the U.S. and/or other countries. - </div> -</div> -</td> -<!--================= end Copyright ==================--> -</tr> -<tr> -<td align="left"> -<!--================= start Host ==================--> -<!--================= end Host ==================--></td><td align="right"> -<!--================= start Credits ==================--> -<div align="right"> -<div class="credit"></div> -</div> -<!--================= end Credits ==================--> -</td> -</tr> -</tbody> -</table> + Copyright © + 2001-2018 <a href="https://www.apache.org/";>The Apache Software Foundation</a> +</div> +<div id="logos"> +<a href="http://validator.w3.org/check/referer";><img style="height: 31px; width: 88px;" title="Valid HTML 4.01!" alt="Valid HTML 4.01!" src="../skin/images/valid-html401.png" class="logoImage"></a><a href="http://jigsaw.w3.org/css-validator/check/referer";><img style="height: 31px; width: 88px;" title="Valid CSS!" alt="Valid CSS!" src="../skin/images/vcss.png" class="logoImage"></a> +</div> +<div id="feedback"> + Send feedback about the website to: + <a id="feedbackto" href="mailto:[email protected]?subject=Feedback%C2%A0help/index.html";>[email protected]</a> +</div> +<!--+ + |end bottomstrip + +--> </div> -<!--================= end Footer ==================--> </body> </html> Added: poi/site/publish/images/add.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/add.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/add.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/favicon.ico URL: http://svn.apache.org/viewvc/poi/site/publish/images/favicon.ico?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/favicon.ico ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/fix.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/fix.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/fix.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/group-logo.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/group-logo.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/group-logo.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/instruction_arrow.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/instruction_arrow.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/instruction_arrow.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/project-logo.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/project-logo.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/project-logo.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/remove.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/remove.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/remove.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/support-asf.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/support-asf.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/support-asf.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: poi/site/publish/images/update.png URL: http://svn.apache.org/viewvc/poi/site/publish/images/update.png?rev=1836244&view=auto ============================================================================== Binary file - no diff available. Propchange: poi/site/publish/images/update.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
![https://www.apache.org/events/current-event-125x125.png"](https://www.apache.org/events/current-event-125x125.png"){kind=link}
![http://www.apache.org/events/current-event-125x125.png"](http://www.apache.org/events/current-event-125x125.png"){kind=link}
