cancel
Showing results for 
Search instead for 
Did you mean: 

Download excel with non -english characters.

aruna_c
Explorer
0 Kudos

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();
			});
		},
aruna_c
Explorer
0 Kudos

Any update on the issue with excel -> "105156001137" is converted as "105156E+11". Also how to add the custom file name for excel sheet downloaded from smart table?

thanks in advance!

Accepted Solutions (0)

Answers (0)