Did you try the version that Yegor put into the POI source area? The
early version that I created used two separate classes. Yegor merged
things together so the single file stands alone. Here is his version,
where you will see teh ReadonlySharedStringsTable class within the outer
XLSX2CSV class:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
If that fails, well, you can try my earlier version, but I really don't
recommend it anymore; if you insist, look at page
http://chris-lott.org/software/ for the xlsx2csv zip file.
HTH
chris...
p.s. A package is a fundamental unit of organization for a Java program.
Please read up on the basics of Java before asking for help with this
sort of thing.
p.p.s. Java is a P.I.T.A. when working with crude tools like javac. I
recommend trying Eclipse, the best Java IDE that I have ever used.
peterconn wrote:
Hi,
I copied the XLSX2CSV example using XSSF from this forum but have trouble
getting a clean compile.
My java skills are limited so I simply compile from the command line using
javac.
I have downloaded the latest POI release from Apache as
poi-bin-3.5-FINAL-20090928.zip and unzipped all the jar files and added
these to my classpath.
poi-ooxml-3.5-FINAL-20090928.jar
poi-scratchpad-3.5-FINAL-20090928.jar
poi-contrib-3.5-FINAL-20090928.jar
poi-3.5-FINAL-20090928.jar
commons-logging-1.1.jar
geronimo-stax-api_1.0_spec-1.0.jar
xmlbeans-2.3.0.jar
dom4j-1.6.1.jar
junit-3.8.1.jar
log4j-1.2.13.jar
ooxml-schemas-1.0.jar
The compile initially failed to find the ReadonlySharedStringsTable class so
I downloaded that code from this forum and complied class
ReadonlySharedStringsTable on the first attempt.
Please note that the only change I made was to remove the package statement.
I simply compiled ReadonlySharedStringsTable into my local directory as I
normally do with other classes.
Before compiling XLSX2CSV I also remove the package statement inserted by
Chris Lott.
But this compile fails with the error -
XLSX2CSV.java:376: cannot find symbol
symbol : constructor
ReadonlySharedStringsTable(org.apache.poi.openxml4j.opc.OPCPackage)
location: class ReadonlySharedStringsTable
ReadonlySharedStringsTable strings = new
ReadonlySharedStringsTable(this.xlsxPackage);
This package thing has me confused.
Can anybody help?
Cheers, Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
