Jexcel API character problems [solved]

When you have problems with characters like � when reading excel files using JExcel API, then probably the problem is that the encodings are different. JExcel tries to read in UTF-8, but excel stores in CP1525 or something. Here is the solution:
WorkbookSettings ws = new WorkbookSettings();
ws
.setEncoding("Cp1252");
Workbook workbook = Workbook.getWorkbook(stream, ws);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s