Thanks Andy & Doug, will play with that today. I don't know what ExcelIML is and could not find a reference on the web. I would imagine the spreadsheets are 97/2003 but I have don't have control over their production.
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] > >
