Author: manaRH Date: 2012-03-14 13:52:52 -0400 (Wed, 14 Mar 2012) New Revision: 14404 Added: branches/community/Seam_2_3/examples-ee6/excel/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/pom.xml branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/META-INF/ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/META-INF/jboss-deployment-structure.xml branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/pom.xml branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/excel/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/excel/ExcelTest.java branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/ejb-jar.xml branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/persistence.xml branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/seam.properties branches/community/Seam_2_3/examples-ee6/excel/excel-tests/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/pom.xml branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/RenderTest.java branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/selenium/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/selenium/SeleniumExcelTest.java branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/testng.xml branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/arquillian.xml branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/testng.xml branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/WEB-INF/ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/WEB-INF/components.xml branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/seam.properties branches/community/Seam_2_3/examples-ee6/excel/excel-web/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/pom.xml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/components.xml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/faces-config.xml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/pages.xml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/web.xml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/css/ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/css/screen.css branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/home.xhtml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/index.html branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/people.xhtml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/repeat.xhtml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/simple.xhtml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-csv.xhtml branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-jxl.xhtml branches/community/Seam_2_3/examples-ee6/excel/features.txt branches/community/Seam_2_3/examples-ee6/excel/pom.xml branches/community/Seam_2_3/examples-ee6/excel/readme.txt Modified: branches/community/Seam_2_3/examples-ee6/pom.xml Log: JBSEAM-4852 add the ee6 excel example update the excel readme.txt Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ear/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ear/pom.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,75 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <artifactId>excel</artifactId> + <groupId>org.jboss.seam.examples-ee6</groupId> + <version>2.3.0.Beta1-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>excel-ear</artifactId> + <packaging>ear</packaging> + <name>Excel EAR Module (EE6)</name> + + <dependencies> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-web</artifactId> + <type>war</type> + </dependency> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ejb</artifactId> + <type>ejb</type> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam</artifactId> + <type>ejb</type> + <scope>compile</scope> + <exclusions> + <exclusion> + <groupId>com.thoughtworks.xstream</groupId> + <artifactId>xstream</artifactId> + </exclusion> + <exclusion> + <groupId>xpp3</groupId> + <artifactId>xpp3_min</artifactId> + </exclusion> + </exclusions> + </dependency> + </dependencies> + + <build> + <finalName>seam-excel</finalName> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-ear-plugin</artifactId> + <configuration> + <version>6</version> + <defaultLibBundleDir>lib</defaultLibBundleDir> + <!-- Exclude eclipse generated application.xml and manually modified jboss-app.xml during mvn build --> + <earSourceExcludes>**/application.xml, **/jboss-app.xml</earSourceExcludes> + <!-- use maven generated application.xml instead --> + <generateApplicationXml>true</generateApplicationXml> + <filtering>true</filtering> + <modules> + <webModule> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-web</artifactId> + <contextRoot>/seam-excel</contextRoot> + <bundleFileName>excel-web.war</bundleFileName> + </webModule> + <ejbModule> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ejb</artifactId> + <bundleFileName>excel-ejb.jar</bundleFileName> + </ejbModule> + </modules> + </configuration> + </plugin> + </plugins> + </build> +</project> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/META-INF/jboss-deployment-structure.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/META-INF/jboss-deployment-structure.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ear/src/main/application/META-INF/jboss-deployment-structure.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,9 @@ +<jboss-deployment-structure xmlns="urn:jboss:deployment-structure:1.0"> + <deployment> + <dependencies> +<!-- <module name="org.antlr" export="true"/>--> + <module name="org.dom4j" export="true"/> + <module name="javax.faces.api" export="true"/> + </dependencies> + </deployment> +</jboss-deployment-structure> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/pom.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,53 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <artifactId>excel</artifactId> + <groupId>org.jboss.seam.examples-ee6</groupId> + <version>2.3.0.Beta1-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>excel-ejb</artifactId> + <packaging>ejb</packaging> + <name>Excel EJB Module (EE6)</name> + + <dependencies> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam</artifactId> + <type>ejb</type> + </dependency> + <dependency> + <groupId>javax.persistence</groupId> + <artifactId>persistence-api</artifactId> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>javax.servlet</groupId> + <artifactId>servlet-api</artifactId> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>javax.ejb</groupId> + <artifactId>ejb-api</artifactId> + </dependency> + <dependency> + <groupId>com.sun.faces</groupId> + <artifactId>jsf-api</artifactId> + </dependency> + <!-- + <dependency> + <groupId>org.richfaces.ui</groupId> + <artifactId>richfaces-components-ui</artifactId> + <version>4.1.0.Final</version> + </dependency> + <dependency> + <groupId>org.richfaces.core</groupId> + <artifactId>richfaces-core-impl</artifactId> + <version>4.1.0.Final</version> + </dependency> +--> + </dependencies> + +</project> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/excel/ExcelTest.java =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/excel/ExcelTest.java (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/java/org/jboss/seam/example/excel/ExcelTest.java 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,120 @@ +package org.jboss.seam.example.excel; + +import java.util.LinkedList; +import java.util.List; + +import org.jboss.seam.ScopeType; +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>(); + private List<Person> result = new LinkedList<Person>(); + private List<List<Person>> repeat = new LinkedList<List<Person>>(); + private String searchWord; + + + @Create + public void create() + { + people.add(new Person("Pete Muir", "Red Hat Inc.", "Project Lead")); + people.add(new Person("Gavin King", "Red Hat Inc.", "Project Founder")); + people.add(new Person("Norman Richards", "Red Hat Inc.", "Seam Core")); + people.add(new Person("Shane Bryzak", "Red Hat Inc.", "Seam Security, Seam Remoting")); + people.add(new Person("Michael Yuan", "Individual", "")); + people.add(new Person("Mike Youngstrom", "Individual", "Spring Integration")); + people.add(new Person("Ales Justin", "Red Hat Inc.", "JBoss5/MC Integration")); + people.add(new Person("Christian Bauer", "Red Hat Inc.", "Seam Wiki, REST and GWT integration")); + people.add(new Person("Jay Balunas", "Red Hat Inc.", "Cross-platform testing")); + people.add(new Person("Dan Allen", "Individual", "Seam-gen, Bug fixes")); + people.add(new Person("Matt Drees", "Individual", "Seam Core")); + people.add(new Person("Jacob Orshalick", "Focus IT Solutions LLC", "")); + people.add(new Person("Nicklas \"Nik\" Karlsson", "Individual", "Excel reporting")); + people.add(new Person("Daniel Roth", "Individual", "Excel reporting")); + people.add(new Person("Judy Guglielmin", "ICESoft Inc.", "ICEFaces integration")); + people.add(new Person("Max Rydahl Andersen", "Red Hat Inc.", "Lead developer JBoss Tools, Hibernate Tools, Seam Tools")); + people.add(new Person("Emmanuel Bernard", "Red Hat Inc.", "Lead developer Hibernate Annotations, EntityManager, Validator, Search")); + repeat.add(people.subList(0, 5)); + } + + public List<List<Person>> getRepeat() + { + return repeat; + } + + public void setRepeat(List<List<Person>> repeat) + { + this.repeat = repeat; + } + + public void setSearchWord(String searchWord) + { + this.searchWord = searchWord; + } + + public String getSearchWord() + { + return searchWord; + } + + public List<Person> getPeople() + { + return people; + } + + public List<Person> getResult() + { + return result; + } + + public void search() + { + result = new LinkedList<Person>(); + for (Person person : people) + { + if (person.getName().toLowerCase().contains(searchWord.toLowerCase())) + result.add(person); + } + } + + public void clear() + { + this.result = new LinkedList<Person>(); + } + + public class Person + { + String name; + String company; + String task; + + public Person(String name, String company, String task) + { + this.company = company; + this.name = name; + this.task = task; + } + + public String getName() + { + return name; + } + + public String getTask() + { + return task; + } + + public String getCompany() + { + return company; + } + + } + +} Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/ejb-jar.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/ejb-jar.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/ejb-jar.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,19 @@ +<?xml version="1.0" encoding="UTF-8"?> +<ejb-jar xmlns="http://java.sun.com/xml/ns/javaee" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/ejb-jar_3_0.xsd" + version="3.0"> + + <interceptors> + <interceptor> + <interceptor-class>org.jboss.seam.ejb.SeamInterceptor</interceptor-class> + </interceptor> + </interceptors> + + <assembly-descriptor> + <interceptor-binding> + <ejb-name>*</ejb-name> + <interceptor-class>org.jboss.seam.ejb.SeamInterceptor</interceptor-class> + </interceptor-binding> + </assembly-descriptor> +</ejb-jar> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/persistence.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/persistence.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/META-INF/persistence.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="UTF-8"?> +<persistence xmlns="http://java.sun.com/xml/ns/persistence" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" + version="1.0"> + <persistence-unit name="userDatabase"> + <provider>org.hibernate.ejb.HibernatePersistence</provider> + <jta-data-source>java:jboss/datasources/ExampleDS</jta-data-source> + <properties> + <property name="hibernate.hbm2ddl.auto" value="create-drop"/> + <property name="hibernate.show_sql" value="true"/> + <property name="jboss.entity.manager.factory.jndi.name" + value="java:/seamexcelEntityManagerFactory"/> + </properties> + </persistence-unit> +</persistence> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/seam.properties =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/seam.properties (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-ejb/src/main/resources/seam.properties 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1 @@ + Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/pom.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,191 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <artifactId>excel</artifactId> + <groupId>org.jboss.seam.examples-ee6</groupId> + <version>2.3.0.Beta1-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>excel-tests</artifactId> + <name>Excel Integration Tests Module (EE6)</name> + + <dependencies> + <dependency> + <groupId>org.testng</groupId> + <artifactId>testng</artifactId> + <classifier>jdk15</classifier> + </dependency> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ejb</artifactId> + <type>ejb</type> + <scope>test</scope> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam</artifactId> + <type>ejb</type> + <scope>test</scope> + </dependency> + <dependency> + <groupId>org.slf4j</groupId> + <artifactId>slf4j-log4j12</artifactId> + <scope>test</scope> + </dependency> + <dependency> + <groupId>com.sun.faces</groupId> + <artifactId>jsf-api</artifactId> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>org.seleniumhq.selenium.server</groupId> + <artifactId>selenium-server</artifactId> + <classifier>standalone</classifier> + </dependency> + <dependency> + <groupId>org.seleniumhq.selenium.client-drivers</groupId> + <artifactId>selenium-java-client-driver</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>functional-tests</artifactId> + <scope>test</scope> + </dependency> + <dependency> + <groupId>junit</groupId> + <artifactId>junit</artifactId> + <scope>test</scope> + </dependency> + + <dependency> + <groupId>org.jboss.arquillian.junit</groupId> + <artifactId>arquillian-junit-container</artifactId> + <scope>test</scope> + </dependency> + + <dependency> + <groupId>org.jboss.arquillian.protocol</groupId> + <artifactId>arquillian-protocol-servlet</artifactId> + <scope>test</scope> + </dependency> + + <!-- additional libraries needed just for this example --> + <dependency> + <groupId>net.sourceforge.jexcelapi</groupId> + <artifactId>jxl</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-ui</artifactId> + <exclusions> + <exclusion> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-jul</artifactId> + </exclusion> + </exclusions> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-excel</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-mail</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-pdf</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-rss</artifactId> + </dependency> + </dependencies> + + <build> + <testResources> + <testResource> + <directory>src/test/resources</directory> + <filtering>true</filtering> + </testResource> + <testResource> + <directory>src/test/resources-integration</directory> + </testResource> + </testResources> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-surefire-plugin</artifactId> + <configuration> + <skip>true</skip> + </configuration> + </plugin> + </plugins> + </build> + + <profiles> + <profile> + <id>integration-tests</id> + <activation> + <property> + <name>arquillian</name> + </property> + </activation> + </profile> + + <profile> + <id>arq-jbossas-7-managed</id> + <activation> + <property> + <name>arquillian</name> + <value>jbossas-managed-7</value> + </property> + </activation> + <build> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-dependency-plugin</artifactId> + </plugin> + </plugins> + </build> + </profile> + + <profile> + <id>arq-jbossas-7-remote</id> + <activation> + <property> + <name>arquillian</name> + <value>jbossas-remote-7</value> + </property> + </activation> + </profile> + + + <profile> + <id>ftest-jbossas</id> + <properties> + <example.context.path>seam-excel</example.context.path> + </properties> + <build> + <plugins> + <plugin> + <groupId>org.codehaus.mojo</groupId> + <artifactId>selenium-maven-plugin</artifactId> + </plugin> + <plugin> + <groupId>org.codehaus.mojo</groupId> + <artifactId>failsafe-maven-plugin</artifactId> + </plugin> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-antrun-plugin</artifactId> + </plugin> + </plugins> + </build> + </profile> + </profiles> + +</project> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/RenderTest.java =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/RenderTest.java (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/RenderTest.java 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,86 @@ +package org.jboss.seam.example.excel.test; + +import java.io.File; +import java.io.ByteArrayInputStream; + +import jxl.Sheet; +import jxl.Workbook; + +import org.jboss.shrinkwrap.api.Archive; +import org.jboss.shrinkwrap.api.ShrinkWrap; +import org.jboss.shrinkwrap.api.asset.StringAsset; +import org.jboss.shrinkwrap.api.importer.ZipImporter; +import org.jboss.shrinkwrap.api.spec.EnterpriseArchive; +import org.jboss.shrinkwrap.api.spec.WebArchive; +import org.jboss.arquillian.container.test.api.Deployment; +import org.jboss.arquillian.container.test.api.OverProtocol; +import org.jboss.arquillian.junit.Arquillian; + +import org.jboss.seam.contexts.Contexts; +import org.jboss.seam.document.ByteArrayDocumentData; +import org.jboss.seam.document.DocumentData; +import org.jboss.seam.faces.Renderer; +import org.jboss.seam.mock.JUnitSeamTest; +import org.junit.runner.RunWith; +import org.junit.Test; + +/** + * @author Daniel Roth + * + * Really small test. Renders an jxl excel file from jsf tags and + * verifies the content. + * + */ +(a)RunWith(Arquillian.class) +public class RenderTest extends JUnitSeamTest { + + @Deployment(name="RenderTest") + @OverProtocol("Servlet 3.0") + public static Archive<?> createDeployment() + { + EnterpriseArchive er = ShrinkWrap.create(ZipImporter.class, "seam-excel.ear").importFrom(new File("../excel-ear/target/seam-excel.ear")) + .as(EnterpriseArchive.class); + WebArchive web = er.getAsType(WebArchive.class, "excel-web.war"); + web.addAsWebInfResource(new StringAsset("org.jboss.seam.mock.MockFacesContextFactory"), "classes/META-INF/services/javax.faces.context.FacesContextFactory"); + web.addClasses(RenderTest.class); + + return er; + } + + @Test + public void testSimple() throws Exception { + + new FacesRequest() { + + @Override + protected void updateModelValues() throws Exception { + } + + @Override + protected void invokeApplication() throws Exception { + + Renderer.instance().render("/simple.xhtml"); + + DocumentData data = (DocumentData) Contexts.getEventContext().get("testExport"); + Workbook workbook = Workbook.getWorkbook(new ByteArrayInputStream(((ByteArrayDocumentData)data).getData())); + Sheet sheet = workbook.getSheet("Developers"); + + assert sheet != null; + + assert "Daniel Roth".equals(sheet.getCell(0, 0).getContents()); + assert "Nicklas Karlsson".equals(sheet.getCell(0, 1).getContents()); + + } + }.run(); + } + + public static void main(String[] args) { + RenderTest t = new RenderTest(); + try { + t.testSimple(); + } catch (Exception e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + } +} Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/selenium/SeleniumExcelTest.java =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/selenium/SeleniumExcelTest.java (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/java/org/jboss/seam/example/excel/test/selenium/SeleniumExcelTest.java 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,27 @@ +package org.jboss.seam.example.excel.test.selenium; + +import org.jboss.seam.example.common.test.selenium.SeamSeleniumTest; +import org.testng.annotations.BeforeMethod; +import org.testng.annotations.Test; +import static org.testng.AssertJUnit.assertEquals; + +public class SeleniumExcelTest extends SeamSeleniumTest +{ + public static final String HOME_PAGE = "/home.seam"; + public static final String HOME_PAGE_TITLE = "Microsoft® Excel® Export examples"; + + @BeforeMethod + @Override + public void setUp() { + super.setUp(); + browser.open(CONTEXT_PATH + HOME_PAGE); + } + + /** + * Place holder - just verifies that example deploys + */ + @Test + public void homePageLoadTest() { + assertEquals("Unexpected page title.", HOME_PAGE_TITLE, browser.getTitle()); + } +} Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/WEB-INF/components.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/WEB-INF/components.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/WEB-INF/components.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,27 @@ +<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:document="http://jboss.com/products/seam/document" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://jboss.com/products/seam/core http://jboss.com/products/seam/core-2.3.xsd + http://jboss.com/products/seam/framework http://jboss.com/products/seam/framework-2.3.xsd + http://jboss.com/products/seam/document http://jboss.com/products/seam/document-2.3.xsd + http://jboss.com/products/seam/excel http://jboss.com/products/seam/excel-2.3.xsd + http://jboss.com/products/seam/components http://jboss.com/products/seam/components-2.3.xsd"> + + + <core:init debug="true" jndi-pattern="#{ejbName}/local" /> + + <document:document-store use-extensions="true"></document:document-store> + + <!-- A sample on how a POI implementation could be added. + <excel:excelFactory> + <property name="implementations"> + <key>poi</key> + <value>org.jboss.seam.excel.poi.POIExcelWorkbook</value> + </property> + </excel:excelFactory> + --> + +</components> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/seam.properties =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/seam.properties (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources/seam.properties 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,3 @@ +#debug is explicitly disabled in test to avoid JBIDE-3623 +#Thu Dec 31 16:24:37 CET 2009 +org.jboss.seam.core.init.debug=false Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/testng.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/testng.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/testng.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,26 @@ + + <!-- + JBoss, Home of Professional Open Source Copyright 2008, Red Hat + Middleware LLC, and individual contributors by the @authors tag. See + the copyright.txt in the distribution for a full listing of individual + contributors. This is free software; you can redistribute it and/or + modify it under the terms of the GNU Lesser General Public License as + published by the Free Software Foundation; either version 2.1 of the + License, or (at your option) any later version. This software is + distributed in the hope that it will be useful, but WITHOUT ANY + WARRANTY; without even the implied warranty of MERCHANTABILITY or + FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public + License for more details. You should have received a copy of the GNU + Lesser General Public License along with this software; if not, write + to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, + Boston, MA 02110-1301 USA, or see the FSF site: http://www.fsf.org. + --> +<!DOCTYPE suite SYSTEM "http://beust.com/testng/testng-1.0.dtd" > +<suite name="Excel example" verbose="2" parallel="false"> + <test name="excel_tests"> + <parameter name="PROPERTY_FILE" value="" /> + <classes> + <class name="org.jboss.seam.example.excel.test.selenium.SeleniumExcelTest" /> + </classes> + </test> +</suite> Property changes on: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-ftest/testng.xml ___________________________________________________________________ Added: svn:executable + * Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/arquillian.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/arquillian.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/arquillian.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="UTF-8"?> +<arquillian xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xmlns="http://jboss.org/schema/arquillian" + xsi:schemaLocation="http://jboss.org/schema/arquillian http://jboss.org/schema/arquillian/arquillian_1_0.xsd"> + + <engine> + <property name="deploymentExportPath">target/</property> + </engine> + + <container qualifier="jboss" default="true"> + <configuration> + <property name="javaVmArguments">-Xmx1024m -XX:MaxPermSize=512m</property> + <property name="jbossHome">target/jboss-as-${version.jbossas7}</property> + </configuration> + </container> + +</arquillian> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/testng.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/testng.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-tests/src/test/resources-integration/testng.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,11 @@ +<!DOCTYPE suite SYSTEM "http://beust.com/testng/testng-1.0.dtd" > + +<suite name="Excel" verbose="2" parallel="false"> + + <test name="Excel Tests"> + <classes> + <class name="org.jboss.seam.example.excel.test.RenderTest"/> + </classes> + </test> + +</suite> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/pom.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,89 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <artifactId>excel</artifactId> + <groupId>org.jboss.seam.examples-ee6</groupId> + <version>2.3.0.Beta1-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>excel-web</artifactId> + <packaging>war</packaging> + <name>Excel Web Module (EE6)</name> + + <properties> + <!-- filtering property for components.xml --> + <jndiPattern>java:app/excel-ejb/#{ejbName}</jndiPattern> + </properties> + + <dependencies> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ejb</artifactId> + <type>ejb</type> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam</artifactId> + <type>ejb</type> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-ui</artifactId> + <exclusions> + <exclusion> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-jul</artifactId> + </exclusion> + </exclusions> + </dependency> + <dependency> + <groupId>commons-beanutils</groupId> + <artifactId>commons-beanutils</artifactId> + <exclusions> + <exclusion> + <groupId>commons-collections</groupId> + <artifactId>commons-collections</artifactId> + </exclusion> + </exclusions> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-excel</artifactId> + </dependency> + <dependency> + <groupId>org.jboss.seam</groupId> + <artifactId>jboss-seam-debug</artifactId> + </dependency> + <dependency> + <groupId>org.richfaces.ui</groupId> + <artifactId>richfaces-components-ui</artifactId> + <version>4.1.0.Final</version> + </dependency> + <dependency> + <groupId>org.richfaces.core</groupId> + <artifactId>richfaces-core-impl</artifactId> + <version>4.1.0.Final</version> + </dependency> + </dependencies> + + <build> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-war-plugin</artifactId> + <configuration> + <webResources> + <resource> + <directory>src/main/webapp</directory> + <filtering>true</filtering> + </resource> + </webResources> + </configuration> + </plugin> + </plugins> + </build> + +</project> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/components.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/components.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/components.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,27 @@ +<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:document="http://jboss.com/products/seam/document" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://jboss.com/products/seam/core http://jboss.com/products/seam/core-2.3.xsd + http://jboss.com/products/seam/framework http://jboss.com/products/seam/framework-2.3.xsd + http://jboss.com/products/seam/document http://jboss.com/products/seam/document-2.3.xsd + http://jboss.com/products/seam/excel http://jboss.com/products/seam/excel-2.3.xsd + http://jboss.com/products/seam/components http://jboss.com/products/seam/components-2.3.xsd"> + + + <core:init debug="true" jndi-pattern="@jndiPattern@" /> + + <document:document-store use-extensions="true"></document:document-store> + + <!-- A sample on how a POI implementation could be added. + <excel:excelFactory> + <property name="implementations"> + <key>poi</key> + <value>org.jboss.seam.excel.poi.POIExcelWorkbook</value> + </property> + </excel:excelFactory> + --> + +</components> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/faces-config.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/faces-config.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/faces-config.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="UTF-8"?> +<faces-config version="2.1" + xmlns="http://java.sun.com/xml/ns/javaee" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-facesconfig_2_1.xsd"> +</faces-config> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/pages.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/pages.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/pages.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,7 @@ +<?xml version="1.0" encoding="UTF-8"?> +<pages xmlns="http://jboss.com/products/seam/pages" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://jboss.com/products/seam/pages http://jboss.com/products/seam/pages-2.0.xsd" > + + + +</pages> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/web.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/web.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/WEB-INF/web.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,68 @@ +<?xml version="1.0" encoding="UTF-8"?> +<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" + xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" + version="3.0"> + <listener> + <listener-class>org.jboss.seam.servlet.SeamListener</listener-class> + </listener> + <filter> + <filter-name>Seam Filter</filter-name> + <filter-class>org.jboss.seam.servlet.SeamFilter</filter-class> + </filter> + <filter-mapping> + <filter-name>Seam Filter</filter-name> + <url-pattern>/*</url-pattern> + </filter-mapping> + <servlet> + <servlet-name>Seam Resource Servlet</servlet-name> + <servlet-class>org.jboss.seam.servlet.SeamResourceServlet</servlet-class> + </servlet> + <servlet-mapping> + <servlet-name>Seam Resource Servlet</servlet-name> + <url-pattern>/seam/resource/*</url-pattern> + </servlet-mapping> + <servlet> + <servlet-name>Document Store Servlet</servlet-name> + <servlet-class>org.jboss.seam.document.DocumentStoreServlet</servlet-class> + </servlet> + <servlet-mapping> + <servlet-name>Document Store Servlet</servlet-name> + <url-pattern>*.csv</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>Document Store Servlet</servlet-name> + <url-pattern>*.xls</url-pattern> + </servlet-mapping> + <servlet> + <servlet-name>Faces Servlet</servlet-name> + <servlet-class>javax.faces.webapp.FacesServlet</servlet-class> + <load-on-startup>1</load-on-startup> + </servlet> + <servlet-mapping> + <servlet-name>Faces Servlet</servlet-name> + <url-pattern>*.seam</url-pattern> + </servlet-mapping> + <context-param> + <param-name>javax.faces.DEFAULT_SUFFIX</param-name> + <param-value>.xhtml</param-value> + </context-param> + <context-param> + <param-name>webAppRootKey</param-name> + <param-value>seam-excel</param-value> + </context-param> + <context-param> + <param-name>facelets.DEVELOPMENT</param-name> + <param-value>true</param-value> + </context-param> + + <!-- JSF2 requires to set this parameter, otherwise embedded text UI component won't be rendered --> + <context-param> + <param-name>com.sun.faces.allowTextChildren</param-name> + <param-value>true</param-value> + </context-param> + + <session-config> + <session-timeout>10</session-timeout> + </session-config> +</web-app> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/css/screen.css =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/css/screen.css (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/css/screen.css 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,47 @@ +/* Setup defaults since variable in browsers +----------------------------------------------- */ +body, div, span, dd, dt, dl, img, ul, ol, li, p, h1, h2, h3, h4, h5, form, hr, fieldset { + margin: 0; + padding: 0; +} +/* Element Defaults +----------------------------------------------- */ +html { + height: 100%; + margin: 5px; + +} +img { + border: 0; +} +body { + font-family: Verdana, Arial, Helvetica, sans-serif; + font-size: small; + line-height: 1.25em; + position: relative; + height: 100%; + margin-left: auto; + margin-right: auto; +} +input { + border: 1px solid #C3BBB6; + padding: 2px; + margin: 3px 0; +} +select { + border: 1px solid #C3BBB6; + padding: 4px; + margin: 5px 0; +} + +.header { + font-size: 16px; +} + +.subheader { + font-size: 14px; +} + +.plain { + font-size: 12px; +} \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/home.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/home.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/home.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,110 @@ +<!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.org/rich"> +<head> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> +<title>Microsoft&#174; Excel&#174; Export examples</title> +<link href="css/screen.css" rel="stylesheet" type="text/css" /> +</head> +<body id="excelHome"> +<f:view> + + <h:outputText value="Microsoft&#174; Excel&#174; Export examples" + styleClass="header"></h:outputText> + <br /> + <br /> + + <h:outputText value="Export ajax searchable Richfaces table" + styleClass="subheader"></h:outputText> + <br /> + <h:form id="excelExport"> + <h:inputText value="#{excelTest.searchWord}" /> + <a4j:commandButton value="Search" reRender="searchResults" + action="#{excelTest.search}" /> + <a4j:commandButton value="Clear" reRender="searchResults" + action="#{excelTest.clear}" /> + <br /> + + <a4j:outputPanel id="searchResults"> + <rich:dataTable value="#{excelTest.result}" var="person" + rendered="#{!empty excelTest.result}" id="excelTable" + style="xls-font: 10 Verdana; xls-column-widths: 8000 9000 10000" + columnClasses="left, right" width="500px"> + <rich:column> + <f:facet name="header"> + <h:outputText value="Name" style="xls-font: red bold"/> + </f:facet> + <h:outputText value="#{person.name}" /> + </rich:column> + <rich:column> + <f:facet name="header"> + <h:outputText value="Company" style="xls-font: red bold" /> + </f:facet> + <h:outputText value="#{person.company}" /> + </rich:column> + <rich:column> + <f:facet name="header"> + <h:outputText value="Working on" style="xls-font: red bold" /> + </f:facet> + <h:outputText value="#{person.task}" /> + </rich:column> + <rich:column style="xls-column-export:false"> + <f:facet name="header"> + <h:outputText value="Hide in export" style="xls-font: red bold" /> + </f:facet> + <h:outputText value="Details" /> + </rich:column> + </rich:dataTable> + <h:commandLink value="Export table as Excel spreadsheet" + rendered="#{!empty excelTest.result}" + action="#{excelExporter.export('excelExport:excelTable')}" /> + <br /> + <h:commandLink value="Export table as CSV" + rendered="#{!empty excelTest.result}" + action="#{excelExporter.export('excelExport:excelTable','csv')}" /> + </a4j:outputPanel> + + </h:form> + + <br /> + <br /> + <br /> + + <h:outputText value="Export xhtml file, use-extension enabled." + styleClass="subheader"></h:outputText> + <br /> + <h:outputLink value="vanilla-jxl.seam"> + <h:outputText>Export as Excel&#174; spreadsheet</h:outputText> + </h:outputLink> + <br /> + + <h:outputLink value="vanilla-csv.seam"> + <h:outputText>Export as comma separated file</h:outputText> + </h:outputLink> + <br /> + <br /> + <br /> + + <h:outputText value="Repeat and inline value" styleClass="subheader"></h:outputText> + <br/> + <h:outputText value="(Shows that you can use ui:repeat inside a cell.)" styleClass="plain"></h:outputText> + <br /> + + <h:outputLink value="repeat.seam"> + <h:outputText>Export as Excel&#174; spreadsheet</h:outputText> + </h:outputLink> + <br /> + <br /> + <br /> + + +</f:view> +</body> +</html> + Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/index.html =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/index.html (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/index.html 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,5 @@ +<html> +<head> + <meta http-equiv="Refresh" content="0; URL=home.seam"> +</head> +</html> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/people.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/people.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/people.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,33 @@ +<html xmlns="http://www.w3.org/1999/xhtml" + xmlns:ui="http://java.sun.com/jsf/facelets" + xmlns:e="http://jboss.com/products/seam/excel" + xmlns:f="http://java.sun.com/jsf/core"> + +<e:workbook type="#{exportType}"> + <e:worksheet name="People" value="#{people}" var="person"> + <e:header> + <f:facet name="left"> + The date is #date# and the time is #time# + </f:facet> + </e:header> + <e:column style="xls-column-autosize: true"> + <f:facet name="header"> + <e:cell value="Name" style="xls-font: red bold 10 Verdana"/> + </f:facet> + <e:cell value="#{person.name}" forceType="text" /> + </e:column> + <e:column style="xls-column-autosize: true"> + <f:facet name="header"> + <e:cell value="Company" style="xls-font: red bold 10 Verdana"/> + </f:facet> + <e:cell value="#{person.company}" /> + </e:column> + <e:column style="xls-column-autosize: true"> + <f:facet name="header"> + <e:cell value="Working on" style="xls-font: red bold 10 Verdana"/> + </f:facet> + <e:cell value="#{person.task}" forceType="text" /> + </e:column> + </e:worksheet> +</e:workbook> +</html> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/repeat.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/repeat.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/repeat.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,21 @@ +<html xmlns="http://www.w3.org/1999/xhtml" + xmlns:ui="http://java.sun.com/jsf/facelets" + xmlns:e="http://jboss.com/products/seam/excel" + xmlns:f="http://java.sun.com/jsf/core"> + +<e:workbook type="jxl"> + <e:worksheet name="Five first commiters" value="#{excelTest.repeat}" + var="list"> + <e:column> + <f:facet name="header"> + <e:cell value="Names of committers" /> + </f:facet> + <e:cell> + <ui:repeat value="#{list}" var="person"> + #{person.name}, + </ui:repeat> + </e:cell> + </e:column> + </e:worksheet> +</e:workbook> +</html> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/simple.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/simple.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/simple.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,8 @@ +<e:workbook exportKey="testExport" + xmlns:e="http://jboss.com/products/seam/excel" + xmlns:f="http://java.sun.com/jsf/core"> + <e:worksheet name="Developers"> + <e:cell column="0" row="0" value="Daniel Roth" /> + <e:cell column="0" row="1" value="Nicklas Karlsson" /> + </e:worksheet> +</e:workbook> Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-csv.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-csv.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-csv.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,9 @@ +<html xmlns="http://www.w3.org/1999/xhtml" + xmlns:ui="http://java.sun.com/jsf/facelets"> + + <ui:include src="people.xhtml"> + <ui:param name="exportType" value="csv" /> + <ui:param name="people" value="#{excelTest.people}" /> + </ui:include> + +</html> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-jxl.xhtml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-jxl.xhtml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/excel-web/src/main/webapp/vanilla-jxl.xhtml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,9 @@ +<html xmlns="http://www.w3.org/1999/xhtml" + xmlns:ui="http://java.sun.com/jsf/facelets"> + + <ui:include src="people.xhtml"> + <ui:param name="exportType" value="jxl" /> + <ui:param name="people" value="#{excelTest.people}" /> + </ui:include> + +</html> \ No newline at end of file Added: branches/community/Seam_2_3/examples-ee6/excel/features.txt =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/features.txt (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/features.txt 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,27 @@ +Features: + +* URI-based .xls templates +* Multiple worksheets per workbook +* Multiple datasets per worksheet +* Configurable starting coordinates for data sets +* Custom mask options for numeric/date types +* Cell formats (fonts, backgrounds, borders etc) +* Cascading template support for cell formats +* Many workbook settings (JExcelAPI) +* Many worksheet settings (JExcelAPI) +* Cascading template support for worksheet settings +* Headers/Footers, print areas etc. +* Comments +* Formulas +* URI-based images +* Hyperlinks + +Planned: + +* Multiple data cells per column +* Workaround for the 65k-rows limit of Excel +* Validations + +Possible? +* Charts +* Property sets Added: branches/community/Seam_2_3/examples-ee6/excel/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/pom.xml (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,49 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <parent> + <artifactId>examples-ee6</artifactId> + <groupId>org.jboss.seam</groupId> + <version>2.3.0.Beta1-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <modelVersion>4.0.0</modelVersion> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel</artifactId> + <packaging>pom</packaging> + <name>Excel Example (EE6)</name> + + <modules> + <module>excel-ejb</module> + <module>excel-web</module> + <module>excel-ear</module> + <module>excel-tests</module> + </modules> + + <properties> + <example.name>excel</example.name> + </properties> + + <dependencyManagement> + <dependencies> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ejb</artifactId> + <version>${project.version}</version> + <type>ejb</type> + </dependency> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-web</artifactId> + <version>${project.version}</version> + <type>war</type> + </dependency> + <dependency> + <groupId>org.jboss.seam.examples-ee6</groupId> + <artifactId>excel-ear</artifactId> + <version>${project.version}</version> + </dependency> + </dependencies> + </dependencyManagement> + +</project> Added: branches/community/Seam_2_3/examples-ee6/excel/readme.txt =================================================================== --- branches/community/Seam_2_3/examples-ee6/excel/readme.txt (rev 0) +++ branches/community/Seam_2_3/examples-ee6/excel/readme.txt 2012-03-14 17:52:52 UTC (rev 14404) @@ -0,0 +1,21 @@ +Seam Excel Example +================== + +This example demonstrates the Seam Excel functionality. It runs on JBoss AS7 as +an EAR. + +To deploy the example to JBoss AS7 , follow these steps: + +* In the example root directory run: + + mvn clean package + +* Set JBOSS_HOME environment property. + +* Start the AS7 up. + +* Deploy the sample: + + $JBOSS_HOME/bin/jboss-cli.sh --connect 'deploy excel-ear/target/seam-excel.ear' + +* Open this URL in a web browser: http://localhost:8080/seam-excel Modified: branches/community/Seam_2_3/examples-ee6/pom.xml =================================================================== --- branches/community/Seam_2_3/examples-ee6/pom.xml 2012-03-14 17:51:00 UTC (rev 14403) +++ branches/community/Seam_2_3/examples-ee6/pom.xml 2012-03-14 17:52:52 UTC (rev 14404) @@ -17,6 +17,7 @@ <modules> <module>booking</module> <module>dvdstore</module> + <module>excel</module> <module>mail</module> <module>messages</module> <module>todo</module>