Excel export cell wise formatting issue

Dash Python
1

image
image856×204 4.85 KB

How can I make Row 7, 11, 12 to percentage format and other cells to normal amount format. I tried with below JS but it always returning as object Object in excel. I can not format the data before export as requirement is to show full data in excel only the format will be changed. This is dash version

dash = “^3.0.4”

dash-ag-grid = “^31.2.0”

Code :

let excelParams = {

fileName: fName,

sheetName: ‘Data’,

processCellCallback: function (params) {

let colId = params.column.getColId();

let value = params.value || ‘’;

let excelStyleId = null;

return { value: 0.12, excelStyleId: ‘percentStyle’ }