Hello we are using aspose cells for java version 8.1.2
For special characters as in the following string: linéaire the encoding is not correctly done and we
get lin�aire
I am reading worksheet from Document which will be uploaded from UI.
This issue we face only in Linux.
my code looks like below.
void generateWorkbookWithStream(List workbooks, Document document, String delimiter) throws FileNotFoundException,
IOException {
Workbook workbook = new Workbook();
Worksheet sheet0 = workbook.getWorksheets().get(0);
try {
InputStream is = new ByteArrayInputStream(document.getDocumentBinary());
BufferedReader br = new BufferedReader(new InputStreamReader(is));
String line = "";
int noOfRecords = 0;
while ((line = br.readLine()) != null) {
String[] data = line.toString().split(delimiter);
sheet0.getCells().importArray(data, noOfRecords, 0, false);
data = null;
noOfRecords++;
}
} catch (IOException e) {
LOG.warn(e);
}
workbooks.add(sheet0);
}
Note : delimiter will be containing semicolon.
Please advice.
Thanks in advance.