Can I apply formatter to the exel file I want to download with streadsheet?

[former_member727508]

I want to download table in a Sapui5 application. But I need to implement a field formatter. Can I do this directly with a with spreadsheet without doing a backend?

        formatter: function(sKey) {
        switch (sKey) {
            case 'a':
                return 'Free shipping';
            case 'b':
                return 'Premium shipping';
            case 'c':
                return 'Express shipping';
        }
    },

I know I can do this. But I want to apply it to the field in the exel file I downloaded, not the table on the screen.

[former_member450774]

Hi,

Copy the data to new Json model, create new field for modified data of sKey and then refer this Model for downloading the Excel.

Hope this helped you!

Rajesh.