Also, this is making me a little nervous. How does POI figure it out? Presumably if it's going to give me a "real Java unicode string", then it has to know how to convert from whatever encoding the spreadsheet is in to Unicode. So how does it figure out what encoding the spreadsheet is in? What if it guesses wrongly?
Best, Laird On Thu, Sep 9, 2010 at 4:58 PM, Laird Nelson <ljnel...@gmail.com> wrote: > OK, so given that, I'm trying to figure out how when I take a String from > cell.getStringCellValue(), and write it to a file whose FileOutputStream has > been explicitly wrapped by a FileWriter using the UTF8 encoding--I'm trying > to figure out why the contents in the file appear to be in MacRoman encoding > (my platform's default). > > I'm creating my XMLEventWriter that's ultimately doing the writing like > this: > > final FileOutputStream fileOuptutStream = new FileOutputStream(file); > final OutputStreamWriter outputStreamWriter = new > OutputStreamWriter(fileOuptutStream, "UTF8"); > final BufferedWriter bufferedWriter = new > BufferedWriter(outputStreamWriter); > > XMLEventWriter writer = outputFactory.createXMLEventWriter(bufferedWriter); > > ...and then at various points I'm using the String value from POI to stick > in there as #PCDATA. Seems like this should not involve ANY character set > conversion, is what you're telling me? > > L > > > On Thu, Sep 9, 2010 at 4:30 PM, Nick Burch <nick.bu...@alfresco.com>wrote: > >> On Thu, 9 Sep 2010, Laird Nelson wrote: >> >>> I am using POI to read an Excel spreadsheet. I have no idea what >>> character encoding it's in. I can tell you, however, it's not in UTF8. :-) >>> >> >> You don't have to worry about the encoding, POI sorts that out for you. >> Every String you get back is a real Java unicode string already >> >> Nick >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org >> For additional commands, e-mail: user-h...@poi.apache.org >> >> >
