on 11-20-2018 1:14 PM
excel-data-mismatch.pngI have an requirement to download data from sap.ui.table. When I am trying to download, the non-english characters were changed into different texts. I have also set the charset to utf-8. But its not working. Any suggesstion to resolve this.
Also the values in the format 2014-03 is converting into 2014 Mar. But i need in the same format. Text "Rådhusstræde" is converted into "RÃ¥dhusstræde" when opened in excel
"105156001137" is converted as "105156E+11"
var oExport = new Export({
exportType: new ExportTypeCSV({
fileName: "List",
fileExtension: "xls",
separatorChar: "\t",
charset : "utf-8"
}),
models: oModel,
rows: {
path: "/results"
},
columns: [{
name: "Column 1",
template: {
content: "{col}"
}
}, {
name: "Column 2",
template: {
content: "{column}"
}
}]
});
var timestamp = new Date()
oExport.saveFile("List"+"(" + timestamp + ")" ).catch(function(oError) {
MessageBox.error("Error when downloading data. Browser might not be supported!\n\n" + oError);
}).then(function() {
oExport.destroy();
});
},
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.