Modified: poi/site/publish/components/oxml4j/index.html URL: http://svn.apache.org/viewvc/poi/site/publish/components/oxml4j/index.html?rev=1836244&r1=1836243&r2=1836244&view=diff ============================================================================== --- poi/site/publish/components/oxml4j/index.html (original) +++ poi/site/publish/components/oxml4j/index.html Wed Jul 18 23:27:21 2018 @@ -1,195 +1,341 @@ -<!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>POI-OpenXML4J - Java API To Access Office Open XML documents</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">Apache POI</span> -<div class="menuItem"> -<a href="../index.html">Top</a> -</div> -</div> -<div class="menu"> -<span class="menuLabel">OpenXML4J</span> -<div class="menuItem"> -<span class="menuSelected">Overview</span> -</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>POI-OpenXML4J - Java API To Access Office Open XML documents</h1> </div> -<div class="h3"> - +<!--+ + |end search + +--> +<!--+ + |start Tabs + +--> +<ul id="tabs"> +<li> +<a class="unselected" href="../../index.html">Home</a> +</li> +<li> +<a class="unselected" href="../../help/index.html">Help</a> +</li> +<li class="current"> +<a class="selected" 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');">Component APIs</div> +<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;"> +<div class="menuitem"> +<a href="../../components/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../apidocs/index.html">Javadocs</a> +</div> +<div onclick="SwitchMenu('menu_1.1.3', '../../skin/')" id="menu_1.1.3Title" class="menutitle">Excel (HSSF/XSSF)</div> +<div id="menu_1.1.3" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/spreadsheet/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/quick-guide.html">Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/how-to.html">HOWTO</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/converting.html">HSSF to SS Converting</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/formula.html">Formula Support</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/eval.html">Formula Evaluation</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/eval-devguide.html">Eval Dev Guide</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/examples.html">Examples</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/use-case.html">Use Case</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/diagrams.html">Pictorial Docs</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/limitations.html">Limitations</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/user-defined-functions.html">User Defined Functions</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/excelant.html">ExcelAnt Tests</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/record-generator.html">Record Generator</a> +</div> +<div class="menuitem"> +<a href="../../components/spreadsheet/chart.html">Charts</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.1.4', '../../skin/')" id="menu_1.1.4Title" class="menutitle">PowerPoint (HSLF/XSLF)</div> +<div id="menu_1.1.4" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/slideshow/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/slideshow/quick-guide.html">Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../../components/slideshow/how-to-shapes.html">HSLF Cookbook</a> +</div> +<div class="menuitem"> +<a href="../../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a> +</div> +<div class="menuitem"> +<a href="../../components/slideshow/ppt-file-format.html">PPT File Format</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.1.5', '../../skin/')" id="menu_1.1.5Title" class="menutitle">Word (HWPF/XWPF)</div> +<div id="menu_1.1.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/document/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/document/quick-guide.html">HWPF Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../../components/document/docoverview.html">HWPF Format</a> +</div> +<div class="menuitem"> +<a href="../../components/document/projectplan.html">HWPF Project plan</a> +</div> +</div> +<div class="menuitem"> +<a href="../../components/hsmf/index.html">Outlook (HSMF)</a> +</div> +<div class="menuitem"> +<a href="../../components/diagram/index.html">Visio (HDGF+XDGF)</a> +</div> +<div onclick="SwitchMenu('menu_1.1.8', '../../skin/')" id="menu_1.1.8Title" class="menutitle">Publisher (HPBF)</div> +<div id="menu_1.1.8" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/hpbf/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/hpbf/file-format.html">File Format</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.1.9', '../../skin/')" id="menu_1.1.9Title" class="menutitle">OLE2 Filesystem (POIFS)</div> +<div id="menu_1.1.9" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/poifs/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/poifs/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../../components/poifs/embeded.html">Embedded Documents</a> +</div> +<div class="menuitem"> +<a href="../../components/poifs/fileformat.html">File System Documentation</a> +</div> +<div class="menuitem"> +<a href="../../components/poifs/usecases.html">Use Cases</a> +</div> +<div class="menuitem"> +<a href="../../components/poifs/design.html">Design</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.1.10', '../../skin/')" id="menu_1.1.10Title" class="menutitle">OLE2 Document Props (HPSF)</div> +<div id="menu_1.1.10" class="menuitemgroup"> +<div class="menuitem"> +<a href="../../components/hpsf/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../../components/hpsf/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../../components/hpsf/thumbnails.html">Thumbnails</a> +</div> +<div class="menuitem"> +<a href="../../components/hpsf/internals.html">Internals</a> +</div> +<div class="menuitem"> +<a href="../../components/hpsf/todo.html">To Do</a> +</div> +</div> +<div class="menuitem"> +<a href="../../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a> +</div> +<div class="menupage"> +<div class="menupagetitle">OpenXML4J (OOXML)</div> +</div> +<div class="menuitem"> +<a href="../../components/logging.html">Logging framework</a> +</div> +</div> +<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>POI-OpenXML4J - Java API To Access Office Open XML documents</h1> +<h3>Overview</h3> +<div id="front-matter"></div> <a name="Overview"></a> -<div class="h3"> -<h3>Overview<a title="Permanent link" class="headerlink" href="#Overview">#</a> -</h3> -</div> - - +<h2 class="boxed">Overview</h2> +<div class="section"> <p>OpenXML4J is the POI Project's pure Java implementation of the Open Packaging Conventions (OPC) defined in <a href="http://www.ecma-international.org/publications/standards/Ecma-376.htm";>ECMA-376</a>.</p> - <p>Every OpenXML file comprises a collection of byte streams called parts, combined into a container called a package. POI OpenXML4J provides a physical implementation of the OPC that uses the Zip file format.</p> - +</div> <a name="History"></a> -<div class="h3"> -<h3>History<a title="Permanent link" class="headerlink" href="#History">#</a> -</h3> -</div> - - +<h2 class="boxed">History</h2> +<div class="section"> <p>OpenXML4J was originally developed by <a href="http://web.archive.org/web/20090611063015/http://www.openxml4j.org/";>openxml4j.org</a>, and was contributed to Apache POI in 2008. The original code is available at <a href="https://sourceforge.net/projects/openxml4j/";>https://sourceforge.net/projects/openxml4j/</a>. Thanks to the support and guidance of Julien Chable</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"> +<!--+ + |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"> -<a href="http://validator.w3.org/check/referer";><img width="88" height="31" alt="Valid HTML 4.01!" src="../skin/images/valid-html401.png" class="logoImage"></a><a href="http://jigsaw.w3.org/css-validator/";><img width="88" height="31" alt="Valid CSS!" src="../skin/images/vcss.png" class="logoImage"></a><a href="https://forrest.apache.org/";><img border="0" class="logoImage" alt="Built with Apache Forrest" src="../skin/images/built-with-forrest-button.png" width="88" height="31"></a> -</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%A0components/oxml4j/index.html";>[email protected]</a> +</div> +<!--+ + |end bottomstrip + +--> </div> -<!--================= end Footer ==================--> </body> </html>
Copied: poi/site/publish/components/poi-jvm-languages.html (from r1836243, poi/site/publish/poi-jvm-languages.html) URL: http://svn.apache.org/viewvc/poi/site/publish/components/poi-jvm-languages.html?p2=poi/site/publish/components/poi-jvm-languages.html&p1=poi/site/publish/poi-jvm-languages.html&r1=1836243&r2=1836244&rev=1836244&view=diff ============================================================================== --- poi/site/publish/poi-jvm-languages.html (original) +++ poi/site/publish/components/poi-jvm-languages.html Wed Jul 18 23:27:21 2018 @@ -1,280 +1,411 @@ -<!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>JVM languages</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> +<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> -<!--================= 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> +<!--+ + |end search + +--> +<!--+ + |start Tabs + +--> +<ul id="tabs"> +<li> +<a class="unselected" href="../index.html">Home</a> +</li> +<li> +<a class="unselected" 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_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Overview</div> +<div id="menu_1.1" class="menuitemgroup"> +<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="../changes.html">Changelog</a> +</div> +<div class="menuitem"> +<a href="../apidocs/index.html">Javadocs</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 onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Apache Wide</div> +<div id="menu_1.2" class="menuitemgroup"> +<div class="menuitem"> +<a href="https://www.apache.org/";>Apache Software Foundation</a> </div> - -<div class="menuItem"> -<a href="download.html">Download</a> +<div class="menuitem"> +<a href="https://www.apache.org/licenses/";>License</a> </div> - -<div class="menuItem"> -<a href="overview.html">Components</a> +<div class="menuitem"> +<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a> </div> - -<div class="menuItem"> -<a href="text-extraction.html">Text Extraction</a> +<div class="menuitem"> +<a href="https://www.apache.org/foundation/thanks.html";>Thanks</a> </div> - -<div class="menuItem"> -<a href="encryption.html">Encryption support</a> +<div class="menuitem"> +<a href="https://www.apache.org/security/";>Security</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 onclick="SwitchMenu('menu_1.3', '../skin/')" id="menu_1.3Title" class="menutitle">Component APIs</div> +<div id="menu_1.3" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/index.html">Overview</a> </div> - -<div class="menuItem"> -<a href="legal.html">Legal</a> +<div class="menuitem"> +<a href="../apidocs/index.html">Javadocs</a> </div> - +<div onclick="SwitchMenu('menu_1.3.3', '../skin/')" id="menu_1.3.3Title" class="menutitle">Excel (HSSF/XSSF)</div> +<div id="menu_1.3.3" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/spreadsheet/index.html">Overview</a> </div> -<div class="menu"> -<span class="menuLabel">Help</span> - -<div class="menuItem"> -<a href="apidocs/index.html">Javadocs</a> +<div class="menuitem"> +<a href="../components/spreadsheet/quick-guide.html">Quick Guide</a> </div> - -<div class="menuItem"> -<a href="faq.html">FAQ</a> +<div class="menuitem"> +<a href="../components/spreadsheet/how-to.html">HOWTO</a> </div> - -<div class="menuItem"> -<a href="mailinglists.html">Mailing Lists</a> +<div class="menuitem"> +<a href="../components/spreadsheet/converting.html">HSSF to SS Converting</a> </div> - -<div class="menuItem"> -<a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug Database</a> +<div class="menuitem"> +<a href="../components/spreadsheet/formula.html">Formula Support</a> </div> - -<div class="menuItem"> -<a href="changes.html">Changelog</a> +<div class="menuitem"> +<a href="../components/spreadsheet/eval.html">Formula Evaluation</a> </div> - +<div class="menuitem"> +<a href="../components/spreadsheet/eval-devguide.html">Eval Dev Guide</a> </div> -<div class="menu"> -<span class="menuLabel">Getting Involved</span> - -<div class="menuItem"> -<a href="subversion.html">Subversion Repository</a> +<div class="menuitem"> +<a href="../components/spreadsheet/examples.html">Examples</a> </div> - -<div class="menuItem"> -<a href="howtobuild.html">How To Build</a> +<div class="menuitem"> +<a href="../components/spreadsheet/use-case.html">Use Case</a> </div> - -<div class="menuItem"> -<a href="guidelines.html">Contribution Guidelines</a> +<div class="menuitem"> +<a href="../components/spreadsheet/diagrams.html">Pictorial Docs</a> </div> - -<div class="menuItem"> -<a href="who.html">Who We Are</a> +<div class="menuitem"> +<a href="../components/spreadsheet/limitations.html">Limitations</a> </div> - +<div class="menuitem"> +<a href="../components/spreadsheet/user-defined-functions.html">User Defined Functions</a> </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 class="menuitem"> +<a href="../components/spreadsheet/excelant.html">ExcelAnt Tests</a> </div> - -<div class="menuItem"> -<a href="slideshow/index.html">PowerPoint (SL=HSLF+XSLF)</a> +<div class="menuitem"> +<a href="../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a> </div> - -<div class="menuItem"> -<a href="document/index.html">Word (WP=HWPF+XWPF)</a> +<div class="menuitem"> +<a href="../components/spreadsheet/record-generator.html">Record Generator</a> </div> - -<div class="menuItem"> -<a href="hsmf/index.html">Outlook (HSMF)</a> +<div class="menuitem"> +<a href="../components/spreadsheet/chart.html">Charts</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 onclick="SwitchMenu('menu_1.3.4', '../skin/')" id="menu_1.3.4Title" class="menutitle">PowerPoint (HSLF/XSLF)</div> +<div id="menu_1.3.4" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/slideshow/index.html">Overview</a> </div> - +<div class="menuitem"> +<a href="../components/slideshow/quick-guide.html">Quick Guide</a> </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 class="menuitem"> +<a href="../components/slideshow/how-to-shapes.html">HSLF Cookbook</a> </div> - -<div class="menuItem"> -<a href="hpsf/index.html">OLE2 Document Props (HPSF)</a> +<div class="menuitem"> +<a href="../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a> </div> - -<div class="menuItem"> -<a href="hmef/index.html">TNEF (HMEF) for winmail.dat</a> +<div class="menuitem"> +<a href="../components/slideshow/ppt-file-format.html">PPT File Format</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 onclick="SwitchMenu('menu_1.3.5', '../skin/')" id="menu_1.3.5Title" class="menutitle">Word (HWPF/XWPF)</div> +<div id="menu_1.3.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/document/index.html">Overview</a> </div> - +<div class="menuitem"> +<a href="../components/document/quick-guide.html">HWPF Quick Guide</a> </div> -<div class="menu"> -<span class="menuLabel">Apache Wide</span> - -<div class="menuItem"> -<a href="https://www.apache.org/";>Apache Software Foundation</a> +<div class="menuitem"> +<a href="../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a> </div> - -<div class="menuItem"> -<a href="https://www.apache.org/licenses/";>License</a> +<div class="menuitem"> +<a href="../components/document/docoverview.html">HWPF Format</a> </div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a> +<div class="menuitem"> +<a href="../components/document/projectplan.html">HWPF Project plan</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 class="menuitem"> +<a href="../components/hsmf/index.html">Outlook (HSMF)</a> </div> - +<div class="menuitem"> +<a href="../components/diagram/index.html">Visio (HDGF+XDGF)</a> </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"> -<h1>JVM languages</h1> +<div onclick="SwitchMenu('menu_1.3.8', '../skin/')" id="menu_1.3.8Title" class="menutitle">Publisher (HPBF)</div> +<div id="menu_1.3.8" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/hpbf/index.html">Overview</a> </div> -<div class="h3"> - - - +<div class="menuitem"> +<a href="../components/hpbf/file-format.html">File Format</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.9', '../skin/')" id="menu_1.3.9Title" class="menutitle">OLE2 Filesystem (POIFS)</div> +<div id="menu_1.3.9" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/poifs/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/embeded.html">Embedded Documents</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/fileformat.html">File System Documentation</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/usecases.html">Use Cases</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/design.html">Design</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.10', '../skin/')" id="menu_1.3.10Title" class="menutitle">OLE2 Document Props (HPSF)</div> +<div id="menu_1.3.10" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/hpsf/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/thumbnails.html">Thumbnails</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/internals.html">Internals</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/todo.html">To Do</a> +</div> +</div> +<div class="menuitem"> +<a href="../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a> +</div> +<div class="menuitem"> +<a href="../components/oxml4j/index.html">OpenXML4J (OOXML)</a> +</div> +<div class="menuitem"> +<a href="../components/logging.html">Logging framework</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Help</div> +<div id="menu_1.4" class="menuitemgroup"> +<div class="menuitem"> +<a href="../help/index.html">Mailing Lists</a> +</div> +<div class="menuitem"> +<a href="../help/faq.html">FAQ</a> +</div> +<div class="menuitem"> +<a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug Database</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.5', '../skin/')" id="menu_1.5Title" class="menutitle">Getting Involved</div> +<div id="menu_1.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/index.html">How To Build</a> +</div> +<div class="menuitem"> +<a href="../devel/subversion.html">Subversion Repository</a> +</div> +<div class="menuitem"> +<a href="../devel/guidelines.html">Contribution Guidelines</a> +</div> +<div class="menuitem"> +<a href="../devel/who.html">Who We Are</a> +</div> +<div onclick="SwitchMenu('menu_1.5.5', '../skin/')" id="menu_1.5.5Title" class="menutitle">Planning Documents</div> +<div id="menu_1.5.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/plan/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../devel/plan/vision10.html">1.0 Vision</a> +</div> +<div class="menuitem"> +<a href="../devel/plan/vision20.html">2.0 Vision</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.5.6', '../skin/')" id="menu_1.5.6Title" class="menutitle">References</div> +<div id="menu_1.5.6" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/references/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../devel/references/logocontest.html">Logo Submissions</a> +</div> +<div class="menuitem"> +<a href="http://sc.openoffice.org/excelfileformat.pdf";>XLS spec [PDF]</a> +</div> +<div class="menuitem"> +<a href="http://xml.apache.org/cocoon/";>Apache Cocoon</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.5.7', '../skin/')" id="menu_1.5.7Title" class="menutitle">Resolutions</div> +<div id="menu_1.5.7" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/resolutions/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../devel/resolutions/res001.html">Minimal Coding Standards</a> +</div> +</div> +<div class="menuitem"> +<a href="../devel/historyandfuture.html">History</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>JVM languages</h1> +<div id="front-matter"></div> <a name="Intro"></a> -<div class="h3"> -<h3>Intro<a title="Permanent link" class="headerlink" href="#Intro">#</a> -</h3> -</div> - +<h2 class="boxed">Intro</h2> +<div class="section"> <p> Apache POI can be used with any <a href="https://en.wikipedia.org/wiki/List_of_JVM_languages";>JVM language</a> that can import Java jar files such as Jython, Groovy, Scala, Kotlin, and JRuby. </p> - <ul> <li> @@ -294,16 +425,13 @@ if (VERSION > 3) { </li> </ul> - +</div> <a name="Tested+Environments"></a> -<div class="h3"> -<h3>Tested Environments<a title="Permanent link" class="headerlink" href="#Tested+Environments">#</a> -</h3> -</div> - +<h2 class="boxed">Tested Environments</h2> +<div class="section"> <ul> <li> @@ -319,28 +447,19 @@ if (VERSION > 3) { <a href="http://clojure.org/";>Clojure</a> 1.5.1+</li> </ul> - <p>If you use POI in a different language (Kotlin, JRuby, ...) and would like to share a <em>Hello POI!</em> example, please <a href="https://helpwanted.apache.org/task.html?856abd21";>share</a> it.</p> - -<p>Please <a href="mailinglists.html">let us know</a> if you use POI in an environment not listed here</p> - +<p>Please <a href="../help/index.html">let us know</a> if you use POI in an environment not listed here</p> +</div> - + <!-- FIXME: Need to make each language section expandable/collapseable so that users can compare their language to Java on one screen. See http://jsfiddle.net/eJX8z/ for an example implementation. --> <a name="Java+code"></a> -<div class="h3"> -<h3>Java code<a title="Permanent link" class="headerlink" href="#Java+code">#</a> -</h3> -</div> - +<h2 class="boxed">Java code</h2> +<div class="section"> <a name="POILanguageExample.java"></a> -<div class="h4"> -<h4>POILanguageExample.java<a title="Permanent link" class="headerlink" href="#POILanguageExample.java">#</a> -</h4> -</div> - -<pre class="code"> +<h3 class="boxed">POILanguageExample.java</h3> +<pre class="code"> <!-- lang="java" --> // include poi-{version}-{yyyymmdd}.jar, poi-ooxml-{version}-{yyyymmdd}.jar, // and poi-ooxml-schemas-{version}-{yyyymmdd}.jar on Java classpath @@ -383,18 +502,14 @@ if (VERSION > 3) { wb.write(fos); fos.close(); </pre> - - +</div> <!-- Java code --> <a name="Jython+example"></a> -<div class="h3"> -<h3>Jython example<a title="Permanent link" class="headerlink" href="#Jython+example">#</a> -</h3> -</div> - -<pre class="code"> - # Add <a href="overview.html#components">poi jars</a> onto the python classpath or add them at run time +<h2 class="boxed">Jython example</h2> +<div class="section"> +<pre class="code"> <!-- lang="python" --> + # Add <a href="../components/">poi jars</a> onto the python classpath or add them at run time import sys for jar in ('poi', 'poi-ooxml', 'poi-ooxml-schemas'): sys.path.append('/path/to/%s-3.14-20160307.jar') @@ -403,7 +518,7 @@ if (VERSION > 3) { from contextlib import closing # Import the POI classes - from org.apache.poi.ss.usermodel import <a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/WorkbookFactory.html";>WorkbookFactory</a>, <a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html";>DataFormatter</a> + from org.apache.poi.ss.usermodel import <a href="../apidocs/org/apache/poi/ss/usermodel/WorkbookFactory.html">WorkbookFactory</a>, <a href="../apidocs/org/apache/poi/ss/usermodel/DataFormatter.html">DataFormatter</a> # Read the contents of the workbook wb = WorkbookFactory.create(File('<a href="https://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/SampleSS.xlsx";>SampleSS.xlsx</a>')) @@ -427,27 +542,19 @@ if (VERSION > 3) { wb.write(fos) wb.close() </pre> - <p>There are several websites that have examples of using Apache POI in Jython projects: <a href="https://wiki.python.org/jython/PoiExample";>python.org</a>, <a href="http://www.jython.org/jythonbook/en/1.0/appendixB.html#working-with-spreadsheets";>jython.org</a>, and many others. </p> - +</div> <a name="Scala+example"></a> -<div class="h3"> -<h3>Scala example<a title="Permanent link" class="headerlink" href="#Scala+example">#</a> -</h3> -</div> - +<h2 class="boxed">Scala example</h2> +<div class="section"> <a name="build.sbt"></a> -<div class="h4"> -<h4>build.sbt<a title="Permanent link" class="headerlink" href="#build.sbt">#</a> -</h4> -</div> - -<pre class="code"> +<h3 class="boxed">build.sbt</h3> +<pre class="code"> <!-- lang="scala" --> // Add the POI core and OOXML support dependencies into your build.sbt libraryDependencies ++= Seq( "org.apache.poi" % "poi" % "3.15-beta2", @@ -455,17 +562,11 @@ if (VERSION > 3) { "org.apache.poi" % "poi-ooxml-schemas" "3.15-beta2" ) </pre> - - <a name="XSSFMain.scala"></a> -<div class="h4"> -<h4>XSSFMain.scala<a title="Permanent link" class="headerlink" href="#XSSFMain.scala">#</a> -</h4> -</div> - -<pre class="code"> +<h3 class="boxed">XSSFMain.scala</h3> +<pre class="code"> <!-- lang="scala" --> // Import the required classes - import org.apache.poi.ss.usermodel.{<a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/WorkbookFactory.html";>WorkbookFactory</a>, <a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html";>DataFormatter</a>} + import org.apache.poi.ss.usermodel.{<a href="../apidocs/org/apache/poi/ss/usermodel/WorkbookFactory.html">WorkbookFactory</a>, <a href="../apidocs/org/apache/poi/ss/usermodel/DataFormatter.html">DataFormatter</a>} import java.io.{File, FileOutputStream} object XSSFMain extends App { @@ -504,23 +605,15 @@ if (VERSION > 3) { workbook.close() } </pre> - - +</div> <a name="Groovy+example"></a> -<div class="h3"> -<h3>Groovy example<a title="Permanent link" class="headerlink" href="#Groovy+example">#</a> -</h3> -</div> - +<h2 class="boxed">Groovy example</h2> +<div class="section"> <a name="build.gradle"></a> -<div class="h4"> -<h4>build.gradle<a title="Permanent link" class="headerlink" href="#build.gradle">#</a> -</h4> -</div> - -<pre class="code"> +<h3 class="boxed">build.gradle</h3> +<pre class="code"> <!-- lang="groovy" --> // Add the POI core and OOXML support dependencies into your gradle build, // along with all of Groovy so it can run as a standalone script repositories { @@ -532,15 +625,9 @@ dependencies { runtime 'org.apache.poi:poi-ooxml:3.14' } </pre> - - <a name="SpreadSheetDemo.groovy"></a> -<div class="h4"> -<h4>SpreadSheetDemo.groovy<a title="Permanent link" class="headerlink" href="#SpreadSheetDemo.groovy">#</a> -</h4> -</div> - -<pre class="code"> +<h3 class="boxed">SpreadSheetDemo.groovy</h3> +<pre class="code"> <!-- lang="groovy" --> import org.apache.poi.ss.usermodel.* import org.apache.poi.ss.util.* import java.io.File @@ -633,24 +720,15 @@ void exportHeader(Sheet s, CellStyle hea s.setAutoFilter(new CellRangeAddress(rn, rn, 0, headers.length-1)) } </pre> - - +</div> <a name="Clojure+example"></a> -<div class="h3"> -<h3>Clojure example<a title="Permanent link" class="headerlink" href="#Clojure+example">#</a> -</h3> -</div> - +<h2 class="boxed">Clojure example</h2> +<div class="section"> <a name="SpreadSheetDemo.clj"></a> -<div class="h4"> -<h4>SpreadSheetDemo.clj<a title="Permanent link" class="headerlink" href="#SpreadSheetDemo.clj">#</a> -</h4> -</div> - - -<pre class="code"> +<h3 class="boxed">SpreadSheetDemo.clj</h3> +<pre class="code"> <!-- lang="clojure" --> (ns poi.core (:gen-class) (:use [clojure.java.io :only [input-stream]]) @@ -671,52 +749,37 @@ void exportHeader(Sheet s, CellStyle hea (let [wb (WorkbookFactory/create (input-stream name))] (print-all wb)))) </pre> - - - - - -<div id="authors" align="right">by Javen O'Neal</div> -</div> </div> + +<p align="right"> +<font size="-2">by Javen O'Neal</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="feedback"> + Send feedback about the website to: + <a id="feedbackto" href="mailto:[email protected]?subject=Feedback%C2%A0components/poi-jvm-languages.html";>[email protected]</a> +</div> +<!--+ + |end bottomstrip + +--> </div> -<!--================= end Footer ==================--> </body> </html> Copied: poi/site/publish/components/poi-ruby.html (from r1836243, poi/site/publish/poi-ruby.html) URL: http://svn.apache.org/viewvc/poi/site/publish/components/poi-ruby.html?p2=poi/site/publish/components/poi-ruby.html&p1=poi/site/publish/poi-ruby.html&r1=1836243&r2=1836244&rev=1836244&view=diff ============================================================================== --- poi/site/publish/poi-ruby.html (original) +++ poi/site/publish/components/poi-ruby.html Wed Jul 18 23:27:21 2018 @@ -1,348 +1,453 @@ -<!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>POI Ruby Bindings</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> +<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> +<!--+ + |end search + +--> +<!--+ + |start Tabs + +--> +<ul id="tabs"> +<li> +<a class="unselected" href="../index.html">Home</a> +</li> +<li> +<a class="unselected" 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_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Overview</div> +<div id="menu_1.1" class="menuitemgroup"> +<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="../changes.html">Changelog</a> +</div> +<div class="menuitem"> +<a href="../apidocs/index.html">Javadocs</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 onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Apache Wide</div> +<div id="menu_1.2" class="menuitemgroup"> +<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> +<div onclick="SwitchMenu('menu_1.3', '../skin/')" id="menu_1.3Title" class="menutitle">Component APIs</div> +<div id="menu_1.3" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../apidocs/index.html">Javadocs</a> +</div> +<div onclick="SwitchMenu('menu_1.3.3', '../skin/')" id="menu_1.3.3Title" class="menutitle">Excel (HSSF/XSSF)</div> +<div id="menu_1.3.3" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/spreadsheet/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/quick-guide.html">Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/how-to.html">HOWTO</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/converting.html">HSSF to SS Converting</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/formula.html">Formula Support</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/eval.html">Formula Evaluation</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/eval-devguide.html">Eval Dev Guide</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/examples.html">Examples</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/use-case.html">Use Case</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/diagrams.html">Pictorial Docs</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/limitations.html">Limitations</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/user-defined-functions.html">User Defined Functions</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/excelant.html">ExcelAnt Tests</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/record-generator.html">Record Generator</a> +</div> +<div class="menuitem"> +<a href="../components/spreadsheet/chart.html">Charts</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.4', '../skin/')" id="menu_1.3.4Title" class="menutitle">PowerPoint (HSLF/XSLF)</div> +<div id="menu_1.3.4" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/slideshow/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/slideshow/quick-guide.html">Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../components/slideshow/how-to-shapes.html">HSLF Cookbook</a> +</div> +<div class="menuitem"> +<a href="../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a> +</div> +<div class="menuitem"> +<a href="../components/slideshow/ppt-file-format.html">PPT File Format</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.5', '../skin/')" id="menu_1.3.5Title" class="menutitle">Word (HWPF/XWPF)</div> +<div id="menu_1.3.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/document/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/document/quick-guide.html">HWPF Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a> +</div> +<div class="menuitem"> +<a href="../components/document/docoverview.html">HWPF Format</a> +</div> +<div class="menuitem"> +<a href="../components/document/projectplan.html">HWPF Project plan</a> +</div> +</div> +<div class="menuitem"> +<a href="../components/hsmf/index.html">Outlook (HSMF)</a> +</div> +<div class="menuitem"> +<a href="../components/diagram/index.html">Visio (HDGF+XDGF)</a> +</div> +<div onclick="SwitchMenu('menu_1.3.8', '../skin/')" id="menu_1.3.8Title" class="menutitle">Publisher (HPBF)</div> +<div id="menu_1.3.8" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/hpbf/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/hpbf/file-format.html">File Format</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.9', '../skin/')" id="menu_1.3.9Title" class="menutitle">OLE2 Filesystem (POIFS)</div> +<div id="menu_1.3.9" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/poifs/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/embeded.html">Embedded Documents</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/fileformat.html">File System Documentation</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/usecases.html">Use Cases</a> +</div> +<div class="menuitem"> +<a href="../components/poifs/design.html">Design</a> +</div> +</div> +<div onclick="SwitchMenu('menu_1.3.10', '../skin/')" id="menu_1.3.10Title" class="menutitle">OLE2 Document Props (HPSF)</div> +<div id="menu_1.3.10" class="menuitemgroup"> +<div class="menuitem"> +<a href="../components/hpsf/index.html">Overview</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/how-to.html">How To</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/thumbnails.html">Thumbnails</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/internals.html">Internals</a> +</div> +<div class="menuitem"> +<a href="../components/hpsf/todo.html">To Do</a> +</div> +</div> +<div class="menuitem"> +<a href="../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a> +</div> +<div class="menuitem"> +<a href="../components/oxml4j/index.html">OpenXML4J (OOXML)</a> +</div> +<div class="menuitem"> +<a href="../components/logging.html">Logging framework</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"> -<a href="faq.html">FAQ</a> -</div> - -<div class="menuItem"> -<a href="mailinglists.html">Mailing Lists</a> +<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Help</div> +<div id="menu_1.4" class="menuitemgroup"> +<div class="menuitem"> +<a href="../help/index.html">Mailing Lists</a> </div> - -<div class="menuItem"> +<div class="menuitem"> +<a href="../help/faq.html">FAQ</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 onclick="SwitchMenu('menu_1.5', '../skin/')" id="menu_1.5Title" class="menutitle">Getting Involved</div> +<div id="menu_1.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/index.html">How To Build</a> </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 class="menuitem"> +<a href="../devel/subversion.html">Subversion Repository</a> </div> - +<div class="menuitem"> +<a href="../devel/guidelines.html">Contribution Guidelines</a> </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 class="menuitem"> +<a href="../devel/who.html">Who We Are</a> </div> - +<div onclick="SwitchMenu('menu_1.5.5', '../skin/')" id="menu_1.5.5Title" class="menutitle">Planning Documents</div> +<div id="menu_1.5.5" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/plan/index.html">Overview</a> </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 class="menuitem"> +<a href="../devel/plan/vision10.html">1.0 Vision</a> </div> - +<div class="menuitem"> +<a href="../devel/plan/vision20.html">2.0 Vision</a> </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 onclick="SwitchMenu('menu_1.5.6', '../skin/')" id="menu_1.5.6Title" class="menutitle">References</div> +<div id="menu_1.5.6" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/references/index.html">Overview</a> </div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a> +<div class="menuitem"> +<a href="../devel/references/logocontest.html">Logo Submissions</a> </div> - -<div class="menuItem"> -<a href="https://www.apache.org/foundation/thanks.html";>Thanks</a> +<div class="menuitem"> +<a href="http://sc.openoffice.org/excelfileformat.pdf";>XLS spec [PDF]</a> </div> - -<div class="menuItem"> -<a href="https://www.apache.org/security/";>Security</a> +<div class="menuitem"> +<a href="http://xml.apache.org/cocoon/";>Apache Cocoon</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"> -<h1>POI Ruby Bindings</h1> +<div onclick="SwitchMenu('menu_1.5.7', '../skin/')" id="menu_1.5.7Title" class="menutitle">Resolutions</div> +<div id="menu_1.5.7" class="menuitemgroup"> +<div class="menuitem"> +<a href="../devel/resolutions/index.html">Overview</a> </div> -<div class="h3"> - - - +<div class="menuitem"> +<a href="../devel/resolutions/res001.html">Minimal Coding Standards</a> +</div> +</div> +<div class="menuitem"> +<a href="../devel/historyandfuture.html">History</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>POI Ruby Bindings</h1> +<div id="front-matter"></div> <a name="Intro"></a> -<div class="h3"> -<h3>Intro<a title="Permanent link" class="headerlink" href="#Intro">#</a> -</h3> -</div> - +<h2 class="boxed">Intro</h2> +<div class="section"> <p>The POI library can now be compiled as a Ruby extension, allowing the API to be called from Ruby language programs. Ruby users can therefore read and write OLE2 documents, such as Excel files with ease </p> - <p>The bindings are generated by compiling POI with <a href="https://gcc.gnu.org/java/";>gcj</a>, and generating the Ruby wrapper using <a href="http://www.swig.org";>SWIG</a>. The aim is the keep the POI api as-is. However, where java standard library objects are used, an effort is made to transform them smoothly into Ruby objects. Therefore, where the POI API takes an OutputStream, you can pass an IO object. Where the POI works java.util.Date or java.util.Calendar object, you can work with a Ruby Time object. </p> - +</div> <a name="Getting+Started"></a> -<div class="h3"> -<h3>Getting Started<a title="Permanent link" class="headerlink" href="#Getting+Started">#</a> -</h3> -</div> - +<h2 class="boxed">Getting Started</h2> +<div class="section"> <a name="Pre-Requisites"></a> -<div class="h4"> -<h4>Pre-Requisites<a title="Permanent link" class="headerlink" href="#Pre-Requisites">#</a> -</h4> -</div> - +<h3 class="boxed">Pre-Requisites</h3> <p>The bindings have been developed with GCC 3.4.3 and Ruby 1.8.2. You are unlikely to get correct results with versions of GCC prior to 3.4 or versions of Ruby prior to 1.8. To compile the Ruby extension, you must have GCC (compiled with java language support), Ruby development headers, and SWIG. To run, you will need Ruby (obviously!) and <em>libgcj </em>, presumably from the same version of GCC with which you compiled. </p> - - <a name="Subversion"></a> -<div class="h4"> -<h4>Subversion<a title="Permanent link" class="headerlink" href="#Subversion">#</a> -</h4> -</div> - +<h3 class="boxed">Subversion</h3> <p> The POI-Ruby module sits under the POI <a href="https://svn.apache.org/repos/asf/poi/trunk/src/contrib/poi-ruby/";>Subversion</a> <a href="https://svn.apache.org/viewvc/poi/trunk/src/contrib/poi-ruby/";>(viewvc)</a>. Running <em>make</em> inside that directory will create a loadable ruby extension <em>poi4r.so</em> in the release subdirectory. Tests are in the <em>tests/</em> subdirectory, and should be run from the <em>poi-ruby</em> directory. Please read the tests to figure out the usage. </p> - <p>Note that the makefile, though designed to work across Linux/OS X/Cygwin, has been tested only on linux. There are likely to be issues on other platform; fixes gratefully accepted! </p> - - <a name="Binary"></a> -<div class="h4"> -<h4>Binary<a title="Permanent link" class="headerlink" href="#Binary">#</a> -</h4> -</div> - +<h3 class="boxed">Binary</h3> <p>A version of poi4r.so is available <a href="https://www.apache.org/~avik/dist/poi4r.so";>here</a> (broken link). Its been compiled on a linux box with GCC 3.4.3 and Ruby 1.8.2. It dynamically links to libgcj. No guarantees about working on any other box. </p> - - +</div> <a name="Usage"></a> -<div class="h3"> -<h3>Usage<a title="Permanent link" class="headerlink" href="#Usage">#</a> -</h3> -</div> - - +<h2 class="boxed">Usage</h2> +<div class="section"> <p>The following ruby code shows some of the things you can do with POI in Ruby</p> - <pre class="code"> h=Poi4r::HSSFWorkbook.new #Test Sheet Creation @@ -382,28 +487,19 @@ if (VERSION > 3) { #Writing h.write(File.new("test.xls","w")) </pre> - <p> The <em>tc_base_tests.rb</em> file in the <em>tests</em> sub directory of the source distribution contains examples of simple uses of the API. The <a href="spreadsheet/quick-guide.html">quick guide </a> is the best place to learn HSSF API use. (Note however that none of the Drawing features are implemented in the Ruby binding.) - See also the <a href="apidocs/overview-summary.html">POI API documentation</a> for more details. + See also the <a href="../apidocs/overview-summary.html">POI API documentation</a> for more details. </p> - +</div> <a name="Future+Directions"></a> -<div class="h3"> -<h3>Future Directions<a title="Permanent link" class="headerlink" href="#Future+Directions">#</a> -</h3> -</div> - - +<h2 class="boxed">Future Directions</h2> +<div class="section"> <a name="TODO%27s"></a> -<div class="h4"> -<h4>TODO's<a title="Permanent link" class="headerlink" href="#TODO%27s">#</a> -</h4> -</div> - +<h3 class="boxed">TODO's</h3> <ul> <li>Implement support for reading Excel files (easy)</li> @@ -415,14 +511,8 @@ if (VERSION > 3) { <li>Tests... Tests... Tests...</li> </ul> - - <a name="Limitations"></a> -<div class="h4"> -<h4>Limitations<a title="Permanent link" class="headerlink" href="#Limitations">#</a> -</h4> -</div> - +<h3 class="boxed">Limitations</h3> <ul> <li>Check operations in 64bit machines - Java primitive types are fixed irrespective of machine type, unlike C/C++ types. The wrapping code @@ -435,54 +525,38 @@ if (VERSION > 3) { packaged as a <a href="http://www.rubygems.org";>gem</a>.</li> </ul> - - - +</div> - - -<div id="authors" align="right">by Avik Sengupta</div> +<p align="right"> +<font size="-2">by Avik Sengupta</font> +</p> +</div> +<!--+ + |end content + +--> +<div class="clearboth"> </div> </div> -</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="feedback"> + Send feedback about the website to: + <a id="feedbackto" href="mailto:[email protected]?subject=Feedback%C2%A0components/poi-ruby.html";>[email protected]</a> +</div> +<!--+ + |end bottomstrip + +--> </div> -<!--================= end Footer ==================--> </body> </html> --------------------------------------------------------------------- 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}