Re: POI 3.5Beta5 issue
Hello Anh, XSSF is part of the new ooxml stuff which is found in the poi-ooxml jar. For example, in the latest release, this is the extra jar you need: http://people.apache.org/~yegor/REL_3_5_BETA5/poi-ooxml-3.5-beta5-20090219.jar hope this helps, Josh
POI 3.5Beta5 issue
To Whom It May Concern,
I downloaded this latest release of POI and tried out the tutorial. I find
that somehow, I'm unable to use the XSSF package. I looked in the jar file but
it doesn't seems the XSSF code is not there. I realized that it is now
combined and used under the interface SS. But when i tried to write this code:
XSSFWorkbook xssfWB = new XSSFWorkbook();
It complain that this class can't be resolved.
I'm unable to import this package. It doesn't seem to appear in the
3.5-Beta5.jar.
Also, when I try the code below:
InputStream inp = new FileInputStream("workbook.xls");
//InputStream inp = new FileInputStream("workbook.xlsx");
Workbook wb = WorkbookFactory.create(inp); <--this class highlighted
can't be found in the package either.
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(2);
Cell cell = row.getCell(3);
if (cell == null)
cell = row.createCell(3);
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellValue("a test");
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
Please help, I really need this for my work project which is on a tight
deadline within a new weeks. I need it to be able to read .xlsx files.
I notice the source code package I downloaded has XSSF inside folder OOXML. I
have the 3.5-Beta5.jar in my build path. I am missing any other lib or jars?
Please let me know.
Any feed back is greatly appreciated.
Thanks in advance,
Anh
_
How fun is this? IMing with Windows Live Messenger just got better.
http://www.microsoft.com/windows/windowslive/products/messenger.aspx
Re: [VOTE] Release of POI 3.5-beta5
Hi Yegor, I had to ask. I've seen a Jakarta beta do it differently, but we are a huge project compared to that. So, OK. Let's make sure that we get these issues resolved next week - then at least the nightly builds will have all the details properly marked. (1) A really, really proper NOTICE and LICENSE. (2) All copyright statements in the project properly checked and adjusted. (3) All source files with the proper license statement in them. Do we have any other copyrights in the code other than one we had the author re-license? ./resources/scratchpad/org/apache/poi/hdgf/chunks_parse_cmds.tbl 3:# Copyright (C) 2006-2007 Valek Filippov (f...@df.ru) Regards, Dave On Feb 20, 2009, at 2:34 AM, Yegor Kozlov wrote: RAT has a way to do it. Take a look at http://svn.apache.org/repos/asf/incubator/rat/main/trunk/rat/rat-core/src/main/java/org/apache/rat/analysis/license/ApacheSoftwareLicense20.java It only does a minimal check. A full check could be done. I did a find/grep search on copyright. There are a few files that show copyright for The POI Project and not the ASF. These are mostly documentation files. They could be quickly fixed as well. Should we repackage this release with these license and copyright fixes along with a better NOTICE? I don't think we should re-package this release as it will require another round of evaluation / voting. Jukka is going to propose an improved version of the LICENCE but it will be not earlier than weekend. Current issues are OK for a beta and I would rather not delay this release because of them. Yegor - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[g...@vmgump]: Project poi (in module poi) failed
To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at gene...@gump.apache.org. Project poi has an issue affecting its community integration. This issue affects 1 projects, and has been outstanding for 14 runs. The current state of this project is 'Failed', with reason 'Build Failed'. For reference only, the following projects are affected by this: - poi : POI Full details are available at: http://vmgump.apache.org/gump/public/poi/poi/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Output [poi-ooxml-gump-23022009.jar] identifier set to output basename: [poi-ooxml-gump] -DEBUG- Output [poi-contrib-gump-23022009.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-23022009.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-23022009.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build failed -INFO- Failed to extract fallback artifacts from Gump Repository The following work was performed: http://vmgump.apache.org/gump/public/poi/poi/gump_work/build_poi_poi.html Work Name: build_poi_poi (Type: Build) Work ended in a state of : Failed Elapsed: 9 mins 8 secs Command Line: /usr/lib/jvm/java-6-sun/bin/java -Djava.awt.headless=true -Xbootclasspath/p:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis.jar:/srv/gump/public/workspace/xml-xerces2/build/xercesImpl.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar:/srv/gump/public/workspace/xml-xalan/build/xalan-unbundled.jar org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml -Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=23022009 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-6-sun/lib/tools.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/jsr173_1.0_api.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/openxml4j-1.0-beta.jar:/srv/gump/public/workspace/poi/build/classes:/srv/gump/public/workspace/poi/build/contrib-classes:/srv/gump/public/workspace/poi/build/scratchpad-classes:/srv/gump/public/workspace/poi/build/ooxml-classes:/srv/gump/public/workspace/poi/build/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-test-classes:/srv/gump/public/workspace/poi/build/ooxml-test-classes:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-swing.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-resolver.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-xalan2.jar:/srv/gump/public/workspace/ant/dist/lib/ant-trax.jar:/srv/gump/public/workspace/ant/dist/l ib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-nodeps.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/logging-log4j-12/dist/lib/log4j-23022009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-23022009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-23022009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-23022009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-23022009.jar:/srv/gump/public/workspace/apache-commons/lang/commons-lang-23022009.jar:/srv/gump/public/workspace/junit/dist/junit-23022009.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar - [javac] Note: Recompile with -Xlint:unchecked for details. -test-contrib-check: test-contrib: -test-contrib-write-testfile: compile-ooxml: [javac] Compiling 152 source files to /srv/gump/public/workspace/poi/build/ooxml-classes [javac] Note: Some input files use unchecked or unsafe operations. [javac] Note: Recompile with -Xlint:unchecked for details. [javac] Compiling 69 source files to /srv/gump/public/workspace/poi/build/ooxml-test-classes -test-ooxml-check: test-ooxml: [junit] Running org.apache.poi.TestDetectAsOOXML [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.396 sec [junit] Running org.apache.poi.TestEmbeded [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2.278 sec [junit] Running org.apache.poi.TestXMLPropertiesTextExtractor [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 1.47 sec [junit] Running org.apache.poi.extractor.TestExtractorFactory [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 4.815 sec [junit] Running org.apache.poi.openxml4j.opc.TestCo
DO NOT REPLY [Bug 46756] Improved LICENSE and NOTICE files
https://issues.apache.org/bugzilla/show_bug.cgi?id=46756 Jukka Zitting changed: What|Removed |Added Depends on||46758 -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46758] New: Use the StAX API jar from Apache Geronimo
https://issues.apache.org/bugzilla/show_bug.cgi?id=46758 Summary: Use the StAX API jar from Apache Geronimo Product: POI Version: unspecified Platform: All OS/Version: All Status: NEW Keywords: PatchAvailable Severity: normal Priority: P2 Component: POI Overall AssignedTo: dev@poi.apache.org ReportedBy: ju...@apache.org Blocks: 46756 Created an attachment (id=23299) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23299) Patch to use the Geronimo version of the StAX API jar As mentioned in https://issues.apache.org/jira/browse/LEGAL-42, the licensing terms of the JSR 173 API jar (jsr173_1.0_api.jar) are a bit troublesome. There's an ALv2 version of the StAX API jar from the Apache Geronimo project. I suggest that we use that jar instead of the official JSR 173 jar to avoid licensing issues. Assuming we make this change, the JSR 173 entries in the proposed new LICENSE and NOTICE files in bug 46756 can be removed. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
JSR 173 API jar (Was: [Bug 46756] Improved LICENSE and NOTICE files)
Hi, > --- Comment #1 from David Fisher 2009-02-22 > 19:09:50 PST --- > I see that Apache Geronimo uses Woodstox 3.2.0. > > From http://woodstox.codehaus.org/FAQ it says that it is available with an ASL > 2.0 license. The licensing problem is more with the JSR 173 API jar itself than with the implementation. There's an ALv2 licensed version of the API jar at http://repo2.maven.org/maven2/org/apache/geronimo/specs/geronimo-stax-api_1.0_spec/1.0/ I'll file another bug for this change. BR, Jukka Zitting - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
