I am loading an excel file in an GAE/Java application with JExcel like this:
The html form to upload the file islike this:
<form id="" action="/save" method="post" enctype="multipart/form-data" accept-charset="ISO-8859-1">
<input name="file" type="file" value="load"/>
<input type="submit"value="load excel"/>
</form>
and in the server I have:
ServletFileUpload upload = new ServletFileUpload();
FileItemIterator iterator = upload.getItemIterator(request);
while (iterator.hasNext()) {
FileItemStream item = iterator.next();
InputStream stream = item.openStream();
if (!item.isFormField()) {
//if it's not a form field it's a file
Workbook workbook = Workbook.getWorkbook(stream);
...
String name = sheet.getCell(COL_NUMBER, row).getContents();
}
}
The problem is that if I write in the cell something like 'city ó' when it reads in the server the variable name is ' city ?'. The encoding is not OK.
I've tried to change accept-charset="ISO-8859-1" (setting it to utf-8 or removing it) but with no success.
Can anyone tell me how could I solve this problem.
Thanks
OK, I got it by doing this:
WorkbookSettings will look for system property jxl.encoding
If you don't have easy access to WorkbookSettings (i.e. coming from Drools- ExcelParser) you might find this preferable.
First up, make sure you're using a recent version of POI (something like 3.7 or 3.8 beta 2). Very old versions of POI did have encoding problems, but as long as you're on a new one then that shouldn't be your issue.
Next, on your local machine, run something like org.apache.poi.hssf.extractor.ExcelExtractor against the file. This will let you confirm that POI is handling the encoding correctly. Run it with
Assuming that works fine, then you know your issue is within Google App Engine.