Author: nick
Date: Thu Aug 14 14:13:27 2014
New Revision: 1617952
URL: http://svn.apache.org/r1617952
Log:
List the rest of the examples
Modified:
poi/site/publish/spreadsheet/examples.html
poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml
Modified: poi/site/publish/spreadsheet/examples.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/examples.html?rev=1617952&r1=1617951&r2=1617952&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/examples.html (original)
+++ poi/site/publish/spreadsheet/examples.html Thu Aug 14 14:13:27 2014
@@ -180,9 +180,9 @@ if (VERSION > 3) {
<h1>HSSF and XSSF Examples</h1>
</div>
<div class="h3">
+
+
-
-
<a name="HSSF+and+XSSF+common+examples"></a>
<div class="h3">
<h3>HSSF and XSSF common examples</h3>
@@ -394,35 +394,412 @@ if (VERSION > 3) {
<h4>ToCSV</h4>
</div>
-<p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a>
+<p>The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a>
example demonstrates <em>one</em> way to convert an Excel spreadsheet
into a CSV file.
</p>
-
-
+
+
+
+<a name="common-formulas"></a>
+ <a name="Formula+Examples"></a>
+<div class="h4">
+<h4>Formula Examples</h4>
+</div>
+
+<p>
+<em>TODO</em>
+</p>
+
+
+
+<a name="add-dimensioned-image"></a>
+ <a name="Add+Dimensioned+Image"></a>
+<div class="h4">
+<h4>Add Dimensioned Image</h4>
+</div>
+
+<p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java";>AddDimensionedImage</a>
+ example demonstrates how to add an image to a worksheet and set that
+ images size to a specific number of millimetres irrespective of the
+ width of the columns or height of the rows.</p>
+
+
+
+<a name="aligned-cells"></a>
+ <a name="Aligned+Cells"></a>
+<div class="h4">
+<h4>Aligned Cells</h4>
+</div>
+
+<p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AligningCells.java";>AligningCells</a>
+ example demonstrates how various alignment options work.</p>
+
+
+
+<a name="cell-style-details"></a>
+ <a name="Cell+Style+Details"></a>
+<div class="h4">
+<h4>Cell Style Details</h4>
+</div>
+
+<p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java";>CellStyleDetails</a>
+ example demonstrates how to read excel styles for cells.</p>
+
+<a name="linked-dropdown"></a>
+ <a name="Linked+Dropdown+Lists"></a>
+<div class="h4">
+<h4>Linked Dropdown Lists</h4>
+</div>
+
+<p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java";>LinkedDropDownLists</a>
+ example demonstrates one technique that may be used to create linked
+ or dependent drop down lists.</p>
+
+
+
+<a name="performance-test"></a>
+ <a name="Common+SS+Performance+Test"></a>
+<div class="h4">
+<h4>Common SS Performance Test</h4>
+</div>
+
+<p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</a>
+ example provides a way to create simple example files of varying
+ sizes, and to calculate how long they take. Useful for benchmarking
+ your system, and to also test if slow performance is due to Apache
+ POI itself or to your own code.</p>
+
+
+
+
<a name="hssf-only"></a>
- <a name="HSSF-only+Examples"></a>
+ <a name="HSSF-only+Examples"></a>
<div class="h3">
<h3>HSSF-only Examples</h3>
</div>
-
+
<p>All the HSSF-only examples can be found in
- <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</a>
+ <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</a>
</p>
-
-
+<ul>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellComments.java";>CellComments</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HyperlinkFormula.java";>HyperlinkFormula</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EventExample.java";>EventExample</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawingWithGraphics.java";>OfficeDrawingWithGraphics</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateDateCells.java";>CreateDateCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewWorkbook.java";>NewWorkbook</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmeddedObjects.java";>EmeddedObjects</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Hyperlinks.java";>Hyperlinks</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawing.java";>OfficeDrawing</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>HSSFReadWrite</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewSheet.java";>NewSheet</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/InCellLists.java";>InCellLists</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/RepeatingRowsAndColumns.java";>RepeatingRowsAndColumns</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/MergedCells.java";>MergedCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellTypes.java";>CellTypes</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ZoomSheet.java";>ZoomSheet</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ReadWriteWorkbook.java";>ReadWriteWorkbook</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateCells.java";>CreateCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Alignment.java";>Alignment</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/FrillsAndFills.java";>FrillsAndFills</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/AddDimensionedImage.java";>AddDimensionedImage</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Borders.java";>Borders</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/BigExample.java";>BigExample</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Outlines.java";>Outlines</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java";>XLS2CSVmra</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewer.java";>SViewer</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVFractionalFormat.java";>SVFractionalFormat</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellEditor.java";>SVTableCellEditor</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVBorder.java";>SVBorder</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/DoubleStroke.java";>DoubleStroke</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/BasicBrush.java";>BasicBrush</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/Brush.java";>Brush</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/PendingPaintings.java";>PendingPaintings</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellRenderer.java";>SVTableCellRenderer</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewerPanel.java";>SViewerPanel</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableUtils.java";>SVTableUtils</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableModel.java";>SVTableModel</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVSheetTable.java";>SVSheetTable</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVRowHeader.java";>SVRowHeader</a>
+</li>
+
+</ul>
+
+
+
<a name="xssf-only"></a>
- <a name="XSSF-only+Examples"></a>
+ <a name="XSSF-only+Examples"></a>
<div class="h3">
<h3>XSSF-only Examples</h3>
</div>
-
+
<p>All the XSSF-only examples can be found in
- <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</a>
+ <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</a>
</p>
-
+
+<ul>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java";>ScatterChart</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CellComments.java";>CellComments</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HeadersAndFooters.java";>HeadersAndFooters</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateUserDefinedDataFormats.java";>CreateUserDefinedDataFormats</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java";>CreatePivotTable</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FillsAndColors.java";>FillsAndColors</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithBorders.java";>WorkingWithBorders</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java";>BigGridDemo</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java";>CreateTable</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CalendarDemo.java";>CalendarDemo</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/AligningCells.java";>AligningCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPageSetup.java";>WorkingWithPageSetup</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java";>WorkingWithPictures</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/MergingCells.java";>MergingCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java";>CustomXMLMapping</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SelectedSheet.java";>SelectedSheet</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/EmbeddedObjects.java";>EmbeddedObjects</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkbookProperties.java";>WorkbookProperties</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/Outlining.java";>Outlining</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateCell.java";>CreateCell</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java";>IterateCells</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LineChart.java";>LineChart</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HyperlinkExample.java";>HyperlinkExample</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ShiftRows.java";>ShiftRows</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithRichText.java";>WorkingWithRichText</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FitSheetToOnePage.java";>FitSheetToOnePage</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/Outlining.java";>Outlining</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>XLSX2CSV</a>
+</li>
+
+<li>
+<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>FromHowTo</a>
+</li>
+
+</ul>
+
<div id="authors" align="right">by Yegor Kozlov</div>
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml?rev=1617952&r1=1617951&r2=1617952&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml Thu Aug
14 14:13:27 2014
@@ -20,14 +20,14 @@
<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN"
"../dtd/document-v13.dtd">
<document>
- <header>
- <title>HSSF and XSSF Examples</title>
- <authors>
- <person id="YK" name="Yegor Kozlov" email="[email protected]"/>
- </authors>
- </header>
- <body>
- <section><title>HSSF and XSSF common examples</title>
+ <header>
+ <title>HSSF and XSSF Examples</title>
+ <authors>
+ <person id="YK" name="Yegor Kozlov" email="[email protected]"/>
+ </authors>
+ </header>
+ <body>
+ <section><title>HSSF and XSSF common examples</title>
<p>Apach POI comes with a number of examples that demonstrate how you
can use the POI API to create documents from "real life".
The examples below based on common XSSF-HSSF interfaces so that you
@@ -134,22 +134,141 @@
<anchor id="to-csv" />
<section><title>ToCSV</title>
- <p> The <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</link>
+ <p>The <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</link>
example demonstrates <em>one</em> way to convert an Excel spreadsheet
into a CSV file.
</p>
- </section>
- </section>
+ </section>
- <anchor id="hssf-only" />
- <section><title>HSSF-only Examples</title>
- <p>All the HSSF-only examples can be found in
- <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</link></p>
- </section>
+ <anchor id="common-formulas" />
+ <section><title>Formula Examples</title>
+ <p><em>TODO</em></p>
+ </section>
+
+ <anchor id="add-dimensioned-image" />
+ <section><title>Add Dimensioned Image</title>
+ <p>The <link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java";>AddDimensionedImage</link>
+ example demonstrates how to add an image to a worksheet and set that
+ images size to a specific number of millimetres irrespective of the
+ width of the columns or height of the rows.</p>
+ </section>
+
+ <anchor id="aligned-cells" />
+ <section><title>Aligned Cells</title>
+ <p>The <link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AligningCells.java";>AligningCells</link>
+ example demonstrates how various alignment options work.</p>
+ </section>
+
+ <anchor id="cell-style-details" />
+ <section><title>Cell Style Details</title>
+ <p>The <link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java";>CellStyleDetails</link>
+ example demonstrates how to read excel styles for cells.</p>
+ </section>
+
+ <anchor id="linked-dropdown" />
+ <section><title>Linked Dropdown Lists</title>
+ <p>The <link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java";>LinkedDropDownLists</link>
+ example demonstrates one technique that may be used to create linked
+ or dependent drop down lists.</p>
+ </section>
+
+ <anchor id="performance-test" />
+ <section><title>Common SS Performance Test</title>
+ <p>The <link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</link>
+ example provides a way to create simple example files of varying
+ sizes, and to calculate how long they take. Useful for benchmarking
+ your system, and to also test if slow performance is due to Apache
+ POI itself or to your own code.</p>
+ </section>
+ </section>
+
+ <anchor id="hssf-only" />
+ <section><title>HSSF-only Examples</title>
+ <p>All the HSSF-only examples can be found in
+ <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</link></p>
+ <ul>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellComments.java";>CellComments</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HyperlinkFormula.java";>HyperlinkFormula</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EventExample.java";>EventExample</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawingWithGraphics.java";>OfficeDrawingWithGraphics</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateDateCells.java";>CreateDateCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewWorkbook.java";>NewWorkbook</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmeddedObjects.java";>EmeddedObjects</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Hyperlinks.java";>Hyperlinks</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawing.java";>OfficeDrawing</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>HSSFReadWrite</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewSheet.java";>NewSheet</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/InCellLists.java";>InCellLists</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/RepeatingRowsAndColumns.java";>RepeatingRowsAndColumns</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/MergedCells.java";>MergedCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellTypes.java";>CellTypes</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ZoomSheet.java";>ZoomSheet</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ReadWriteWorkbook.java";>ReadWriteWorkbook</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateCells.java";>CreateCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Alignment.java";>Alignment</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/FrillsAndFills.java";>FrillsAndFills</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/AddDimensionedImage.java";>AddDimensionedImage</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Borders.java";>Borders</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/BigExample.java";>BigExample</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Outlines.java";>Outlines</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java";>XLS2CSVmra</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewer.java";>SViewer</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVFractionalFormat.java";>SVFractionalFormat</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellEditor.java";>SVTableCellEditor</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVBorder.java";>SVBorder</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/DoubleStroke.java";>DoubleStroke</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/BasicBrush.java";>BasicBrush</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/Brush.java";>Brush</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/PendingPaintings.java";>PendingPaintings</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellRenderer.java";>SVTableCellRenderer</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewerPanel.java";>SViewerPanel</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableUtils.java";>SVTableUtils</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableModel.java";>SVTableModel</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVSheetTable.java";>SVSheetTable</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVRowHeader.java";>SVRowHeader</link></li>
+ </ul>
+ </section>
- <anchor id="xssf-only" />
- <section><title>XSSF-only Examples</title>
- <p>All the XSSF-only examples can be found in
- <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</link></p>
- </section>
+ <anchor id="xssf-only" />
+ <section><title>XSSF-only Examples</title>
+ <p>All the XSSF-only examples can be found in
+ <link
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</link></p>
+ <ul>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java";>ScatterChart</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CellComments.java";>CellComments</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HeadersAndFooters.java";>HeadersAndFooters</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateUserDefinedDataFormats.java";>CreateUserDefinedDataFormats</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java";>CreatePivotTable</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FillsAndColors.java";>FillsAndColors</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithBorders.java";>WorkingWithBorders</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java";>BigGridDemo</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java";>CreateTable</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CalendarDemo.java";>CalendarDemo</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/AligningCells.java";>AligningCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPageSetup.java";>WorkingWithPageSetup</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java";>WorkingWithPictures</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/MergingCells.java";>MergingCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java";>CustomXMLMapping</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SelectedSheet.java";>SelectedSheet</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/EmbeddedObjects.java";>EmbeddedObjects</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkbookProperties.java";>WorkbookProperties</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/Outlining.java";>Outlining</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateCell.java";>CreateCell</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java";>IterateCells</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LineChart.java";>LineChart</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HyperlinkExample.java";>HyperlinkExample</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ShiftRows.java";>ShiftRows</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithRichText.java";>WorkingWithRichText</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FitSheetToOnePage.java";>FitSheetToOnePage</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/Outlining.java";>Outlining</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>XLSX2CSV</link></li>
+ <li><link
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>FromHowTo</link></li>
+ </ul>
+ </section>
</body>
</document>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
