JSON Export Type CSV in UI5 - Umlauts -
JSON Export Type CSV in UI5 - Umlauts -
i have problem convert umlauts "äöü" in .csv format (output ä=ä, ö=ö, ü=ü). how can convert json table in utf-8 before export info .csv utilize in excel? export info json , next code:
var otable= sap.ui.getcore().byid("otable"); var otablejson = otable.getmodel().getproperty("/"); var omodel = new sap.ui.model.json.jsonmodel(); omodel.setdata(otablejson); var oexport = new sap.ui.core.util.export({ exporttype: new sap.ui.core.util.exporttypecsv({ separatorchar: ";", charset: "utf-8", }), models: omodel, rows: { path: "/" }, columns: [ { name: "first name", template: { content: { path: "firstname" } } }, { name: "last name", template: { content: { path: "lastname" } } } ] }); oexport.savefile().always(function() { this.destroy(); });
output: first name;last name äl;dente
http://help.sap.com/saphelp_uiaddon10/helpdata/en/f1/ee7a8b2102415bb0d34268046cd3ea/content.htm?frameset=/en/91/f31c206f4d1014b6dd926db0e91070/frameset.htm¤t_toc=/en/e4/843b8c3d05411c83f58033bac7f072/plain.htm&node_id=267
i think there issue binding path, give next code seek
rows: { path: "/data" }
json csv export-to-csv diacritics
Comments
Post a Comment