Chris, Downloaded the Yegor version and it compiled first go. But still ran into package errors when attempting to run the class.
However, along the lines suggested by Bobby, if I compile it using the -d option to specify my local directory then the class will get created in a directory tree that matches the package statement. javac -d /home/pjctest/java XLSX2CSV.java Then I find I can successfully run the class using - java org.apache.poi.xssf.eventusermodel.XLSX2CSV TestSheetB.xlsx At least I'm getting a good csv output now. I'll just have to figure how to implement this just using jar files, since that it my aim. I guess it was too much too expect that there might be an option to specify a file as the target instead of stdout but I'll take what I can get. Thanks a bunch, Petert ChrisLott wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/Compiling-XLSX2CSV-example-using-XSSF-tp25829140p25830841.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
