Excel File Download and Drop downs at Column Level

[former_member579519]

Hi Experts,

I have an application with excel download functionality ( Empty template ).

In that excel I have a column "Discount Type" my client wants a Dropdown for it like below.

my code

 var aCols, oSettings, oSheet;
                    aCols = that.createColumnConfigMsg();
                    oSettings = {
                        workbook: {
                            columns: aCols,
                            hierarchyLevel: 'Level'
                        },
                        dataSource: oData1.results,
                        fileName: 'Promotion.xlsx',
                        worker: false
                    };

                    oSheet = new Spreadsheet(oSettings);
                    oSheet.build().finally(function () {
                        oSheet.destroy();
                    });<br>

Please help me. Thanks in advance.

Thanks & Regards

Srinivas Raju