Seam SVN: r8639 - trunk/doc/Seam_Reference_Guide/en-US.
by seam-commits＠lists.jboss.org
Author: danielc.roth
Date: 2008-08-08 10:32:12 -0400 (Fri, 08 Aug 2008)
New Revision: 8639
Modified:
trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
Log:
Updating excel docs to reflect recent changes.
Modified: trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
===================================================================
--- trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 14:10:57 UTC (rev 8638)
+++ trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 14:32:12 UTC (rev 8639)
@@ -41,10 +41,20 @@
<para>
Customizing the module to support other kinds of &excel; spreadsheet
API's has been made very easy. Implement the <literal>ExcelWorkbook
- </literal> interface, set the component name to
- <literal>org.jboss.seam.excel.<myModule></literal> and set the
- UIWorkbook type to <literal>myModule</literal> and your own exporter
- will be used. Default is "jxl", but support for CSV has also been
+ </literal> interface, and register in components.xml.
+ <programlisting role="XML">
+ <![CDATA[
+ <excel:excelFactory>
+ <property name="implementations">
+ <key>myExcelExporter</key>
+ <value>my.excel.exporter.ExcelExport</value>
+ </property>
+ </excel:excelFactory>
+ ]]>
+ </programlisting>
+
+ Then set the UIWorkbook type to <literal>myExcelExporter</literal> and your
+ own exporter will be used. Default is "jxl", but support for CSV has also been
added, using the type "csv".
</para>
@@ -2899,9 +2909,9 @@
</para>
<programlisting role="XML">
<![CDATA[
- <h:commandLink
+ <h:commandLink
value="Export"
- action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}"
+ action="#{excelExporter.export('theForm:theDataTable')}"
/>
]]>
</programlisting>
15 years, 9 months
- 1
- 0
Seam SVN: r8638 - in trunk: examples/excel/view and 1 other directories.
by seam-commits＠lists.jboss.org
Author: danielc.roth
Date: 2008-08-08 10:10:57 -0400 (Fri, 08 Aug 2008)
New Revision: 8638
Added:
trunk/src/excel/META-INF/components.xml
Modified:
trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java
trunk/examples/excel/view/home.xhtml
Log:
JBSEAM-3240
Modified: trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java
===================================================================
--- trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java 2008-08-08 13:53:45 UTC (rev 8637)
+++ trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java 2008-08-08 14:10:57 UTC (rev 8638)
@@ -21,7 +21,7 @@
List<Person> ret = new LinkedList<Person>();
for (int i = 0; i < 10; i++)
{
- ret.add(new Person(i, "Janne_" + i, "Andersson" + i));
+ ret.add(new Person(i, "Janne" , "Andersson " + i));
}
return ret;
Modified: trunk/examples/excel/view/home.xhtml
===================================================================
--- trunk/examples/excel/view/home.xhtml 2008-08-08 13:53:45 UTC (rev 8637)
+++ trunk/examples/excel/view/home.xhtml 2008-08-08 14:10:57 UTC (rev 8638)
@@ -42,7 +42,7 @@
<h:outputText value="#{person.age}"></h:outputText>
</rich:column>
</rich:dataTable>
- <h:commandLink value="Export table" action="#{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:excelTable')}" />
+ <h:commandLink value="Export table" action="#{excelExporter.export('excelExport:excelTable')}" />
</a4j:outputPanel>
</h:form>
Added: trunk/src/excel/META-INF/components.xml
===================================================================
--- trunk/src/excel/META-INF/components.xml (rev 0)
+++ trunk/src/excel/META-INF/components.xml 2008-08-08 14:10:57 UTC (rev 8638)
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<components xmlns="http://jboss.com/products/seam/components" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://jboss.com/products/seam/components http://jboss.com/products/seam/components-2.1.xsd">
+
+ <import>org.jboss.seam.excel</import>
+
+ <factory name="excelExporter" auto-create="true" scope="stateless" value="#{org.jboss.seam.excel.exporter.excelExporter}" />
+
+</components>
15 years, 9 months
- 1
- 0
Seam SVN: r8637 - in trunk: examples/excel/view and 4 other directories.
by seam-commits＠lists.jboss.org
Author: danielc.roth
Date: 2008-08-08 09:53:45 -0400 (Fri, 08 Aug 2008)
New Revision: 8637
Added:
trunk/src/excel/org/jboss/seam/excel/exporter/
Removed:
trunk/src/excel/org/jboss/seam/excel/jxl/exporter/
Modified:
trunk/examples/excel/resources/WEB-INF/components.xml
trunk/examples/excel/view/home.xhtml
trunk/src/excel/org/jboss/seam/excel/exporter/ExcelExporter.java
trunk/src/excel/org/jboss/seam/excel/exporter/StyleParser.java
trunk/src/excel/org/jboss/seam/excel/ui/UIExcelExport.java
Log:
JBSEAM-3239
Modified: trunk/examples/excel/resources/WEB-INF/components.xml
===================================================================
--- trunk/examples/excel/resources/WEB-INF/components.xml 2008-08-08 13:34:18 UTC (rev 8636)
+++ trunk/examples/excel/resources/WEB-INF/components.xml 2008-08-08 13:53:45 UTC (rev 8637)
@@ -9,7 +9,6 @@
<core:init debug="true" jndi-pattern="@jndiPattern@" />
- <!-- Just a sample of how you may register own ExcelWorkbooks -->
<excel:excelFactory>
<property name="implementations">
<key>jxl</key><value>org.jboss.seam.excel.jxl.JXLExcelWorkbook</value>
Modified: trunk/examples/excel/view/home.xhtml
===================================================================
--- trunk/examples/excel/view/home.xhtml 2008-08-08 13:34:18 UTC (rev 8636)
+++ trunk/examples/excel/view/home.xhtml 2008-08-08 13:53:45 UTC (rev 8637)
@@ -42,7 +42,7 @@
<h:outputText value="#{person.age}"></h:outputText>
</rich:column>
</rich:dataTable>
- <h:commandLink value="Export table" action="#{org.jboss.seam.excel.excelExporter.export('excelExport:excelTable')}" />
+ <h:commandLink value="Export table" action="#{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:excelTable')}" />
</a4j:outputPanel>
</h:form>
Copied: trunk/src/excel/org/jboss/seam/excel/exporter (from rev 8636, trunk/src/excel/org/jboss/seam/excel/jxl/exporter)
Modified: trunk/src/excel/org/jboss/seam/excel/exporter/ExcelExporter.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/exporter/ExcelExporter.java 2008-08-08 13:34:18 UTC (rev 8636)
+++ trunk/src/excel/org/jboss/seam/excel/exporter/ExcelExporter.java 2008-08-08 13:53:45 UTC (rev 8637)
@@ -1,4 +1,4 @@
-package org.jboss.seam.excel.jxl.exporter;
+package org.jboss.seam.excel.exporter;
import java.io.IOException;
import java.util.ArrayList;
@@ -36,7 +36,7 @@
* @author Nicklas Karlsson (nickarls(a)gmail.com)
*
*/
-@Name("org.jboss.seam.excel.excelExporter")
+@Name("org.jboss.seam.excel.exporter.excelExporter")
@Scope(ScopeType.EVENT)
@BypassInterceptors
public class ExcelExporter
@@ -55,8 +55,8 @@
@SuppressWarnings("unchecked")
public void export(String dataTableId)
{
- // FIXME: hardcoded
- excelWorkbook = ExcelFactory.instance().getExcelWorkbook("jxl");
+ // TODO: support "type" ?
+ excelWorkbook = ExcelFactory.instance().getExcelWorkbook("");
// Gets the datatable
UIData dataTable = (UIData) FacesContext.getCurrentInstance().getViewRoot().findComponent(dataTableId);
Modified: trunk/src/excel/org/jboss/seam/excel/exporter/StyleParser.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/exporter/StyleParser.java 2008-08-08 13:34:18 UTC (rev 8636)
+++ trunk/src/excel/org/jboss/seam/excel/exporter/StyleParser.java 2008-08-08 13:53:45 UTC (rev 8637)
@@ -1,4 +1,4 @@
-package org.jboss.seam.excel.jxl.exporter;
+package org.jboss.seam.excel.exporter;
import java.util.ArrayList;
import java.util.HashMap;
Modified: trunk/src/excel/org/jboss/seam/excel/ui/UIExcelExport.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/ui/UIExcelExport.java 2008-08-08 13:34:18 UTC (rev 8636)
+++ trunk/src/excel/org/jboss/seam/excel/ui/UIExcelExport.java 2008-08-08 13:53:45 UTC (rev 8637)
@@ -8,7 +8,7 @@
import org.jboss.seam.core.Interpolator;
import org.jboss.seam.excel.ExcelWorkbookException;
-import org.jboss.seam.excel.jxl.exporter.ExcelExporter;
+import org.jboss.seam.excel.exporter.ExcelExporter;
public class UIExcelExport extends ExcelComponent
{
15 years, 9 months
- 1
- 0
Seam SVN: r8636 - in trunk: examples/excel/resources/WEB-INF and 5 other directories.
by seam-commits＠lists.jboss.org
Author: danielc.roth
Date: 2008-08-08 09:34:18 -0400 (Fri, 08 Aug 2008)
New Revision: 8636
Modified:
trunk/examples/excel/build.xml
trunk/examples/excel/resources/WEB-INF/components.xml
trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java
trunk/examples/excel/view/home.xhtml
trunk/src/excel/org/jboss/seam/excel/ExcelFactory.java
trunk/src/excel/org/jboss/seam/excel/csv/CsvExcelWorkbook.java
trunk/src/excel/org/jboss/seam/excel/excel-2.1.xsd
trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelWorkbook.java
Log:
JBSEAM-3241
Modified: trunk/examples/excel/build.xml
===================================================================
--- trunk/examples/excel/build.xml 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/examples/excel/build.xml 2008-08-08 13:34:18 UTC (rev 8636)
@@ -6,7 +6,7 @@
<property name="example.name" value="jboss-seam-excel"/>
<!-- Libraries -->
- <property name="seam.ui.lib" value="yes"/>
+ <property name="seam.ui.lib" value="yes"/>
<property name="seam.excel.lib" value="yes"/>
<property name="seam.debug.lib" value="yes"/>
<property name="facelets.lib" value="yes"/>
Modified: trunk/examples/excel/resources/WEB-INF/components.xml
===================================================================
--- trunk/examples/excel/resources/WEB-INF/components.xml 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/examples/excel/resources/WEB-INF/components.xml 2008-08-08 13:34:18 UTC (rev 8636)
@@ -1,14 +1,19 @@
-<components xmlns="http://jboss.com/products/seam/components"
- xmlns:pdf="http://jboss.com/products/seam/pdf"
- xmlns:core="http://jboss.com/products/seam/core"
- xmlns:framework="http://jboss.com/products/seam/framework"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://jboss.com/products/seam/core http://jboss.com/products/seam/core-2.1.xsd
+<components xmlns="http://jboss.com/products/seam/components" xmlns:excel="http://jboss.com/products/seam/excel"
+ xmlns:core="http://jboss.com/products/seam/core" xmlns:framework="http://jboss.com/products/seam/framework"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://jboss.com/products/seam/core http://jboss.com/products/seam/core-2.1.xsd
http://jboss.com/products/seam/framework http://jboss.com/products/seam/framework-2.1.xsd
- http://jboss.com/products/seam/pdf http://jboss.com/products/seam/pdf-2.1.xsd
+ http://jboss.com/products/seam/excel http://jboss.com/products/seam/excel-2.1.xsd
http://jboss.com/products/seam/components http://jboss.com/products/seam/components-2.1.xsd">
- <core:init debug="true" jndi-pattern="@jndiPattern@" />
+ <core:init debug="true" jndi-pattern="@jndiPattern@" />
+ <!-- Just a sample of how you may register own ExcelWorkbooks -->
+ <excel:excelFactory>
+ <property name="implementations">
+ <key>jxl</key><value>org.jboss.seam.excel.jxl.JXLExcelWorkbook</value>
+ </property>
+ </excel:excelFactory>
+
</components>
Modified: trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java
===================================================================
--- trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/examples/excel/src/org/jboss/seam/excel/ExcelTest.java 2008-08-08 13:34:18 UTC (rev 8636)
@@ -3,14 +3,19 @@
import java.util.LinkedList;
import java.util.List;
+import org.jboss.seam.ScopeType;
import org.jboss.seam.annotations.AutoCreate;
import org.jboss.seam.annotations.Create;
import org.jboss.seam.annotations.Name;
+import org.jboss.seam.annotations.Scope;
@Name("excelTest")
+(a)Scope(ScopeType.SESSION)
public class ExcelTest
{
+ private List<Person> people = new LinkedList<Person>();
+
public List<Person> getPeople()
{
List<Person> ret = new LinkedList<Person>();
@@ -21,6 +26,19 @@
return ret;
}
+
+ public List<Person> getResult()
+ {
+ return people;
+ }
+
+ public void search() {
+ this.people = getPeople();
+ }
+
+ public void clear() {
+ this.people = new LinkedList<Person>();
+ }
public class Person
{
Modified: trunk/examples/excel/view/home.xhtml
===================================================================
--- trunk/examples/excel/view/home.xhtml 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/examples/excel/view/home.xhtml 2008-08-08 13:34:18 UTC (rev 8636)
@@ -1,50 +1,52 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml"
- xmlns:ui="http://java.sun.com/jsf/facelets"
- xmlns:h="http://java.sun.com/jsf/html"
- xmlns:f="http://java.sun.com/jsf/core"
- xmlns:e="http://jboss.com/products/seam/excel"
- xmlns:s="http://jboss.com/products/seam/taglib">
-<head>
-<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
-<title>Microsoft® Excel® Export examples</title>
-<link href="css/screen.css" rel="stylesheet" type="text/css" />
-</head>
-<body id="excelHome">
-<f:view>
-
- <h:outputText value="Microsoft® Excel® Export examples"
- style="header"></h:outputText>
- <br />
- <br />
-
- <h:outputLink value="jxl.seam">
- <h:outputText>Export as Excel® spreadsheet</h:outputText>
- </h:outputLink>
- <br />
-
- <h:outputLink value="jxl.seam">
- <h:outputText>Export as comma separated file</h:outputText>
- </h:outputLink>
- <br />
- <br />
-
- <h:form id="excelExport">
- <h:dataTable value="#{excelTest.people}" var="person" id="excelTable"
- columnClasses="left, right">
- <h:column>
- <f:facet name="header">Name</f:facet>
- <h:outputText value="#{person.name} #{person.lastName}"></h:outputText>
- </h:column>
- <h:column>
- <f:facet name="header">Age</f:facet>
- <h:outputText value="#{person.age}"></h:outputText>
- </h:column>
- </h:dataTable>
- <h:commandLink value="Export table"
- action="#{org.jboss.seam.excel.excelExporter.export('excelExport:excelTable')}" />
- </h:form>
-
-</f:view>
-</body>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xmlns:ui="http://java.sun.com/jsf/facelets" xmlns:h="http://java.sun.com/jsf/html"
+ xmlns:a4j="http://richfaces.org/a4j" xmlns:f="http://java.sun.com/jsf/core" xmlns:e="http://jboss.com/products/seam/excel"
+ xmlns:s="http://jboss.com/products/seam/taglib" xmlns:rich="http://richfaces.ajax4jsf.org/rich">
+<head>
+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
+<title>Microsoft® Excel® Export examples</title>
+<link href="css/screen.css" rel="stylesheet" type="text/css" />
+</head>
+<body id="excelHome">
+<f:view>
+
+ <h:outputText value="Microsoft® Excel® Export examples" style="header"></h:outputText>
+ <br />
+ <br />
+
+ <h:outputLink value="jxl.seam">
+ <h:outputText>Export as Excel® spreadsheet</h:outputText>
+ </h:outputLink>
+ <br />
+
+ <h:outputLink value="jxl.seam">
+ <h:outputText>Export as comma separated file</h:outputText>
+ </h:outputLink>
+ <br />
+ <br />
+
+ <h:form id="excelExport">
+ <a4j:commandButton value="Search" reRender="searchResults" action="#{excelTest.search}" />
+ <a4j:commandButton value="Clear" reRender="searchResults" action="#{excelTest.clear}" />
+
+
+ <a4j:outputPanel id="searchResults">
+
+ <rich:dataTable value="#{excelTest.result}" var="person" id="excelTable" columnClasses="left, right">
+ <rich:column>
+ <f:facet name="header">Name</f:facet>
+ <h:outputText value="#{person.name} #{person.lastName}"></h:outputText>
+ </rich:column>
+ <rich:column>
+ <f:facet name="header">Age</f:facet>
+ <h:outputText value="#{person.age}"></h:outputText>
+ </rich:column>
+ </rich:dataTable>
+ <h:commandLink value="Export table" action="#{org.jboss.seam.excel.excelExporter.export('excelExport:excelTable')}" />
+
+ </a4j:outputPanel>
+ </h:form>
+
+</f:view>
+</body>
</html>
\ No newline at end of file
Modified: trunk/src/excel/org/jboss/seam/excel/ExcelFactory.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/ExcelFactory.java 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/src/excel/org/jboss/seam/excel/ExcelFactory.java 2008-08-08 13:34:18 UTC (rev 8636)
@@ -1,23 +1,36 @@
package org.jboss.seam.excel;
+import java.util.HashMap;
+import java.util.Map;
+
import org.jboss.seam.Component;
import org.jboss.seam.ScopeType;
import org.jboss.seam.annotations.AutoCreate;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.annotations.Scope;
-import org.jboss.seam.core.Interpolator;
+import org.jboss.seam.annotations.intercept.BypassInterceptors;
+import org.jboss.seam.excel.csv.CsvExcelWorkbook;
+import org.jboss.seam.excel.jxl.JXLExcelWorkbook;
+import org.jboss.seam.util.Strings;
@Name("org.jboss.seam.excel.excelFactory")
@Scope(ScopeType.STATELESS)
@AutoCreate
+@BypassInterceptors
public class ExcelFactory
{
- public final static String DEFAULT_IMPL = "jxl";
- public final static String DEFAULT_NS = "org.jboss.seam.excel";
+ private static Map<String, Class<? extends ExcelWorkbook>> defaultImplementations;
- private String namespace;
+ private Map<String, Class> implementations;
+ static
+ {
+ defaultImplementations = new HashMap<String, Class<? extends ExcelWorkbook>>();
+ defaultImplementations.put("csv", CsvExcelWorkbook.class);
+ defaultImplementations.put("jxl", JXLExcelWorkbook.class);
+ }
+
public static ExcelFactory instance()
{
return (ExcelFactory) Component.getInstance(ExcelFactory.class);
@@ -26,29 +39,50 @@
public ExcelWorkbook getExcelWorkbook(String type)
{
- String namespace = DEFAULT_NS;
- String impl = DEFAULT_IMPL;
+ Class<? extends ExcelWorkbook> clazz;
- namespace = this.namespace != null ? this.namespace : DEFAULT_NS;
- impl = !"".equals(type) ? type : DEFAULT_IMPL;
+ ExcelWorkbook excelWorkbook;
- ExcelWorkbook excelWorkbook = (ExcelWorkbook) Component.getInstance(namespace + "." + impl);
- if (excelWorkbook == null)
+ if (Strings.isEmpty(type))
{
- throw new ExcelWorkbookException(Interpolator.instance().interpolate("Could not create excel workbook with namespace '#0' and type #1", namespace, type));
+ type = "jxl";
}
+
+ if (implementations != null && implementations.get(type) != null)
+ {
+ clazz = implementations.get(type);
+ }
+ else
+ {
+ clazz = defaultImplementations.get(type);
+ }
+
+ if (clazz == null)
+ {
+ throw new IllegalArgumentException("Unable to create workbook of type " + type);
+ }
+
+ try
+ {
+ excelWorkbook = clazz.newInstance();
+ }
+ catch (Exception e)
+ {
+ throw new IllegalArgumentException("The class provided could not be instanciated " + type, e);
+ }
+
return excelWorkbook;
}
- public String getNamespace()
+ public Map<String, Class> getImplementations()
{
- return namespace;
+ return implementations;
}
- public void setNamespace(String namespace)
+ public void setImplementations(Map<String, Class> implementations)
{
- this.namespace = namespace;
+ this.implementations = implementations;
}
-}
+}
\ No newline at end of file
Modified: trunk/src/excel/org/jboss/seam/excel/csv/CsvExcelWorkbook.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/csv/CsvExcelWorkbook.java 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/src/excel/org/jboss/seam/excel/csv/CsvExcelWorkbook.java 2008-08-08 13:34:18 UTC (rev 8636)
@@ -5,33 +5,26 @@
import java.util.Map;
import java.util.TreeMap;
-import org.jboss.seam.ScopeType;
-import org.jboss.seam.annotations.Name;
-import org.jboss.seam.annotations.Scope;
-import org.jboss.seam.annotations.intercept.BypassInterceptors;
-import org.jboss.seam.excel.Command;
import org.jboss.seam.document.DocumentData;
+import org.jboss.seam.document.DocumentData.DocumentType;
+import org.jboss.seam.excel.Command;
import org.jboss.seam.excel.ExcelWorkbook;
import org.jboss.seam.excel.ExcelWorkbookException;
import org.jboss.seam.excel.Template;
import org.jboss.seam.excel.WorksheetItem;
-import org.jboss.seam.document.DocumentData.DocumentType;
import org.jboss.seam.excel.ui.UICell;
import org.jboss.seam.excel.ui.UIColumn;
import org.jboss.seam.excel.ui.UIImage;
import org.jboss.seam.excel.ui.UIWorkbook;
import org.jboss.seam.excel.ui.UIWorksheet;
-/*
- * 10 minute (quite poor) implementation of csv excel workbook...
- * Perhaps better would be to use some kind of.
+/**
+ * 10 minute (quite poor) implementation of csv excel workbook... Perhaps better
+ * would be to use some kind of library for this.
*
* Use at own risk.. :)
- *
+ *
*/
-@Name("org.jboss.seam.excel.csv")
-(a)Scope(ScopeType.EVENT)
-@BypassInterceptors
public class CsvExcelWorkbook implements ExcelWorkbook
{
int column = 0;
@@ -140,22 +133,18 @@
public void addTemplate(Template template)
{
- // TODO Auto-generated method stub
}
public void applyWorksheetSettings(UIWorksheet uiWorksheet)
{
- // TODO Auto-generated method stub
}
public void applyColumnSettings(UIColumn uiColumn)
{
- // TODO Auto-generated method stub
}
public void executeCommand(Command command)
{
- // TODO Auto-generated method stub
}
}
Modified: trunk/src/excel/org/jboss/seam/excel/excel-2.1.xsd
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/excel-2.1.xsd 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/src/excel/org/jboss/seam/excel/excel-2.1.xsd 2008-08-08 13:34:18 UTC (rev 8636)
@@ -1,53 +1,19 @@
<?xml version="1.0" encoding="UTF-8"?>
-<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
- elementFormDefault="qualified"
- targetNamespace="http://jboss.com/products/seam/excel"
- xmlns:excel="http://jboss.com/products/seam/excel"
- xmlns:components="http://jboss.com/products/seam/components"
- attributeFormDefault="unqualified">
- <xs:import namespace="http://jboss.com/products/seam/components" schemaLocation="components-2.1.xsd"/>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:doc="http://jboss.com/products/seam/document" xmlns:excel="http://jboss.com/products/seam/excel"
+ xmlns:components="http://jboss.com/products/seam/components" targetNamespace="http://jboss.com/products/seam/document" elementFormDefault="qualified"
+ attributeFormDefault="unqualified">
- <xs:element name="document-store">
- <xs:annotation>
- <xs:documentation>
- The Excel document store is used to store rendered documents for download on a later request.
- </xs:documentation>
- </xs:annotation>
- <xs:complexType mixed="true">
- <xs:attributeGroup ref="components:attlist.component"/>
- <xs:attributeGroup ref="excel:attlist.docstore"/>
- </xs:complexType>
- </xs:element>
- <xs:attributeGroup name="attlist.docstore">
- <xs:attribute name="error-page" type="components:string">
- <xs:annotation>
- <xs:documentation>
- When a document had expired or otherwise cannot be loaded, this page is displayed.
- </xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attribute name="use-extensions" type="components:boolean">
- <xs:annotation>
- <xs:documentation>
- Controls whether or not the URLs for documents should contain their correct file name extensions.
- Using file name extensions requires additional configuration in web.xml.
- </xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:attributeGroup>
+ <xs:import namespace="http://jboss.com/products/seam/components" schemaLocation="components-2.1.xsd" />
- <xs:element name="excel-factory">
- <xs:annotation>
- <xs:documentation>
- Factory creating excel workbook instances
- </xs:documentation>
- </xs:annotation>
- <xs:complexType mixed="true">
- <xs:attributeGroup ref="components:attlist.component"/>
- <xs:attributeGroup ref="excel:attlist.namespace"/>
- </xs:complexType>
- </xs:element>
- <xs:attributeGroup name="attlist.namespace">
- <xs:attribute name="namespace" type="components:string"/>
- </xs:attributeGroup>
+ <xs:element name="excel-factory">
+ <xs:annotation>
+ <xs:documentation>Factory creating excel workbook instances</xs:documentation>
+ </xs:annotation>
+ <xs:complexType mixed="true">
+ <xs:element name="implementations" type="components:mapProperty" />
+ </xs:complexType>
+ </xs:element>
+
+
+
</xs:schema>
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelWorkbook.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelWorkbook.java 2008-08-08 11:58:04 UTC (rev 8635)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelWorkbook.java 2008-08-08 13:34:18 UTC (rev 8636)
@@ -20,18 +20,14 @@
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
-import org.jboss.seam.ScopeType;
-import org.jboss.seam.annotations.Name;
-import org.jboss.seam.annotations.Scope;
-import org.jboss.seam.annotations.intercept.BypassInterceptors;
import org.jboss.seam.core.Interpolator;
-import org.jboss.seam.excel.Command;
import org.jboss.seam.document.DocumentData;
+import org.jboss.seam.document.DocumentData.DocumentType;
+import org.jboss.seam.excel.Command;
import org.jboss.seam.excel.ExcelWorkbook;
import org.jboss.seam.excel.ExcelWorkbookException;
import org.jboss.seam.excel.Template;
import org.jboss.seam.excel.WorksheetItem;
-import org.jboss.seam.document.DocumentData.DocumentType;
import org.jboss.seam.excel.jxl.JXLTemplates.CellInfo;
import org.jboss.seam.excel.ui.UICell;
import org.jboss.seam.excel.ui.UIColumn;
@@ -54,9 +50,6 @@
* @author Daniel Roth (danielc.roth(a)gmail.com)
* @version 0.2
*/
-@Name("org.jboss.seam.excel.jxl")
-(a)Scope(ScopeType.EVENT)
-@BypassInterceptors
public class JXLExcelWorkbook implements ExcelWorkbook
{
private static final int CELL_DEFAULT_HEIGHT = 17;
15 years, 9 months
- 1
- 0
Seam SVN: r8635 - branches/Seam_2_0_FP/build.
by seam-commits＠lists.jboss.org
Author: manaRH
Date: 2008-08-08 07:58:04 -0400 (Fri, 08 Aug 2008)
New Revision: 8635
Modified:
branches/Seam_2_0_FP/build/root.pom.xml
Log:
JBPAPP-1020 - update of hibernate libs
Modified: branches/Seam_2_0_FP/build/root.pom.xml
===================================================================
--- branches/Seam_2_0_FP/build/root.pom.xml 2008-08-08 10:13:23 UTC (rev 8634)
+++ branches/Seam_2_0_FP/build/root.pom.xml 2008-08-08 11:58:04 UTC (rev 8635)
@@ -274,7 +274,7 @@
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-annotations</artifactId>
- <version>3.3.0.ga</version>
+ <version>3.3.1.GA</version>
<exclusions>
<exclusion>
<groupId>junit</groupId>
@@ -286,7 +286,7 @@
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
- <version>3.3.1.ga</version>
+ <version>3.3.2.GA</version>
<exclusions>
<exclusion>
<groupId>commons-logging</groupId>
15 years, 9 months
- 1
- 0
Seam SVN: r8634 - trunk/build/embedded.
by seam-commits＠lists.jboss.org
Author: pete.muir(a)jboss.org
Date: 2008-08-08 06:13:23 -0400 (Fri, 08 Aug 2008)
New Revision: 8634
Modified:
trunk/build/embedded/build.xml
Log:
Fix bug in embeddded deploy script
Modified: trunk/build/embedded/build.xml
===================================================================
--- trunk/build/embedded/build.xml 2008-08-08 09:59:36 UTC (rev 8633)
+++ trunk/build/embedded/build.xml 2008-08-08 10:13:23 UTC (rev 8634)
@@ -9,6 +9,8 @@
<property name="lib.dir" value="${seam.dir}/lib" />
<import file="../utilities.build.xml" />
+ <property name="maven.settings.xml" value="../settings.xml" />
+
<path id="maven-ant-tasks.classpath" path="${build.dir}/lib/maven-ant-tasks.jar" />
<typedef resource="org/apache/maven/artifact/ant/antlib.xml" uri="urn:maven-artifact-ant" classpathref="maven-ant-tasks.classpath" />
15 years, 9 months
- 1
- 0
Seam SVN: r8633 - in trunk/src/excel/org/jboss/seam/excel/jxl: exporter and 1 other directory.
by seam-commits＠lists.jboss.org
Author: nickarls
Date: 2008-08-08 05:59:36 -0400 (Fri, 08 Aug 2008)
New Revision: 8633
Modified:
trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java
trunk/src/excel/org/jboss/seam/excel/jxl/exporter/StyleParser.java
Log:
Improved exception handling for fetching constants in the spirit of JBSEAM-3232
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java 2008-08-08 09:21:35 UTC (rev 8632)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java 2008-08-08 09:59:36 UTC (rev 8633)
@@ -200,7 +200,7 @@
{
return orientation == null ? PageOrientation.LANDSCAPE : (PageOrientation) getConstant(JXL_PAGE_ORIENTATION_CLASS_NAME, orientation.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Page orientation {0} not supported, try {1}", orientation, getValidConstants(JXL_PAGE_ORIENTATION_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -223,7 +223,7 @@
{
return paperSize == null ? PaperSize.A4 : (PaperSize) getConstant(JXL_PAPER_SIZE_CLASS_NAME, paperSize.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Page size {0} not supported, try {1}", paperSize, getValidConstants(JXL_PAPER_SIZE_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -686,12 +686,13 @@
{
log.trace("Creating number format for mask #0", mask);
}
- try
+ try
{
return (DisplayFormat) getConstant("jxl.write.NumberFormats", mask);
}
- catch (Exception e)
- {
+ catch (NoSuchFieldException e) {
+ // Look! An empty catch block! But this one is documented. We are using this to see if there is a constant
+ // defines for this in the class
return null;
}
}
@@ -715,8 +716,10 @@
{
return (DisplayFormat) getConstant("jxl.write.DateFormats", mask.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
+ // Look! An empty catch block! But this one is documented. We are using this to see if there is a constant
+ // defines for this in the class
return null;
}
}
@@ -740,7 +743,7 @@
{
return verticalAlignment == null ? VerticalAlignment.BOTTOM : (VerticalAlignment) getConstant(JXL_VERTICAL_ALIGNMENT_CLASS_NAME, verticalAlignment.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Verical alignment {0} not supported, try {1}", verticalAlignment, getValidConstants(JXL_VERTICAL_ALIGNMENT_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -766,7 +769,7 @@
{
return orientation == null ? Orientation.HORIZONTAL : (Orientation) getConstant(JXL_ORIENTATION_CLASS_NAME, orientation.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Orientation {0} not supported, try {1}", orientation, getValidConstants(JXL_ORIENTATION_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -792,7 +795,7 @@
{
return alignment == null ? Alignment.LEFT : (Alignment) getConstant(JXL_ALIGNMENT_CLASS_NAME, alignment.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Alignment {0} not supported, try {1}", alignment, getValidConstants(JXL_ALIGNMENT_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -818,7 +821,7 @@
{
return pattern == null ? Pattern.SOLID : (Pattern) getConstant(JXL_PATTERN_CLASS_NAME, pattern.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Pattern {0} not supported, try {1}", pattern, getValidConstants(JXL_PATTERN_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -844,7 +847,7 @@
{
return borderLineStyle == null ? BorderLineStyle.NONE : (BorderLineStyle) getConstant(JXL_BORDER_LINE_STYLE_CLASS_NAME, borderLineStyle.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Border line style {0} not supported, try {1}", borderLineStyle, getValidConstants(JXL_BORDER_LINE_STYLE_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -870,7 +873,7 @@
{
return border == null ? Border.ALL : (Border) getConstant(JXL_BORDER_CLASS_NAME, border.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Border {0} not supported, try {1}", border, getValidConstants(JXL_BORDER_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -896,7 +899,7 @@
{
return underlineStyle == null ? UnderlineStyle.NO_UNDERLINE : (UnderlineStyle) getConstant(JXL_UNDERLINE_STYLE_CLASS_NAME, underlineStyle.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Underline style {0} not supported, try {1}", underlineStyle, getValidConstants(JXL_UNDERLINE_STYLE_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -922,7 +925,7 @@
{
return scriptStyle == null ? ScriptStyle.NORMAL_SCRIPT : (ScriptStyle) getConstant(JXL_SCRIPT_STYLE_CLASS_NAME, scriptStyle.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Script style {0} not supported, try {1}", scriptStyle, getValidConstants(JXL_SCRIPT_STYLE_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -954,7 +957,7 @@
{
return color == null ? Colour.AUTOMATIC : (Colour) getConstant(JXL_COLOR_CLASS_NAME, color.toUpperCase());
}
- catch (Exception e)
+ catch (NoSuchFieldException e)
{
String message = Interpolator.instance().interpolate("Color {0} not supported, try {1}", color, getValidConstants(JXL_COLOR_CLASS_NAME));
throw new ExcelWorkbookException(message, e);
@@ -1238,15 +1241,22 @@
* @param className The name of the class containing the constant
* @param fieldName The name of the constant
* @return The constant
- * @throws Exception If there is a reflection error fetching the data.
+ * @throws NoSuchFieldException if the field is not found
*/
- protected static Object getConstant(String className, String fieldName) throws Exception
+ protected static Object getConstant(String className, String fieldName) throws NoSuchFieldException
{
if (log.isTraceEnabled())
{
log.trace("Looking for constant #0 in class #1", fieldName, className);
}
- return Class.forName(className).getField(fieldName).get(null);
+ try
+ {
+ return Class.forName(className).getField(fieldName).get(null);
+ } catch (NoSuchFieldException e) {
+ throw e;
+ } catch (Exception e) {
+ throw new ExcelWorkbookException(Interpolator.instance().interpolate("Could not read field #0 from class #1", fieldName, className), e);
+ }
}
/**
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/exporter/StyleParser.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/exporter/StyleParser.java 2008-08-08 09:21:35 UTC (rev 8632)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/exporter/StyleParser.java 2008-08-08 09:59:36 UTC (rev 8633)
@@ -89,7 +89,7 @@
}
catch (Exception e)
{
- return null;
+ throw new ExcelWorkbookException(Interpolator.instance().interpolate("Could not read style attribute #0 from component #1", STYLE_ATTRIBUTE, uiComponent.getId() ));
}
}
15 years, 9 months
- 1
- 0
Seam SVN: r8632 - trunk/doc/Seam_Reference_Guide/en-US.
by seam-commits＠lists.jboss.org
Author: nickarls
Date: 2008-08-08 05:21:35 -0400 (Fri, 08 Aug 2008)
New Revision: 8632
Modified:
trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
Log:
JBSEAM-3234: Format documentation according to standards
Modified: trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
===================================================================
--- trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 08:28:15 UTC (rev 8631)
+++ trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 09:21:35 UTC (rev 8632)
@@ -1,53 +1,50 @@
-<?xml version="1.0" standalone="no"?>
+<?xml version="1.0" standalone="no"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN" "http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd" [
<!ENTITY excel 'the <trademark class="registered">Microsoft</trademark> <trademark class="registered">Excel</trademark> spreadsheet application'>
<!ENTITY Excel 'The <trademark class="registered">Microsoft</trademark> <trademark class="registered">Excel</trademark> spreadsheet application'>
]>
-
-
-<chapter id="excel">
+<chapter id="excel">
<title>&Excel;</title>
<para>
- Seam also supports generation of
- &excel;
- spreadsheets through the excellent
- <ulink url="http://jexcelapi.sourceforge.net/">JExcelAPI</ulink> library.
- The generated document is compatible with &excel;
- versions 95, 97, 2000, XP and 2003. Currently a limited subset of the
- library functionality is exposed but the ultimate goal is to be able to do
- everything the library allows for. Please refer to the JExcelAPI
- documentation for more information on capabilities and limitations.
+ Seam also supports generation of &excel; spreadsheets through the
+ excellent <ulink url="http://jexcelapi.sourceforge.net/">JExcelAPI
+ </ulink> library. The generated document is compatible with
+ &excel; versions 95, 97, 2000, XP and 2003. Currently a limited
+ subset of the library functionality is exposed but the ultimate
+ goal is to be able to do everything the library allows for. Please
+ refer to the JExcelAPI documentation for more information on
+ capabilities and limitations.
</para>
<section id="excel.intro">
<title>&Excel; support</title>
<para>
- &Excel; <literal>jboss-seam-excel.jar</literal>. This JAR contains the
- &excel; JSF controls, which are used to construct views that can render
- the document, and the DocumentStore component, which serves the
- rendered document to the user. To include &excel; support in your
- application, included <literal>jboss-seam-excel.jar</literal> in your
- <literal>WEB-INF/lib</literal> directory along with the
- <literal>jxl.jar</literal> JAR file. Furthermore, you need to configure
- the DocumentStore servlet in your web.xml
+ &Excel; <literal>jboss-seam-excel.jar</literal>. This JAR contains
+ the &excel; JSF controls, which are used to construct views that can
+ render the document, and the DocumentStore component, which serves
+ the rendered document to the user. To include &excel; support in
+ your application, included <literal>jboss-seam-excel.jar</literal>
+ in your <literal>WEB-INF/lib</literal> directory along with the
+ <literal>jxl.jar</literal> JAR file. Furthermore, you need to
+ configure the DocumentStore servlet in your web.xml
</para>
<para>
- &Excel; Seam module requires the use of Facelets as the view
+ &Excel; Seam module requires the use of Facelets as the view
technology. Additionally, it requires the use of the seam-ui package.
</para>
<para>
- The <literal>examples/excel</literal> project contains an example of
- &excel; support in action. It demonstrates proper deployment packaging,
- and it shows the exposed functionality.
+ The <literal>examples/excel</literal> project contains an example of
+ &excel; support in action. It demonstrates proper deployment
+ packaging, and it shows the exposed functionality.
</para>
<para>
- Customizing the module to support other kinds of &excel; spreadsheet
- API's has been made very easy. Implement the
- <literal>ExcelWorkbook</literal> interface, set the component name to
- <literal>org.jboss.seam.excel.<myModule></literal> and set the
- UIWorkbook type to <literal>myModule</literal> and your own exporter
- will be used. Default is "jxl", but support for CSV has also been
+ Customizing the module to support other kinds of &excel; spreadsheet
+ API's has been made very easy. Implement the <literal>ExcelWorkbook
+ </literal> interface, set the component name to
+ <literal>org.jboss.seam.excel.<myModule></literal> and set the
+ UIWorkbook type to <literal>myModule</literal> and your own exporter
+ will be used. Default is "jxl", but support for CSV has also been
added, using the type "csv".
</para>
@@ -55,44 +52,55 @@
<section id="excel.usage">
<title>Creating a simple workbook</title>
<para>
- Basic usage of the worksheet support is simple; it is used like a familiar
- <literal><h:dataTable></literal>
- and you can bind to a <literal>List</literal>, <literal>Set</literal>,
- <literal>Map</literal>, <literal>Array</literal> or
+ Basic usage of the worksheet support is simple; it is used like a
+ familiar <literal><h:dataTable></literal> and you can bind to a
+ <literal>List</literal>, <literal>Set</literal>,
+ <literal>Map</literal>, <literal>Array</literal> or
<literal>DataModel</literal>.
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook xmlns:e="http://jboss.com/products/seam/excel">
- <e:worksheet>
- <e:cell column="0" row="0" value="Hello world!"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook xmlns:e="http://jboss.com/products/seam/excel">
+ <e:worksheet>
+ <e:cell column="0" row="0" value="Hello world!"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
- <para>That's not terribly useful, so lets have a look at a more common case:</para>
+ <para>
+ That's not terribly useful, so lets have a look at a more common case:
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook xmlns:e="http://jboss.com/products/seam/excel">
- <e:worksheet value="#{data}" var="item">
- <e:column>
- <e:cell value="#{item.value}"/>
- </e:worksheet>
-</e:workbook>
-]]>
+ <e:workbook xmlns:e="http://jboss.com/products/seam/excel">
+ <e:worksheet value="#{data}" var="item">
+ <e:column>
+ <e:cell value="#{item.value}"/>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>
- First we have the top-level workbook element which serves as the container and it doesn't have any attributes.
- The child-element worksheet has two attributes; value="#{data}" is the EL-binding to the data and
- var="item" is the name of the current item. Nested inside the worksheet is a single column and within
- it you see the cell which is the final bind to the data within the currently iterated item
+ First we have the top-level workbook element which serves as the
+ container and it doesn't have any attributes. The child-element
+ worksheet has two attributes; value="#{data}" is the
+ EL-binding to the data and var="item" is the name of the
+ current item. Nested inside the worksheet is a single column and within
+ it you see the cell which is the final bind to the data within the
+ currently iterated item
</para>
- <para>This is all you know to get started dumping your data to worksheets!</para>
+ <para>
+ This is all you know to get started dumping your data to worksheets!
+ </para>
</section>
<section id="excel.workbook">
<title>Workbooks</title>
- <para>Workbooks are the top-level parents of worksheets, cell templates and worksheet templates.</para>
+ <para>
+ Workbooks are the top-level parents of worksheets, cell templates and
+ worksheet templates.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -112,154 +120,189 @@
<listitem>
<para>
<literal>type</literal>
- —Defines which export module to be used. The value is a string and can be either
- "jxl" or "csv". The default is "jxl".
+ —Defines which export module to be used. The
+ value is a string and can be either "jxl" or
+ "csv". The default is "jxl".
</para>
</listitem>
<listitem>
<para>
<literal>templateURI</literal>
- —A template that should be used as a basis for the workbook. The value is a string
- (URI).
+ —A template that should be used as a basis
+ for the workbook. The value is a string (URI).
</para>
</listitem>
<listitem>
<para>
<literal>arrayGrowSize</literal>
- —The amount of memory by which to increase the amount of memory allocated to storing
- the workbook data. For processeses reading many small workbooks inside a WAS it might be
- necessary to reduce the default size Default value is 1 megabyte. The value is a number
- (bytes).
+ —The amount of memory by which to increase
+ the amount of memory allocated to storing the
+ workbook data. For processeses reading many small
+ workbooks inside a WAS it might be necessary to
+ reduce the default size Default value is 1
+ megabyte. The value is a number (bytes).
</para>
</listitem>
<listitem>
<para>
<literal>autoFilterDisabled</literal>
- —Should autofiltering be disabled?. The value is a boolean.
+ —Should autofiltering be disabled?. The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>cellValidationDisabled</literal>
- —Shoule cell validation be ignored? The value is a boolean.
+ —Shoule cell validation be ignored? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>characterSet</literal>
- —The character set. This is only used when the spreadsheet is read, and has no
- effect when the spreadsheet is written. The value is a string (character set encoding).
+ —The character set. This is only used when
+ the spreadsheet is read, and has no effect when
+ the spreadsheet is written. The value is a string
+ (character set encoding).
</para>
</listitem>
<listitem>
<para>
<literal>drawingsDisabled</literal>
- —Should drawings be disabled? The value is a boolean.
+ —Should drawings be disabled? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>excelDisplayLanguage</literal>
- —The language in which the generated file will display. The value is a string (two
- character ISO 3166 country code).
+ —The language in which the generated file
+ will display. The value is a string (two character
+ ISO 3166 country code).
</para>
</listitem>
<listitem>
<para>
<literal>excelRegionalSettings</literal>
- —The regional settings for the generated excel file. The value is a string (two
- character ISO 3166 country code).
+ —The regional settings for the generated
+ excel file. The value is a string (two character
+ ISO 3166 country code).
</para>
</listitem>
<listitem>
<para>
<literal>formulaAdjust</literal>
- —Should formulas be adjusted? The value is a boolean.
+ —Should formulas be adjusted? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>gcDisabled</literal>
- —Should garbage collection be disabled? The value is a boolean.
+ —Should garbage collection be disabled? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>ignoreBlanks</literal>
- —Should blanks be ignored? The value is a boolean.
+ —Should blanks be ignored? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>initialFileSize</literal>
- —The initial amount of memory allocated to store the workbook data when reading a
- worksheet. For processeses reading many small workbooks inside a WAS it might be necessary
- to reduce the default size Default value is 5 megabytes. The value is a number (bytes).
+ —The initial amount of memory allocated to
+ store the workbook data when reading a worksheet.
+ For processeses reading many small workbooks
+ inside a WAS it might be necessary to reduce the
+ default size Default value is 5 megabytes. The
+ value is a number (bytes).
</para>
</listitem>
<listitem>
<para>
<literal>locale</literal>
- —The locale used by JExcelApi to generate the spreadsheet. Setting this value has no
- effect on the language or region of the generated excel file. The value is a string.
+ —The locale used by JExcelApi to generate
+ the spreadsheet. Setting this value has no effect
+ on the language or region of the generated excel
+ file. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>mergedCellCheckingDisabled</literal>
- —Should merged cell checking be disabled? The value is a boolean.
+ —Should merged cell checking be disabled?
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>namesDisabled</literal>
- —Should handling of names be disabled? The value is a boolean.
+ —Should handling of names be disabled? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>propertySets</literal>
- —Should any property sets be enabled (such as macros) to be copied along with the
- workbook? Leaving this feature enabled will result in the JXL process using more memory.
- The value is a boolean.
+ —Should any property sets be enabled (such
+ as macros) to be copied along with the workbook?
+ Leaving this feature enabled will result in the
+ JXL process using more memory. The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>rationalization</literal>
- —Should the cell formats be rationalized before writing out the sheet? The value is
- a boolean. Default is true.
+ —Should the cell formats be rationalized
+ before writing out the sheet? The value is a
+ boolean. Default is true.
</para>
</listitem>
<listitem>
<para>
<literal>supressWarnings</literal>
- —Should warnings be suppressed?. Due to the change in logging in version 2.4, this
- will now set the warning behaviour across the JVM (depending on the type of logger used).
- The value is a boolean.
+ —Should warnings be suppressed?. Due to the
+ change in logging in version 2.4, this will now
+ set the warning behaviour across the JVM
+ (depending on the type of logger used). The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
- <literal>temporaryFileDuringWriteDirectory</literal>
- —Used in conjunction with the <literal>useTemporaryFileDuringWrite</literal> setting to set the target
- directory for the temporary files. This value can be NULL, in which case the normal system
- default temporary directory is used instead. The value is a string (the directory to which
- temporary files should be written).
+ <literal>
+ temporaryFileDuringWriteDirectory
+ </literal>
+ —Used in conjunction with the
+ <literal>useTemporaryFileDuringWrite</literal>
+ setting to set the target directory for the
+ temporary files. This value can be NULL, in which
+ case the normal system default temporary directory
+ is used instead. The value is a string (the
+ directory to which temporary files should be
+ written).
</para>
</listitem>
<listitem>
<para>
<literal>useTemporaryFileDuringWrite</literal>
- —Should a temporary file is used during the generation of the workbook. If not set,
- the workbook will take place entirely in memory. Setting this flag involves an assessment
- of the trade-offs between memory usage and performance. The value is a boolean.
+ —Should a temporary file is used during the
+ generation of the workbook. If not set, the
+ workbook will take place entirely in memory.
+ Setting this flag involves an assessment of the
+ trade-offs between memory usage and performance.
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>workbookProtected</literal>
- —Should the workbook be protected? The value is a boolean.
+ —Should the workbook be protected? The value
+ is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -270,19 +313,25 @@
<listitem>
<para>
<literal><e:cellTemplate/></literal>
- —Zero or more cell templates (see <xref linkend="excel.templates.cell"/>).
+ —Zero or more cell templates (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:worksheetTemplate/></literal>
- —Zero or more worksheet templates (see <xref linkend="excel.templates.worksheetsettings"/>).
+ —Zero or more worksheet templates (see
+ <xref linkend="excel.templates.worksheetsettings" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:worksheet/></literal>
- —Zero or more worksheets (see <xref linkend="excel.worksheet"/>).
+ —Zero or more worksheets (see
+ <xref linkend="excel.worksheet" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -303,11 +352,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell value="Hello World" row="0" column="0"/>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell value="Hello World" row="0" column="0"/>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a workbook with a worksheet and a greeting at A1</para>
@@ -316,9 +365,10 @@
<section id="excel.worksheet">
<title>Worksheets</title>
<para>
- Worksheets are the children of workbooks and the parent of columns and worksheet commands
- They can also contain explicitly placed cells, formulas, images and hyperlinks. They are the
- pages that make up the workbook.
+ Worksheets are the children of workbooks and the parent of columns and
+ worksheet commands They can also contain explicitly placed cells,
+ formulas, images and hyperlinks. They are the pages that make up the
+ workbook.
</para>
<informaltable>
<tgroup cols="2">
@@ -336,252 +386,303 @@
<listitem>
<para>
<literal>value</literal>
- —An EL-expression to the backing data. The value is a string.
+ —An EL-expression to the backing data. The
+ value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>var</literal>
- —The current row iterator variable name that can later be referenced in cell value
- attributes. The value is a string
+ —The current row iterator variable name that
+ can later be referenced in cell value attributes.
+ The value is a string
</para>
</listitem>
<listitem>
<para>
<literal>name</literal>
- —The name of the worksheet. The valus is a string. Defaults to Sheet# where # is the
- worksheet index. If the given worksheet name exists, that sheet is selected. This can be
- used for merging several data sets into a single worksheet, just define the same name for
- them (using <literal>startRow</literal> and <literal>startCol</literal> to make sure that they don't occupy the same space).
+ —The name of the worksheet. The valus is a
+ string. Defaults to Sheet# where # is the
+ worksheet index. If the given worksheet name
+ exists, that sheet is selected. This can be used
+ for merging several data sets into a single
+ worksheet, just define the same name for them
+ (using
+ <literal>startRow</literal>
+ and
+ <literal>startCol</literal>
+ to make sure that they don't occupy the same
+ space).
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —Defines the starting row for the data. The value is a number. Used for placing the
- data in other places than the upper-left corner (especially useful if having multiple data
- sets for a single worksheet). The defaults is 0.
+ —Defines the starting row for the data. The
+ value is a number. Used for placing the data in
+ other places than the upper-left corner
+ (especially useful if having multiple data sets
+ for a single worksheet). The defaults is 0.
</para>
</listitem>
<listitem>
<para>
<literal>startColumn</literal>
- —Defines the starting column for the data. The value is a number. Used for placing
- the data in other places than the upper-left corner (especially useful if having multiple
- data sets for a single worksheet). The default is 0.
+ —Defines the starting column for the data.
+ The value is a number. Used for placing the data
+ in other places than the upper-left corner
+ (especially useful if having multiple data sets
+ for a single worksheet). The default is 0.
</para>
</listitem>
<listitem>
<para>
<literal>templates</literal>
- —The comma-separated list of <literal>worksheetTemplates</literal> to cascade on. The value is a
- string (see <xref linkend="excel.templates.cell"/>).
+ —The comma-separated list of
+ <literal>worksheetTemplates</literal>
+ to cascade on. The value is a string (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>automaticFormulaCalculation</literal>
- —Should formulas be automatically calculated? The value is a boolean.
+ —Should formulas be automatically
+ calculated? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>bottomMargin</literal>
- —The bottom margin. The value is a number (inches)
+ —The bottom margin. The value is a number
+ (inches)
</para>
</listitem>
<listitem>
<para>
<literal>copies</literal>
- —The number of copies. The value is a number.
+ —The number of copies. The value is a
+ number.
</para>
</listitem>
<listitem>
<para>
<literal>defaultColumnWidth</literal>
- —The default column width. The value is a number (characters * 256).
+ —The default column width. The value is a
+ number (characters * 256).
</para>
</listitem>
<listitem>
<para>
<literal>defaultRowHeight</literal>
- —The default row height. The value is a number (1/20ths of a point).
+ —The default row height. The value is a
+ number (1/20ths of a point).
</para>
</listitem>
<listitem>
<para>
<literal>displayZeroValues</literal>
- —Should zero-values be displayed? The value is a boolean.
+ —Should zero-values be displayed? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>fitHeight</literal>
- —The number of pages vertically that this sheet will be printed into. The value is a
- number.
+ —The number of pages vertically that this
+ sheet will be printed into. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>fitToPages</literal>
- —Should printing be fit to pages? The value is a boolean.
+ —Should printing be fit to pages? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>fitWidth</literal>
- —The number of pages widthwise which this sheet should be printed into. The value is
- a number.
+ —The number of pages widthwise which this
+ sheet should be printed into. The value is a
+ number.
</para>
</listitem>
<listitem>
<para>
<literal>footerMargin</literal>
- —The margin for any page footer. The value is a number (inches).
+ —The margin for any page footer. The value
+ is a number (inches).
</para>
</listitem>
<listitem>
<para>
<literal>headerMargin</literal>
- —The margin for any page headers. The value is a number (inches).
+ —The margin for any page headers. The value
+ is a number (inches).
</para>
</listitem>
<listitem>
<para>
<literal>hidden</literal>
- —Should the worksheet be hidden? The value is a boolean.
+ —Should the worksheet be hidden? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalCentre</literal>
- —Should the worksheet be centered horizontally? The value is a boolean.
+ —Should the worksheet be centered
+ horizontally? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalFreeze</literal>
- —The row at which the pane is frozen vertically. The value is a number.
+ —The row at which the pane is frozen
+ vertically. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalPrintResolution</literal>
- —The horizontal print resolution. The value is a number.
+ —The horizontal print resolution. The value
+ is a number.
</para>
</listitem>
<listitem>
<para>
<literal>leftMargin</literal>
- —The left margin. The value is a number (inches).
+ —The left margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
<para>
<literal>normalMagnification</literal>
- —The normal magnificaton factor (not zoom or scale factor). The value is a number
- (percentage).
+ —The normal magnificaton factor (not zoom or
+ scale factor). The value is a number (percentage).
</para>
</listitem>
<listitem>
<para>
<literal>orientation</literal>
- —The paper orientation for printing this sheet. The value is a string that can be
- either "landscape" or "portrait".
+ —The paper orientation for printing this
+ sheet. The value is a string that can be either
+ "landscape" or "portrait".
</para>
</listitem>
<listitem>
<para>
<literal>pageBreakPreviewMagnification</literal>
- —The page break preview magnificaton factor (not zoom or scale factors). the value
- is a number (percentage).
+ —The page break preview magnificaton factor
+ (not zoom or scale factors). the value is a number
+ (percentage).
</para>
</listitem>
<listitem>
<para>
<literal>pageBreakPreviewMode</literal>
- —Show page in preview mode? The value is a boolean.
+ —Show page in preview mode? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>pageStart</literal>
- —The page number at which to commence printing. The value is a number.
+ —The page number at which to commence
+ printing. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>paperSize</literal>
- —The paper size to be used when printing this sheet. The value is a string that can
- be one of "a4", "a3", "letter", "legal" etc (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.PaperSize</ulink>).
+ —The paper size to be used when printing
+ this sheet. The value is a string that can be one
+ of "a4", "a3", "letter", "legal" etc (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.PaperSize
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>password</literal>
- —The password for this sheet. The value is a string.
+ —The password for this sheet. The value is a
+ string.
</para>
</listitem>
<listitem>
<para>
<literal>passwordHash</literal>
- —The password hash - used only when copying sheets. The value is a string.
+ —The password hash - used only when copying
+ sheets. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>printGridLines</literal>
- —Should grid lines be printed? The value is a boolean.
+ —Should grid lines be printed? The value is
+ a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>printHeaders</literal>
- —Should headers be printed? The value is a boolean.
+ —Should headers be printed? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>sheetProtected</literal>
- —Should the sheet be protected (read-only)? The value is a boolean.
+ —Should the sheet be protected (read-only)?
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>recalculateFormulasBeforeSave</literal>
- —Should the formulas be re-calculated when the sheet is saved? The value is a
- boolean. false
+ —Should the formulas be re-calculated when
+ the sheet is saved? The value is a boolean. false
</para>
</listitem>
<listitem>
<para>
<literal>rightMargin</literal>
- —The right margin. The value is a number (inches).
+ —The right margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
<para>
<literal>scaleFactor</literal>
- —The scale factor for this sheet to be used when printing. The value is a number
- (percent).
+ —The scale factor for this sheet to be used
+ when printing. The value is a number (percent).
</para>
</listitem>
<listitem>
<para>
<literal>selected</literal>
- —Should the sheet be selected when the workbook opens? The value is a boolean.
+ —Should the sheet be selected when the
+ workbook opens? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>showGridLines</literal>
- —Should gridlines be shown? The value is a boolean.
+ —Should gridlines be shown? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>topMargin</literal>
- —The top margin. The value is a number (inches).
+ —The top margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
@@ -593,21 +694,24 @@
<listitem>
<para>
<literal>verticalFreeze</literal>
- —The row at which the pane is frozen vertically. The value is a number.
+ —The row at which the pane is frozen
+ vertically. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>verticalPrintResolution</literal>
- —The vertical print resolution. The value is a number.
+ —The vertical print resolution. The value is
+ a number.
</para>
</listitem>
<listitem>
<para>
<literal>zoomFactor</literal>
- —T zoom factor. Do not confuse zoom factor (which relates to the on screen view)
- with scale factor (which refers to the scale factor when printing). The value is a number
- (percentage.
+ —T zoom factor. Do not confuse zoom factor
+ (which relates to the on screen view) with scale
+ factor (which refers to the scale factor when
+ printing). The value is a number (percentage.
</para>
</listitem>
</itemizedlist>
@@ -618,24 +722,33 @@
<listitem>
<para>
<literal><e:printArea/></literal>
- —Zero or more print area definitions (see <xref linkend="excel.printareatitles"/>).
+ —Zero or more print area definitions (see
+ <xref linkend="excel.printareatitles" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:printTitle/></literal>
- —Zero or more print title definitions (see <xref linkend="excel.printareatitles"/>).
+ —Zero or more print title definitions (see
+ <xref linkend="excel.printareatitles" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:headerFooter/></literal>
- —Zero or more header/footer definitions ((see <xref linkend="excel.headersfooters"/>)).
+ —Zero or more header/footer definitions
+ ((see
+ <xref linkend="excel.headersfooters" />
+ )).
</para>
</listitem>
<listitem>
<para>
- Zero or more worksheet commands (see <xref linkend="excel.worksheetcommands"/> ).
+ Zero or more worksheet commands (see
+ <xref linkend="excel.worksheetcommands" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -656,16 +769,16 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet name="foo" startColumn="1" startRow="1">
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet name="foo" startColumn="1" startRow="1">
+ <e:column value="#{personList}" var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a worksheet with the name "foo", starting at B2.</para>
@@ -673,8 +786,9 @@
<section id="excel.columns">
<title>Columns</title>
<para>
- Columns are the children of worksheets and the parents of cells, images, formulas and hyperlinks.
- They are the structure that control the iteration of the worksheet data.
+ Columns are the children of worksheets and the parents of cells,
+ images, formulas and hyperlinks. They are the structure that control
+ the iteration of the worksheet data.
</para>
<informaltable>
<tgroup cols="2">
@@ -695,19 +809,22 @@
<listitem>
<para>
<literal>autoSize</literal>
- —Should the column be autosized? The value is a boolean.
+ —Should the column be autosized? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>hidden</literal>
- —Should the column be hidden? The value is a boolean.
+ —Should the column be hidden? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>width</literal>
- —The width of the column. The valus ia number (characters multiplied by 256)
+ —The width of the column. The valus ia
+ number (characters multiplied by 256)
</para>
</listitem>
</itemizedlist>
@@ -718,25 +835,33 @@
<listitem>
<para>
<literal><e:cell/></literal>
- —Zero or more cells (see <xref linkend="excel.cells"/>).
+ —Zero or more cells (see
+ <xref linkend="excel.cells" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:formula/></literal>
- —Zero or more formulas (see <xref linkend="excel.formulas"/>).
+ —Zero or more formulas (see
+ <xref linkend="excel.formulas" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:image/></literal>
- —Zero or more images (see <xref linkend="excel.images"/>).
+ —Zero or more images (see
+ <xref linkend="excel.images" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:hyperLink/></literal>
- —Zero or more hyperlinks (see <xref linkend="excel.hyperlinks"/>).
+ —Zero or more hyperlinks (see
+ <xref linkend="excel.hyperlinks" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -766,16 +891,16 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a column with a header and an iterated output</para>
@@ -784,10 +909,12 @@
<section id="excel.cells">
<title>Cells</title>
<para>
- Cells are nested within columns (for iteration) or inside worksheets (for direct placement using the <literal>column</literal> and
- <literal>row</literal> attributes) and are responsible for outputting the value (usually though en EL-expression involving the
- <literal>var</literal>-attribute of the datatable. They can contains fonts and other formattings and can also use pre-defined
- templates.
+ Cells are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the <literal>column</literal> and
+ <literal>row</literal> attributes) and are responsible for outputting
+ the value (usually though en EL-expression involving the
+ <literal>var</literal>-attribute of the datatable. They can contain
+ fonts and other formattings and can also use pre-defined templates.
</para>
<informaltable>
<tgroup cols="2">
@@ -808,108 +935,130 @@
<listitem>
<para>
<literal>column</literal>
- —The column where to place the cell. The default is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The column where to place the cell. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>row</literal>
- —The row where to place the cell. The default is the internal counter. The value is
+ —The row where to place the cell. The
+ default is the internal counter. The value is
number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>value</literal>
- —The value to display. Usually an EL-expression referencing the var-attribute of the
+ —The value to display. Usually an
+ EL-expression referencing the var-attribute of the
containing datatable. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>templates</literal>
- —A comma-separated list of cascading, predefined templates to apply before the own
- formattings (see <xref linkend="excel.templates.cell"/>).
+ —A comma-separated list of cascading,
+ predefined templates to apply before the own
+ formattings (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>forceType</literal>
- —The forced type of the cell data. The value is a string that can be one of
- "general", "number", "text", "date", "formula" or "bool". The type is automatically
- detected so there is rarely any use for this attribute.
+ —The forced type of the cell data. The value
+ is a string that can be one of "general",
+ "number", "text", "date", "formula" or "bool". The
+ type is automatically detected so there is rarely
+ any use for this attribute.
</para>
</listitem>
<listitem>
<para>
<literal>alignment</literal>
- —The alignment of the cell data. The value is a string that can be one of "centre",
- "fill", "general", "justify", "left" or "right".
+ —The alignment of the cell data. The value
+ is a string that can be one of "centre", "fill",
+ "general", "justify", "left" or "right".
</para>
</listitem>
<listitem>
<para>
<literal>comment</literal>
- —A comment to add to the cell. The value is a string.
+ —A comment to add to the cell. The value is
+ a string.
</para>
</listitem>
<listitem>
<para>
<literal>commentHeight</literal>
- —The height of the comment. The value is a number (in pixels).
+ —The height of the comment. The value is a
+ number (in pixels).
</para>
</listitem>
<listitem>
<para>
<literal>commentWidth</literal>
- —A width of the comment. The value is a number (in pixels).
+ —A width of the comment. The value is a
+ number (in pixels).
</para>
</listitem>
<listitem>
<para>
<literal>indentation</literal>
- —The indentation of the cell. The value is a number (in pixels)
+ —The indentation of the cell. The value is a
+ number (in pixels)
</para>
</listitem>
<listitem>
<para>
<literal>locked</literal>
- —Should the cell be locked? For this to have any effect, the sheet containing cells
- with this format must also be locked. The value is a boolean.
+ —Should the cell be locked? For this to have
+ any effect, the sheet containing cells with this
+ format must also be locked. The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>mask</literal>
- —A format mask (see <xref linkend="excel.cells.formatmasks"/>).
+ —A format mask (see
+ <xref linkend="excel.cells.formatmasks" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>orientation</literal>
- —The orientation of the cell data. The value is a string that can be one of
- "horizontal", "minus_45", "minus_90", "plus_45", "plus_90", "stacked" or "vertical".
+ —The orientation of the cell data. The value
+ is a string that can be one of "horizontal",
+ "minus_45", "minus_90", "plus_45", "plus_90",
+ "stacked" or "vertical".
</para>
</listitem>
<listitem>
<para>
<literal>shrinkToFit</literal>
- —Should the cell data be shrunk to fit? The value is a boolean.
+ —Should the cell data be shrunk to fit? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>verticalAlignment</literal>
- —The vertical aligment of the cell data. The value is a string that can be one of
- "bottom", "centre", "justify" or "top").
+ —The vertical aligment of the cell data. The
+ value is a string that can be one of "bottom",
+ "centre", "justify" or "top").
</para>
</listitem>
<listitem>
<para>
<literal>wrap</literal>
- —Should the data be wrapped so that it fits within the cell boundaries? The value is
- a boolean.
+ —Should the data be wrapped so that it fits
+ within the cell boundaries? The value is a
+ boolean.
</para>
</listitem>
</itemizedlist>
@@ -921,24 +1070,32 @@
<listitem>
<para>
<literal><e:font/></literal>
- —Zero or more font definitions (see <xref linkend="excel.cells.fonts"/>).
+ —Zero or more font definitions (see
+ <xref linkend="excel.cells.fonts" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:border/></literal>
- —Zero or more border definitions (see <xref linkend="excel.cells.borders"/>).
+ —Zero or more border definitions (see
+ <xref linkend="excel.cells.borders" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:background/></literal>
- —Zero or more background definitions (see <xref linkend="excel.cells.backgrounds"/>).
+ —Zero or more background definitions (see
+ <xref linkend="excel.cells.backgrounds" />
+ ).
</para>
</listitem>
<listitem>
<para>
- Zero or more validation conditions (see <xref linkend="excel.cells.validation"/>).
+ Zero or more validation conditions (see
+ <xref linkend="excel.cells.validation" />
+ ).
</para>
</listitem>
@@ -960,23 +1117,24 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defines a column with a header and an iterated output</para>
<section id="excel.cells.fonts">
<title>Fonts</title>
<para>
- Fonts are nested inside cells, formulas, hyperlinks or cell templates. They determine the typeface of the cell data
+ Fonts are nested inside cells, formulas, hyperlinks or cell
+ templates. They determine the typeface of the cell data
</para>
<informaltable>
<tgroup cols="2">
@@ -997,54 +1155,72 @@
<listitem>
<para>
<literal>fontName</literal>
- —The font name. The value is a string. Should be used with care, since the used
- font must be recognized by the <trademark class="registered">Microsoft</trademark>
- <trademark class="registered">Excel</trademark> spreadsheet application
+ —The font name. The value is a string.
+ Should be used with care, since the used font
+ must be recognized by the
+ <trademark class="registered">
+ Microsoft
+ </trademark>
+ <trademark class="registered">Excel</trademark>
+ spreadsheet application
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the background. The value is a string that can be one of "blue",
- "red" etc (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
+ —The color of the background. The value
+ is a string that can be one of "blue", "red"
+ etc (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>pointSize</literal>
- —The point size of the font. The value is a number.
+ —The point size of the font. The value is
+ a number.
</para>
</listitem>
<listitem>
<para>
<literal>bold</literal>
- —Should the font be bold? The value is a boolean.
+ —Should the font be bold? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>italic</literal>
- —Should the font be italic? The value is a boolean.
+ —Should the font be italic? The value is
+ a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>struckOut</literal>
- —Should the font be struck out? The value is a boolean.
+ —Should the font be struck out? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>scriptStyle</literal>
- —The script style of the font. The value is a string that can be one of
- "normal_script", "subscript" or "superscript".
+ —The script style of the font. The value
+ is a string that can be one of "normal_script",
+ "subscript" or "superscript".
</para>
</listitem>
<listitem>
<para>
<literal>underlineStyle</literal>
- —The underline style of the font. The value is a string that can be one of
- "double", "double_accounting", "no_underline", "single" or "single_accounting".
+ —The underline style of the font. The
+ value is a string that can be one of "double",
+ "double_accounting", "no_underline", "single"
+ or "single_accounting".
</para>
</listitem>
</itemizedlist>
@@ -1075,15 +1251,15 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:font fontName="Times New Roman" color="red" bold="true"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.age">
+ <e:font fontName="Times New Roman" color="red" bold="true"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defines a cell with a red, bold, Times New Roman font.</para>
@@ -1091,8 +1267,8 @@
<section id="excel.cells.backgrounds">
<title>Backgrounds</title>
<para>
- Backgrounds are nested inside cells, formulas, hyperlinks or cell templates. They determine
- the color and pattern of the cell.
+ Backgrounds are nested inside cells, formulas, hyperlinks or cell
+ templates. They determine the color and pattern of the cell.
</para>
<informaltable>
<tgroup cols="2">
@@ -1113,16 +1289,22 @@
<listitem>
<para>
<literal>pattern</literal>
- —The pattern of the background. The value is a string that can be one of "solid",
- "grey_25" etc (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Pattern</ulink>). The
- default is "solid".
+ —The pattern of the background. The value
+ is a string that can be one of "solid",
+ "grey_25" etc (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Pattern
+ </ulink>
+ ). The default is "solid".
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the background. The value is a string that can be one of "blue",
- "red" etc
+ —The color of the background. The value
+ is a string that can be one of "blue", "red"
+ etc
</para>
</listitem>
</itemizedlist>
@@ -1153,15 +1335,15 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:background color="green" pattern="grey_25"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.age">
+ <e:background color="green" pattern="grey_25"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defined a green cell background with a 25% grey mask.</para>
@@ -1169,8 +1351,9 @@
<section id="excel.cells.borders">
<title>Borders</title>
<para>
- Borders are nested inside cells, formulas, hyperlinks and cell templates.
- They determine the color and line style of the cell borders.
+ Borders are nested inside cells, formulas, hyperlinks and cell
+ templates. They determine the color and line style of the cell
+ borders.
</para>
<informaltable>
<tgroup cols="2">
@@ -1191,22 +1374,36 @@
<listitem>
<para>
<literal>border</literal>
- —The border to apply the settings to. The value is a string that can be one of
- "all", "bottom", "left", "none", "right" or "top". The default is "all".
+ —The border to apply the settings to. The
+ value is a string that can be one of "all",
+ "bottom", "left", "none", "right" or "top". The
+ default is "all".
</para>
</listitem>
<listitem>
<para>
<literal>lineStyle</literal>
- —The border line style. The value is a string that can be one of "medium", "thin"
- etc (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.BorderLineStyle</ulink>).
+ —The border line style. The value is a
+ string that can be one of "medium", "thin" etc
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.BorderLineStyle
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the border. The value is a string that can be one of "blue", "red"
- etc (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
+ —The color of the border. The value is a
+ string that can be one of "blue", "red" etc
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</listitem>
</itemizedlist>
@@ -1237,23 +1434,23 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:border border="left" color="green" lineStyle="thin"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.age">
+ <e:border border="left" color="green" lineStyle="thin"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>defined a thin green border on the left edge of the cell.</para>
</section>
<section id="excel.cells.validation">
<title>Validation</title>
<para>
- Validations are nested inside cells, formulas or cell templates.
+ Validations are nested inside cells, formulas or cell templates.
They add constrains for the cell data.
</para>
<informaltable>
@@ -1275,46 +1472,57 @@
<listitem>
<para>
<literal>value</literal>
- —The limit (or lower limit where applicable) of the validation. The value is a
+ —The limit (or lower limit where
+ applicable) of the validation. The value is a
number.
</para>
</listitem>
<listitem>
<para>
<literal>value2</literal>
- —The upper limit (where applicable) of the validation. The value is a number.
+ —The upper limit (where applicable) of
+ the validation. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>condition</literal>
- —The validation condition. The value is a string.
+ —The validation condition. The value is a
+ string.
<itemizedlist>
<listitem>
- "equal" - requires the cell value to match the one defined in the value-attribute
+ "equal" - requires the cell value to
+ match the one defined in the
+ value-attribute
</listitem>
<listitem>
- "greater_equal" - requires the cell value to be greater than or equal to the
- value defined in the value-attribute
+ "greater_equal" - requires the cell value
+ to be greater than or equal to the value
+ defined in the value-attribute
</listitem>
<listitem>
- "less_equal" - requires the cell value to be less than or equal to the value
+ "less_equal" - requires the cell value to
+ be less than or equal to the value
defined in the value-attribute
</listitem>
<listitem>
- "less_than" - requires the cell value to be less than the value defined in the
+ "less_than" - requires the cell value to
+ be less than the value defined in the
value-attribute
</listitem>
<listitem>
- "not_equal" - requires the cell value to not match the one defined in the
+ "not_equal" - requires the cell value to
+ not match the one defined in the
value-attribute
</listitem>
<listitem>
- "between" - requires the cell value to be between the values defined in the
- value- and value2 attributes
+ "between" - requires the cell value to be
+ between the values defined in the value-
+ and value2 attributes
</listitem>
<listitem>
- "not_between" - requires the cell value not to be between the values defined in
+ "not_between" - requires the cell value
+ not to be between the values defined in
the value- and value2 attributes
</listitem>
</itemizedlist>
@@ -1348,18 +1556,22 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:numericValidation condition="between" value="4" value2="18"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.age">
+ <e:numericValidation condition="between" value="4"
+ value2="18"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>adds numeric validation to a cell specifying that the value must be between 4 and 18.</para>
+ <para>
+ adds numeric validation to a cell specifying that the value must be
+ between 4 and 18.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1379,29 +1591,30 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the range of values to validate against. The value is a
+ —The starting column of the range of
+ values to validate against. The value is a
number.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the range of values to validate against. The value is a
- number.
+ —The starting row of the range of values
+ to validate against. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The ending column of the range of values to validate against. The value is a
- number.
+ —The ending column of the range of values
+ to validate against. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The ending row of the range of values to validate against. The value is a
- number.
+ —The ending row of the range of values to
+ validate against. The value is a number.
</para>
</listitem>
</itemizedlist>
@@ -1432,19 +1645,21 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.position">
- <e:rangeValidation startColumn="0" startRow="0" endColumn="0" endRow="10"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.position">
+ <e:rangeValidation startColumn="0" startRow="0"
+ endColumn="0" endRow="10"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>
- adds validation to a cell specifying that the value must be in the values specified in range A1:A10.
+ adds validation to a cell specifying that the value must be in the
+ values specified in range A1:A10.
</para>
<informaltable>
<tgroup cols="2">
@@ -1474,7 +1689,9 @@
<itemizedlist>
<listitem>
<para>
- <literal>Zero or more list validation items.</literal>
+ <literal>
+ Zero or more list validation items.
+ </literal>
</para>
</listitem>
</itemizedlist>
@@ -1493,7 +1710,10 @@
</tbody>
</tgroup>
</informaltable>
- <para>e:listValidation is a just a container for holding multiple e:listValidationItem tags.</para>
+ <para>
+ e:listValidation is a just a container for holding multiple
+ e:listValidationItem tags.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1544,50 +1764,77 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.position">
- <e:listValidation>
- <e:listValidationItem value="manager"/>
- <e:listValidationItem value="employee"/>
- </e:listValidation>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.position">
+ <e:listValidation>
+ <e:listValidationItem value="manager"/>
+ <e:listValidationItem value="employee"/>
+ </e:listValidation>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>adds validation to a cell specifying that the value must be "manager" or "employee".</para>
+ <para>
+ adds validation to a cell specifying that the value must be
+ "manager" or "employee".
+ </para>
</section>
<section id="excel.cells.formatmasks">
<title>Format masks</title>
<para>
- Format masks are defined in the mask attribute in cell templates, cells or formulas.
- <emphasis>Note that when using templates, the format mask must be placed in the first template</emphasis>
- to be cascaded since the constructor hierarchy in <literal>JExcelAPI</literal> used for copying cell formats makes it hard to
- change the format mask at a later stage. There are two types of format masks, one for numbers and one for
- dates
+ Format masks are defined in the mask attribute in cell templates,
+ cells or formulas. <emphasis>Note that when using templates, the
+ format mask must be placed in the first template</emphasis>
+ to be cascaded since the constructor hierarchy in
+ <literal>JExcelAPI</literal> used for copying cell formats makes
+ it hard to change the format mask at a later stage. There are two
+ types of format masks, one for numbers and one for dates
</para>
<section id="excel.formatmasks.numbers">
<title>Number masks</title>
<para>
- When encountering a format mask, first it is checked if it is in internal form, e.g "format1",
- "accounting_float" and so on (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/writ...">jxl.write.NumberFormats</ulink>).
+ When encountering a format mask, first it is checked if it is in
+ internal form, e.g "format1", "accounting_float" and so on (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/writ...">
+ jxl.write.NumberFormats
+ </ulink>
+ ).
</para>
<para>
- if the mask is not in the list, it is treated as a custom mask (see <ulink url="http://java.sun.com/javase/6/docs/api/java/text/DecimalFormat.html">java.text.DecimalFormat</ulink>).
- e.g "0.00" and automatically converted to the closest match.
+ if the mask is not in the list, it is treated as a custom mask
+ (see
+ <ulink
+ url="http://java.sun.com/javase/6/docs/api/java/text/DecimalFormat.html">
+ java.text.DecimalFormat
+ </ulink>
+ ). e.g "0.00" and automatically converted to the closest match.
</para>
</section>
<section id="excel.formatmasks.dates">
<title>Date masks</title>
<para>
- When encountering a format mask, first it is checked if it is in internal form, e.g "format1", "format2"
- and so on (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/writ...">jxl.write.DecimalFormats</ulink>).
+ When encountering a format mask, first it is checked if it is in
+ internal form, e.g "format1", "format2" and so on (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/writ...">
+ jxl.write.DecimalFormats
+ </ulink>
+ ).
</para>
<para>
- if the mask is not in the list, it is treated as a custom mask (see <ulink url="http://java.sun.com/javase/6/docs/api/java/text/DateFormat.html">java.text.DateFormat</ulink>)., e.g "dd.MM.yyyy" and automatically converted to the closest match.
+ if the mask is not in the list, it is treated as a custom mask
+ (see
+ <ulink
+ url="http://java.sun.com/javase/6/docs/api/java/text/DateFormat.html">
+ java.text.DateFormat
+ </ulink>
+ )., e.g "dd.MM.yyyy" and automatically converted to the closest
+ match.
</para>
</section>
</section>
@@ -1595,43 +1842,53 @@
<section id="excel.formulas">
<title>Formulas</title>
<para>
- Formulas are nested within columns (for iteration) or inside worksheets (for direct placement using the <literal>column</literal> and
- <literal>row</literal> attributes) and add calculations or functions to ranges of cells. They are essentially cells, see <xref linkend="excel.cells"/>
- for available attributes. Note that they can apply templates and have own font definitions
- etc just as normal cells.
+ Formulas are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the <literal>column</literal> and
+ <literal>row</literal> attributes) and add calculations or functions to
+ ranges of cells. They are essentially cells, see
+ <xref linkend="excel.cells" /> for available attributes. Note that they
+ can apply templates and have own font definitions etc just as normal
+ cells.
</para>
<para>
- The formula of the cell in placed in the <literal>value</literal>-attribute as a normal <trademark class="registered">Microsoft</trademark>
- <trademark class="registered">Excel</trademark> spreadsheet application notation. Note that when doing
- cross-sheet formulas, the worksheets must exist before referencing a formula against them. The value is a
- string.
+ The formula of the cell in placed in the <literal>value</literal>
+ -attribute as a normal &excel; notation. Note that when doing
+ cross-sheet formulas, the worksheets must exist before referencing
+ a formula against them. The value is a string.
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="fooTemplate">
- <e:font color="red"/>
- </e:cellTemplate>
- <e:worksheet name="fooSheet">
- <e:cell column="0" row="0" value="1"/>
- </e:worksheet>
- <e:worksheet name="barSheet">
- <e:cell column="0" row="0" value="2"/>
- <e:formula column="0" row="1"
- value="fooSheet!A1+barSheet1!A1"
- templates="fooTemplate">
- <e:font fontSize="12"/>
- </e:formula>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:cellTemplate name="fooTemplate">
+ <e:font color="red"/>
+ </e:cellTemplate>
+ <e:worksheet name="fooSheet">
+ <e:cell column="0" row="0" value="1"/>
+ </e:worksheet>
+ <e:worksheet name="barSheet">
+ <e:cell column="0" row="0" value="2"/>
+ <e:formula column="0" row="1"
+ value="fooSheet!A1+barSheet1!A1"
+ templates="fooTemplate">
+ <e:font fontSize="12"/>
+ </e:formula>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines an formula in B2 summing cells A1 in worksheets FooSheet and BarSheet</para>
+ <para>
+ defines an formula in B2 summing cells A1 in worksheets FooSheet and
+ BarSheet
+ </para>
</section>
<section id="excel.images">
<title>Images</title>
- <para>Images are nested within columns (for iteration) or inside worksheets (for direct placement using the
- <literal>startColumn/startRow</literal> and <literal>endColumn/endRow</literal> attributes)</para>
+ <para>
+ Images are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the <literal>startColumn/startRow</literal>
+ and <literal>endColumn/endRow</literal>
+ attributes)
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1651,35 +1908,42 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the image. The default is the internal counter. The value is
- a number. Note that the value is 0-based.
+ —The starting column of the image. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the image. The default is the internal counter. The value is a
- number. Note that the value is 0-based.
+ —The starting row of the image. The default
+ is the internal counter. The value is a number.
+ Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>columnSpan</literal>
- —The column span of the image. The default is one resulting in the default width of
- the image. The value is a number. Note that the value is 0-based.
+ —The column span of the image. The default
+ is one resulting in the default width of the
+ image. The value is a number. Note that the value
+ is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>rowSpan</literal>
- —The row span of the image. The default is the one resulting in the default height
- of the image. The value is a number. Note that the value is 0-based.
+ —The row span of the image. The default is
+ the one resulting in the default height of the
+ image. The value is a number. Note that the value
+ is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>URI</literal>
- —The URI to the image. The value is a string.
+ —The URI to the image. The value is a
+ string.
</para>
</listitem>
</itemizedlist>
@@ -1710,20 +1974,26 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:image startRow="0" startColumn="0" rowSpan="4" columnSpan="4" URI="http://foo.org/logo.jpg"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:image startRow="0" startColumn="0" rowSpan="4"
+ columnSpan="4" URI="http://foo.org/logo.jpg"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>defines an image in A1:E5 based on the given data</para>
</section>
<section id="excel.hyperlinks">
<title>Hyperlinks</title>
- <para>Hyperlinks are nested within columns (for iteration) or inside worksheets (for direct placement using the
- <literal>startColumn/startRow</literal> and <literal>endColumn/endRow</literal> attributes). They add link navigation to URIs</para>
+ <para>
+ Hyperlinks are nested within columns (for iteration) or inside
+ worksheets (for direct placement using the
+ <literal>startColumn/startRow</literal> and
+ <literal>endColumn/endRow</literal> attributes). They add link
+ navigation to URIs
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1743,29 +2013,33 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the hyperlink. The default is the internal counter. The
- value is a number. Note that the value is 0-based.
+ —The starting column of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the hyperlink. The default is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The starting row of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The ending column of the hyperlink. The default is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The ending column of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The ending row of the hyperlink. The default is the internal counter. The value is
- a number. Note that the value is 0-based.
+ —The ending row of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
@@ -1777,7 +2051,8 @@
<listitem>
<para>
<literal>description</literal>
- —The description of the link. The value is a string.
+ —The description of the link. The value is a
+ string.
</para>
</listitem>
</itemizedlist>
@@ -1808,21 +2083,25 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:hyperLink startRow="0" startColumn="0" endRow="4" endColumn="4"
- URL="http://seamframework.org" description="The Seam Framework"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:hyperLink startRow="0" startColumn="0" endRow="4"
+ endColumn="4" URL="http://seamframework.org"
+ description="The Seam Framework"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines a described hyperlink pointing to SFWK in the area A1:E5</para>
+ <para>
+ defines a described hyperlink pointing to SFWK in the area A1:E5
+ </para>
</section>
<section id="excel.headersfooters">
<title>Headers and footers</title>
<para>
- Headers and footers are childrens of worksheets and worksheet templates and parents of header and footer commands
- They add headers and footers to printed worksheets.
+ Headers and footers are childrens of worksheets and worksheet templates
+ and parents of header and footer commands They add headers and footers
+ to printed worksheets.
</para>
<informaltable>
<tgroup cols="2">
@@ -1843,8 +2122,8 @@
<listitem>
<para>
<literal>type</literal>
- —The type of the header or footer. The value is string that can be either "header"
- or "footer".
+ —The type of the header or footer. The value
+ is string that can be either "header" or "footer".
</para>
</listitem>
</itemizedlist>
@@ -1865,19 +2144,22 @@
<listitem>
<para>
<literal>left</literal>
- —The contents of the left header/footer part.
+ —The contents of the left header/footer
+ part.
</para>
</listitem>
<listitem>
<para>
<literal>center</literal>
- —The contents of the center header/footer part.
+ —The contents of the center header/footer
+ part.
</para>
</listitem>
<listitem>
<para>
<literal>right</literal>
- —The contents of the right header/footer part.
+ —The contents of the right header/footer
+ part.
</para>
</listitem>
</itemizedlist>
@@ -1887,7 +2169,9 @@
</tgroup>
</informaltable>
<para>
- The <literal><e:headerFooterCommands></literal> is just a nesting container in order to support multiple header/footer commands.
+ The <literal><e:headerFooterCommands></literal>
+ is just a nesting container in order to support multiple header/footer
+ commands.
</para>
<informaltable>
<tgroup cols="2">
@@ -1916,9 +2200,7 @@
</para>
<itemizedlist>
<listitem>
- <para>
- Zero or more header/footer commands.
- </para>
+ <para>Zero or more header/footer commands.</para>
</listitem>
</itemizedlist>
<para>
@@ -1936,8 +2218,10 @@
</tbody>
</tgroup>
</informaltable>
- <para>Header/footer commands adds actual commands to the header or footer in the location where the
- containing facet points.</para>
+ <para>
+ Header/footer commands adds actual commands to the header or footer in
+ the location where the containing facet points.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1957,33 +2241,67 @@
<listitem>
<para>
<literal>command</literal>
- —The command to execute. The value is a string
+ —The command to execute. The value is a
+ string
<itemizedlist>
<listitem>
"append" - appends the text in the
<literal>parameter</literal>
</listitem>
- <listitem>"date" - appends the current date</listitem>
- <listitem>"page_number" - appends the page number</listitem>
+ <listitem>
+ "date" - appends the current date
+ </listitem>
+ <listitem>
+ "page_number" - appends the page number
+ </listitem>
<listitem>"time" - appends the time</listitem>
- <listitem>"total_pages" - appends the total page count</listitem>
- <listitem>"workbook_name" - appends the workbook name</listitem>
- <listitem>"worksheet_name" - appends the worksheet name</listitem>
- <listitem>"toggle_bold" - toggles bold font</listitem>
- <listitem>"toggle_italics" - toggles italics</listitem>
- <listitem>"toggle_double_underline" - toggles double underlining</listitem>
- <listitem>"toggle_outline" - toggles outline</listitem>
- <listitem>"toggle_shadow" - toggles shadow</listitem>
- <listitem>"toggle_strikethrough" - toggles strikethrough</listitem>
- <listitem>"toggle_subscript" - toggles subscript</listitem>
- <listitem>"toggle_superscript" - toggles superscript</listitem>
- <listitem>"toggle_underline" - toggles underline</listitem>
<listitem>
- "font_name" - sets the font name given in the
+ "total_pages" - appends the total page count
+ </listitem>
+ <listitem>
+ "workbook_name" - appends the workbook name
+ </listitem>
+ <listitem>
+ "worksheet_name" - appends the worksheet
+ name
+ </listitem>
+ <listitem>
+ "toggle_bold" - toggles bold font
+ </listitem>
+ <listitem>
+ "toggle_italics" - toggles italics
+ </listitem>
+ <listitem>
+ "toggle_double_underline" - toggles double
+ underlining
+ </listitem>
+ <listitem>
+ "toggle_outline" - toggles outline
+ </listitem>
+ <listitem>
+ "toggle_shadow" - toggles shadow
+ </listitem>
+ <listitem>
+ "toggle_strikethrough" - toggles
+ strikethrough
+ </listitem>
+ <listitem>
+ "toggle_subscript" - toggles subscript
+ </listitem>
+ <listitem>
+ "toggle_superscript" - toggles superscript
+ </listitem>
+ <listitem>
+ "toggle_underline" - toggles underline
+ </listitem>
+ <listitem>
+ "font_name" - sets the font name given in
+ the
<literal>parameter</literal>
</listitem>
<listitem>
- "font_size" - sets the font size given in the
+ "font_size" - sets the font size given in
+ the
<literal>parameter</literal>
</listitem>
</itemizedlist>
@@ -1992,10 +2310,13 @@
<listitem>
<para>
<literal>parameter</literal>
- —The parameter for some commands. Used by the font_name, font_size and append
- commands. The font_name parameter is a string that represents the requested font name, the
- font_size parameter is a number that represents the requested font size and the append
- parameter is a string of text to be appended to the header/footer.
+ —The parameter for some commands. Used by
+ the font_name, font_size and append commands. The
+ font_name parameter is a string that represents
+ the requested font name, the font_size parameter
+ is a number that represents the requested font
+ size and the append parameter is a string of text
+ to be appended to the header/footer.
</para>
</listitem>
</itemizedlist>
@@ -2026,17 +2347,17 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:headerFooter type="header">
- <f:facet name="left">
- <e:headerFooterCommands>
- <e:headerFooterCommand command="page_number"/>
- </e:headerFooterCommands>
- </f:facet>
- </e:headerFooter>
- <e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:headerFooter type="header">
+ <f:facet name="left">
+ <e:headerFooterCommands>
+ <e:headerFooterCommand command="page_number"/>
+ </e:headerFooterCommands>
+ </f:facet>
+ </e:headerFooter>
+ <e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>Defines a header with the page number in the left corner.</para>
@@ -2044,7 +2365,8 @@
<section id="excel.printareatitles">
<title>Print areas and titles</title>
<para>
- Print areas and titles childrens of worksheets and worksheet templates and provide... print areas and titles.
+ Print areas and titles childrens of worksheets and worksheet templates
+ and provide... print areas and titles.
</para>
<informaltable>
<tgroup cols="2">
@@ -2065,25 +2387,33 @@
<listitem>
<para>
<literal>firstColumn</literal>
- —The column of the top-left corner of the area. The parameter is a number. Note that the value is 0-based.
+ —The column of the top-left corner of the
+ area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>firstRow</literal>
- —The row of the top-left corner of the area. The parameter is a number. Note that the value is 0-based.
+ —The row of the top-left corner of the area.
+ The parameter is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>lastColumn</literal>
- —The column of the bottom-right corner of the area. The parameter is a number. Note that the value is 0-based.
+ —The column of the bottom-right corner of
+ the area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>lastRow</literal>
- —The row of the bottom-right corner of the area. The parameter is a number. Note that the value is 0-based.
+ —The row of the bottom-right corner of the
+ area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2114,24 +2444,29 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:printTitles firstRow="0" firstColumn="0" lastRow="0" lastColumn="9"/>
- <e:printArea firstRow="1" firstColumn="0" lastRow="9" lastColumn="9"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:printTitles firstRow="0" firstColumn="0"
+ lastRow="0" lastColumn="9"/>
+ <e:printArea firstRow="1" firstColumn="0"
+ lastRow="9" lastColumn="9"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines a print title between A1:A10 and a print area between B2:J10.</para>
+ <para>
+ defines a print title between A1:A10 and a print area between B2:J10.
+ </para>
</section>
<section id="excel.worksheetcommands">
<title>Worksheet Commands</title>
- <para>Worksheet commands are children of workbooks and are usually executed only once.</para>
+ <para>
+ Worksheet commands are children of workbooks and are usually executed
+ only once.
+ </para>
<section id="excel.worksheetcommands.grouping">
<title>Grouping</title>
- <para>
- Provides grouping of columns and rows.
- </para>
+ <para>Provides grouping of columns and rows.</para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -2151,19 +2486,24 @@
<listitem>
<para>
<literal>startRow</literal>
- —The row to start the grouping at. The value is a number. Note that the value is 0-based.
+ —The row to start the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The row to end the grouping at. The value is a number. Note that the value is 0-based.
+ —The row to end the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>collapse</literal>
- —Should the grouping be collapsed initially? The value is a boolean.
+ —Should the grouping be collapsed
+ initially? The value is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -2211,19 +2551,24 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The column to start the grouping at. The value is a number. Note that the value is 0-based.
+ —The column to start the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The column to end the grouping at. The value is a number. Note that the value is 0-based.
+ —The column to end the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>collapse</literal>
- —Should the grouping be collapsed initially? The value is a boolean.
+ —Should the grouping be collapsed
+ initially? The value is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -2255,17 +2600,17 @@
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:groupRows startRow="4" endRow="9" collapse="true"/>
- <e:groupColumns startColumn="0" endColumn="9" collapse="false"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:groupRows startRow="4" endRow="9" collapse="true"/>
+ <e:groupColumns startColumn="0" endColumn="9" collapse="false"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- groups rows 5 trough 10 and columns 5 through 10 so that the rows are initially collapsed (but not the
- columns).
+ groups rows 5 trough 10 and columns 5 through 10 so that the rows
+ are initially collapsed (but not the columns).
</para>
</section>
@@ -2291,7 +2636,8 @@
<listitem>
<para>
<literal>row</literal>
- —The row to break at. The value is a number. Note that the value is 0-based.
+ —The row to break at. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2322,11 +2668,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:rowPageBreak row="4"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:rowPageBreak row="4"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>breaks page at row 5.</para>
@@ -2353,25 +2699,32 @@
<listitem>
<para>
<literal>startRow</literal>
- —The row to start the merging from. The value is a number. Note that the value is 0-based.
+ —The row to start the merging from. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startColumn</literal>
- —The column to start the merging from. The value is a number. Note that the value is 0-based.
+ —The column to start the merging from.
+ The value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The row to end the merging at. The value is a number. Note that the value is 0-based.
+ —The row to end the merging at. The value
+ is a number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The column to end the merging at. The value is a number. Note that the value is 0-based.
+ —The column to end the merging at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2402,11 +2755,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:mergeCells startRow="0" startColumn="0" endRow="9" endColumn="9"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:mergeCells startRow="0" startColumn="0" endRow="9" endColumn="9"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>merges the cells in the range A1:J10</para>
@@ -2415,95 +2768,106 @@
<section id="excel.templates">
<title>Templates</title>
<para>
- Templates are a way of grouping common formatting under a name to be used later. They come in two flavors, cell
- level and worksheet settings level and they can be cascaded so that the end result is a union of the applied
- templates (overriden where applicable)
+ Templates are a way of grouping common formatting under a name to be
+ used later. They come in two flavors, cell level and worksheet settings
+ level and they can be cascaded so that the end result is a union of the
+ applied templates (overriden where applicable)
</para>
<section id="excel.templates.cell">
<title>Cell templates</title>
- <para>Cell templates are defined on workbook level using the following notation</para>
+ <para>
+ Cell templates are defined on workbook level using the following
+ notation
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="foo">
- <font color="red"/>
- </e:cellTemplate>
-</e:workbook>
+ <e:workbook>
+ <e:cellTemplate name="foo">
+ <font color="red"/>
+ </e:cellTemplate>
+ </e:workbook>
]]>
</programlisting>
- <para>and are later used by referencing them in the templates attribute of a cell</para>
+ <para>
+ and are later used by referencing them in the templates attribute of
+ a cell
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell templates="foo" column="0" row="0" value="ping"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell templates="foo" column="0" row="0" value="ping"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- Cell templates have the same attributes as cells (see <xref linkend="excel.cells"/>). Note
- that the cellTemplate can also contain tags for font, border and background definitions and they are merged
- with the definitions of the cell using the templates so a more complex definition could look like
+ Cell templates have the same attributes as cells (see
+ <xref linkend="excel.cells" />
+ ). Note that the cellTemplate can also contain tags for font, border
+ and background definitions and they are merged with the definitions
+ of the cell using the templates so a more complex definition could
+ look like
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="foo" alignment="right">
- <e:font name="Times New Roman"/>
- <e:background color="blue"/>
- </e:cellTemplate>
+ <e:workbook>
+ <e:cellTemplate name="foo" alignment="right">
+ <e:font name="Times New Roman"/>
+ <e:background color="blue"/>
+ </e:cellTemplate>
- <e:cellTemplate name="bar" wrap="true">
- <e:font color="red"/>
- <e:border color="yellow" lineStyle="thick"/>
- </e:cellTemplate>
-</e:workbook>
+ <e:cellTemplate name="bar" wrap="true">
+ <e:font color="red"/>
+ <e:border color="yellow" lineStyle="thick"/>
+ </e:cellTemplate>
+ </e:workbook>
]]>
</programlisting>
<para>so that a cell that later on applies the templates</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell templates="foo,bar" column="0" row="0" value="ping">
- <e:border border="left" color="green" lineStyle="thin"/>
- </e:cell>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell templates="foo,bar" column="0" row="0" value="ping">
+ <e:border border="left" color="green" lineStyle="thin"/>
+ </e:cell>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- end up with a red Times New Roman font in a right-aligned, wrapping cell that has a solid blue background
- and thick yellow borders, with exception of the left border, which is thin and green.
+ end up with a red Times New Roman font in a right-aligned, wrapping
+ cell that has a solid blue background and thick yellow borders, with
+ exception of the left border, which is thin and green.
</para>
</section>
<section id="excel.templates.worksheetsettings">
<title>Worksheet setting templates</title>
<para>
- Worksheet settings are defined and used in the same way as cell templates. On workbook level, you can place
- a
+ Worksheet settings are defined and used in the same way as cell
+ templates. On workbook level, you can place a
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:worksheetTemplate name="foo" horizontalFreeze="5"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheetTemplate name="foo" horizontalFreeze="5"/>
+ </e:workbook>
]]>
</programlisting>
<para>and when you later use it like</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet templates="foo" verticalFreeze="5"/>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet templates="foo" verticalFreeze="5"/>
+ </e:workbook>
]]>
</programlisting>
<para>
- you end up with a worksheet that is frozen at column 5 and row 5. Note that a worksheetTemplate is
- essentially a named worksheet (see <xref linkend="excel.worksheet"/>).
+ you end up with a worksheet that is frozen at column 5 and row 5.
+ Note that a worksheetTemplate is essentially a named worksheet (see
+ <xref linkend="excel.worksheet" />
+ ).
</para>
</section>
@@ -2511,61 +2875,68 @@
<section id="excel.datatableexporter">
<title>Datatable exporter</title>
<para>
- If you prefer to export an existing JSF datatable instead of writing a dedicated XHTML document, this can also
- be achieved easily by executing the
- <literal>org.jboss.seam.excel.excelExporter.export</literal>
- component, passing in the id of the datatable as an Seam EL parameter. Consider you have a data table
+ If you prefer to export an existing JSF datatable instead of writing a
+ dedicated XHTML document, this can also be achieved easily by executing
+ the <literal>org.jboss.seam.excel.excelExporter.export</literal>
+ component, passing in the id of the datatable as an Seam EL parameter.
+ Consider you have a data table
</para>
<programlisting role="XML">
<![CDATA[
-<h:form id="theForm">
- <h:dataTable id="theDataTable" value="#{personList.personList}" var="person">
- ...
- </h:dataTable>
-</h:form>
+ <h:form id="theForm">
+ <h:dataTable id="theDataTable" value="#{personList.personList}"
+ var="person">
+ ...
+ </h:dataTable>
+ </h:form>
]]>
</programlisting>
- <para>that you want to view as an <trademark class="registered">Microsoft</trademark> <trademark class="registered">Excel</trademark>
- spreadsheet. Place a</para>
+ <para>
+ that you want to view as an
+ <trademark class="registered">Microsoft</trademark>
+ <trademark class="registered">Excel</trademark>
+ spreadsheet. Place a
+ </para>
<programlisting role="XML">
<![CDATA[
-<h:commandLink
- value="Export"
- action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}"
-/>
- ]]>
+ <h:commandLink
+ value="Export"
+ action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}"
+ />
+ ]]>
</programlisting>
<para>
- in the form and you're done. You can of course execute the exporter with a button, s:link or other preferred
- method. There are also plans for a dedicated export tag that can be placed inside the datatable tag so you
- won't have to refer to the datatable by ID.
+ in the form and you're done. You can of course execute the exporter
+ with a button, s:link or other preferred method. There are also plans
+ for a dedicated export tag that can be placed inside the datatable tag
+ so you won't have to refer to the datatable by ID.
</para>
<section id="excel.datatableexporter.css">
<title>CSS</title>
<para>
- In order to provide formatting for the spreadsheet, you can utilize a number of xls-prefixed CSS:ish
- attributes that are placed in the style-attribute of the datatable to be exported:
+ In order to provide formatting for the spreadsheet, you can utilize
+ a number of xls-prefixed CSS:ish attributes that are placed in the
+ style-attribute of the datatable to be exported:
</para>
<programlisting role="XML">
<![CDATA[
-<h:form id="theForm">
- <h:dataTable
- id="theDataTable"
- value="#{personList.personList}"
- var="person"
- style="xlsFontName : Times New Roman; xlsBackgroundColor : red">
- ...
- </h:dataTable>
-</h:form>
+ <h:form id="theForm">
+ <h:dataTable
+ id="theDataTable"
+ value="#{personList.personList}"
+ var="person"
+ style="xlsFontName : Times New Roman; xlsBackgroundColor : red">
+ ...
+ </h:dataTable>
+ </h:form>
]]>
</programlisting>
<para>
- which sets Times New Roman as the font and red as the cell background. Just as in CSS, separate name and
- value with a
- <literal>:</literal>
- and multiple attributes with a
- <literal>;</literal>
- . Below is a list of the supported style-attributes:
+ which sets Times New Roman as the font and red as the cell
+ background. Just as in CSS, separate name and value with a
+ <literal>:</literal> and multiple attributes with a
+ <literal>;</literal>. Below is a list of the supported
+ style-attributes:
</para>
<informaltable>
<tgroup cols="2">
@@ -2593,7 +2964,14 @@
<para>xlsFontColor</para>
</entry>
<entry valign="top">
- <para>The color of the font (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The color of the font (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2601,7 +2979,10 @@
<para>xlsFontBold</para>
</entry>
<entry valign="top">
- <para>Should the font be bold? Valid values are "true" and "false"</para>
+ <para>
+ Should the font be bold? Valid values are "true" and
+ "false"
+ </para>
</entry>
</row>
<row>
@@ -2609,7 +2990,10 @@
<para>xlsFontItalic</para>
</entry>
<entry valign="top">
- <para>Should the font be italic? Valid values are "true" and "false"</para>
+ <para>
+ Should the font be italic? Valid values are "true"
+ and "false"
+ </para>
</entry>
</row>
<row>
@@ -2617,7 +3001,14 @@
<para>xlsFontScriptStyle</para>
</entry>
<entry valign="top">
- <para>The script style of the font (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.ScriptStyle</ulink>).</para>
+ <para>
+ The script style of the font (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.ScriptStyle
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2625,7 +3016,10 @@
<para>xlsFontStruckOut</para>
</entry>
<entry valign="top">
- <para>Should the font be struck out? Valid values are "true" and "false"</para>
+ <para>
+ Should the font be struck out? Valid values are
+ "true" and "false"
+ </para>
</entry>
</row>
<row>
@@ -2633,7 +3027,14 @@
<para>xlsFontUnderlineStyle</para>
</entry>
<entry valign="top">
- <para>The underline style of the font (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.UnderlineStyle</ulink>).</para>
+ <para>
+ The underline style of the font (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.UnderlineStyle
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2641,7 +3042,14 @@
<para>xlsBackgroundColor</para>
</entry>
<entry valign="top">
- <para>The background color of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The background color of the cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2649,7 +3057,14 @@
<para>xlsBackgroundPattern</para>
</entry>
<entry valign="top">
- <para>The background pattern of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Pattern</ulink>).</para>
+ <para>
+ The background pattern of the cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Pattern
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2657,7 +3072,14 @@
<para>xlsAlignment</para>
</entry>
<entry valign="top">
- <para>The alignment of the cell value (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Alignment</ulink>).</para>
+ <para>
+ The alignment of the cell value (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Alignment
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2666,24 +3088,22 @@
</entry>
<entry valign="top">
<para>
- The column widths. Note that the unit is internal to the <trademark class="registered">Microsoft</trademark>
- <trademark class="registered">Excel</trademark> spreadsheet file format, be prepared to use largeish numbers.
- Separate columns with a
- <literal>,</literal>
- and use
- <literal>*</literal>
- for not setting a value.
+ The column widths. Note that the unit is internal to
+ &excel;, be prepared to use largeish numbers.
+ Separate columns with a <literal>,</literal>
+ and use <literal>*</literal> for not setting a value.
</para>
<programlisting role="XML">
<![CDATA[
-<h:dataTable style="xlsColumnWidths : *,800">
- ...
-</h:dataTable>
-]]>
+ <h:dataTable style="xlsColumnWidths : *,800">
+ ...
+ </h:dataTable>
+ ]]>
</programlisting>
<para>
- leaves the width on column 1 as default, sets the width of column 2 to 800 and leaves the
- rest of the columns (if any) as default.
+ leaves the width on column 1 as default, sets the
+ width of column 2 to 800 and leaves the rest of the
+ columns (if any) as default.
</para>
</entry>
</row>
@@ -2692,7 +3112,14 @@
<para>xlsBorderColor</para>
</entry>
<entry valign="top">
- <para>The the border color of the entire cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border color of the entire cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2700,7 +3127,15 @@
<para>xlsBorderColorLeft</para>
</entry>
<entry valign="top">
- <para>The the border color of the left edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border color of the left edge of the cell
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2708,7 +3143,14 @@
<para>xlsBorderColorTop</para>
</entry>
<entry valign="top">
- <para>The the border color of the top edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border color of the top edge of the cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2716,7 +3158,15 @@
<para>xlsBorderColorRight</para>
</entry>
<entry valign="top">
- <para>The the border color of the right edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border color of the right edge of the cell
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2724,7 +3174,15 @@
<para>xlsBorderColorBottom</para>
</entry>
<entry valign="top">
- <para>The the border color of the bottom edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border color of the bottom edge of the cell
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2732,7 +3190,14 @@
<para>xlsBorderLineStyle</para>
</entry>
<entry valign="top">
- <para>The the border line style of the entire cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).</para>
+ <para>
+ The the border line style of the entire cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2741,7 +3206,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the left edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
+ The the border line style of the left edge of the
+ cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</entry>
</row>
@@ -2751,7 +3222,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the top edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
+ The the border line style of the top edge of the cell
+ (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</entry>
</row>
@@ -2761,8 +3238,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the right edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
- styles
+ The the border line style of the right edge of the
+ cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ). styles
</para>
</entry>
</row>
@@ -2772,8 +3254,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the bottom edge of the cell (see <ulink url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">jxl.format.Colour</ulink>).
- styles
+ The the border line style of the bottom edge of the
+ cell (see
+ <ulink
+ url="http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/form...">
+ jxl.format.Colour
+ </ulink>
+ ). styles
</para>
</entry>
</row>
@@ -2784,46 +3271,50 @@
<section id="excel.datatableexporter.templates">
<title>Templates</title>
<para>
- In order to provide different formatting for different kind of cells you can use templates. Templates are
- defined in the datatable style attribute as seen in the examples in the previous section by using a
- dot-notation on the xls-attribute names. Attributes without template names are considered global and are
- applied to all cells.
+ In order to provide different formatting for different kind of cells
+ you can use templates. Templates are defined in the datatable style
+ attribute as seen in the examples in the previous section by using a
+ dot-notation on the xls-attribute names. Attributes without template
+ names are considered global and are applied to all cells.
</para>
<para>
- Templates are used by referring to them in the style attribute of the UIOutput using the xlsTemplates
- attribute. If you wish to cascade several templates, separate them with a
+ Templates are used by referring to them in the style attribute of
+ the UIOutput using the xlsTemplates attribute. If you wish to
+ cascade several templates, separate them with a
<literal>,</literal>
.
</para>
<programlisting role="XML">
<![CDATA[
-<h:dataTable style="xlsFontName : Times New Roman; xlsFontColor.foo : blue;
- xlsFontColor.bar : red; xlsFontBold.tar : true">
- <h:column>
- <h:outputText style="xlsTemplates : foo"/>
- </h:column>
- <h:column>
- <h:outputText style="xlsTemplates : bar,tar"/>
- </h:column>
-</h:dataTable>
-]]>
+ <h:dataTable style="xlsFontName : Times New Roman; xlsFontColor.foo : blue;
+ xlsFontColor.bar : red; xlsFontBold.tar : true">
+ <h:column>
+ <h:outputText style="xlsTemplates : foo"/>
+ </h:column>
+ <h:column>
+ <h:outputText style="xlsTemplates : bar,tar"/>
+ </h:column>
+ </h:dataTable>
+ ]]>
</programlisting>
<para>
- results in the first column being Times New Roman, blue and the second column being Times New Roman red
- bold.
+ results in the first column being Times New Roman, blue and the
+ second column being Times New Roman red bold.
</para>
</section>
</section>
<section id="excel.links">
<title>Links and further documentation</title>
<para>
- The core of the <trademark class="registered">Microsoft</trademark> <trademark class="registered">Excel</trademark> spreadsheet
- functionality is based on the excellent JExcelAPI library which can be found on
- http://jexcelapi.sourceforge.net/ and most features and possible limitations are inherited from here.
+ The core of the &excel; functionality is based on the excellent
+ JExcelAPI library which can be found on
+ http://jexcelapi.sourceforge.net/ and most features and possible
+ limitations are inherited from here.
</para>
<para>
- If you use the forum or mailing list, please remember that they don't know anything about Seam and the usage of
- their library, any issues are best reported in the JBoss Seam JIRA under the "excel" module.
+ If you use the forum or mailing list, please remember that they don't
+ know anything about Seam and the usage of their library, any issues are
+ best reported in the JBoss Seam JIRA under the "excel" module.
</para>
</section>
</chapter>
15 years, 9 months
- 1
- 0
Seam SVN: r8631 - trunk/src/excel/org/jboss/seam/excel/jxl.
by seam-commits＠lists.jboss.org
Author: nickarls
Date: 2008-08-08 04:28:15 -0400 (Fri, 08 Aug 2008)
New Revision: 8631
Modified:
trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java
Log:
JBSEAM-3235 : Remove missing template WARN when using datatable exporter. log level stays same but only warns when in xhtml-mode usage.
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java 2008-08-08 08:12:12 UTC (rev 8630)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java 2008-08-08 08:28:15 UTC (rev 8631)
@@ -207,7 +207,9 @@
if (cellTemplate == null)
{
String validNames = getValidTemplateNames(cellTemplates.keySet());
- log.trace(Interpolator.instance().interpolate("Could not find cell template {0}, try {1}", templateName, validNames));
+ if (!"".equals(validNames)) {
+ log.warn(Interpolator.instance().interpolate("Could not find cell template {0}, try {1}", templateName, validNames));
+ }
}
else
{
15 years, 9 months
- 1
- 0
Seam SVN: r8630 - trunk/src/excel/org/jboss/seam/excel/jxl.
by seam-commits＠lists.jboss.org
Author: danielc.roth
Date: 2008-08-08 04:12:12 -0400 (Fri, 08 Aug 2008)
New Revision: 8630
Modified:
trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java
trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java
Log:
JBSEAM-3232 JBSEAM-3235 and changed so that we don't swallow exceptions
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java 2008-08-08 06:08:31 UTC (rev 8629)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/JXLExcelFactory.java 2008-08-08 08:12:12 UTC (rev 8630)
@@ -203,7 +203,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Page orientation {0} not supported, try {1}", orientation, getValidConstants(JXL_PAGE_ORIENTATION_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -226,7 +226,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Page size {0} not supported, try {1}", paperSize, getValidConstants(JXL_PAPER_SIZE_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -743,7 +743,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Verical alignment {0} not supported, try {1}", verticalAlignment, getValidConstants(JXL_VERTICAL_ALIGNMENT_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -769,7 +769,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Orientation {0} not supported, try {1}", orientation, getValidConstants(JXL_ORIENTATION_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -795,7 +795,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Alignment {0} not supported, try {1}", alignment, getValidConstants(JXL_ALIGNMENT_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -821,7 +821,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Pattern {0} not supported, try {1}", pattern, getValidConstants(JXL_PATTERN_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -847,7 +847,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Border line style {0} not supported, try {1}", borderLineStyle, getValidConstants(JXL_BORDER_LINE_STYLE_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -873,7 +873,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Border {0} not supported, try {1}", border, getValidConstants(JXL_BORDER_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -899,7 +899,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Underline style {0} not supported, try {1}", underlineStyle, getValidConstants(JXL_UNDERLINE_STYLE_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -925,7 +925,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Script style {0} not supported, try {1}", scriptStyle, getValidConstants(JXL_SCRIPT_STYLE_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
@@ -957,7 +957,7 @@
catch (Exception e)
{
String message = Interpolator.instance().interpolate("Color {0} not supported, try {1}", color, getValidConstants(JXL_COLOR_CLASS_NAME));
- throw new ExcelWorkbookException(message);
+ throw new ExcelWorkbookException(message, e);
}
}
Modified: trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java
===================================================================
--- trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java 2008-08-08 06:08:31 UTC (rev 8629)
+++ trunk/src/excel/org/jboss/seam/excel/jxl/JXLTemplates.java 2008-08-08 08:12:12 UTC (rev 8630)
@@ -207,7 +207,7 @@
if (cellTemplate == null)
{
String validNames = getValidTemplateNames(cellTemplates.keySet());
- log.warn(Interpolator.instance().interpolate("Could not find cell template {0}, try {1}", templateName, validNames));
+ log.trace(Interpolator.instance().interpolate("Could not find cell template {0}, try {1}", templateName, validNames));
}
else
{
15 years, 9 months
- 1
- 0