Skip to Content
0
Mar 03, 2021 at 09:07 PM

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

33 Views

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.