Special character Excel import

Question

i have a problem with importing data from an excel file.

It works well, but in this file are words with the german letters "ä", "ö", "ü" and "ß".

When i import these words, i get these strange characters: �

Any plan how to convert them into the right characters?!

Thanks, prexx

What do you use to import excel file? Android or java cannot read xls files directly. — Daniel Fekete, Oct 25 '11 at 11:32
i use the jxl.jar libary and used the code shown here: http://www.vogella.de/articles/JavaExcel/article.html (example to read from file) — Prexx, Oct 25 '11 at 11:56
try `wbSettings.setEncoding("CP1252")`, or ISO-8859-2 or UTF-8 — Daniel Fekete, Oct 25 '11 at 12:18

score 1 · Accepted Answer · answered Oct 25 '11 at 12:26

1

Open the Workbook like this:

WorkbookSettings wbSettings = new WorkbookSettings();
wbSettings.setEncoding("CP1252");
w = Workbook.getWorkbook(inputWorkbook, wbSettings);

answered Oct 25 '11 at 12:26

Daniel Fekete

1 Answers1