Sorry I was running the dist, which failed. i see where the jar's have gone to build\dist....perhaps the documentation could be extended to point that out for boneheads like me.....
On Fri, May 30, 2008 at 5:22 PM, tom corcoran <[EMAIL PROTECTED]> wrote: > I really wish POI was available as a jar file :-( I have spent the last 3 > hours trying to build it without success. It keeps saying that JUnit is not > available and to include the JAR file in my classpath. I have followed > http://poi.apache.org/howtobuild.html a load of time now and many reboots > later I get the same message :-( > > Tom. > > On Fri, May 30, 2008 at 4:54 AM, Doug Stevens <[EMAIL PROTECTED]> > wrote: > >> Tom, >> >> The HSSFRow defines a CellIterator this will allow you to iterate through >> the row and get each element. You can then write the value of the cell out >> to a new File, just create a comma delimeted string for the row. >> >> Are you using Excel 97 or ExcelML formatted sheets? >> >> Doug Stevens >> (541) 788-3221 >> >> >> >> -----Original Message----- >> From: tom corcoran [mailto:[EMAIL PROTECTED] >> Sent: Thursday, May 29, 2008 9:43 AM >> To: [email protected] >> Subject: Convert .xls to ascii? >> >> >> I have about 10 different .xls file types. Each file has the column names >> in >> row 1 and has multiple sheets with the same data for different locations. >> I >> have hundreds of each file type. My solution need to be able to work >> dynamically as new files come online. >> >> I am looking at parsing the first line to create a mysql schema and then >> importing the xls in java using mysql's load infile. I have used this to >> load ascii files without an issue. It seems I can use >> org.apache.poi.hssf.eventusermodel to read the xls files. Is there any way >> I >> can use this package to convert to an ascii file which I will easily be >> able >> to load into MySQl? The delimiter used, be it comma or otherwise is >> irrelevant as load infile can cope with an ascii delimiter. >> >> Thanks for advice. >> >> Tom. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >
