Excel export is not format data as defined formatter.
My fix:
const columns = $node.datagrid('options').columns[0];
const rows = $node.datagrid('getRows');
rows.map(row => {
columns.forEach(column => {
if (column.formatter) {
row[column.field] = column.formatter(row[column.field]);
}
});
return row;
});
$node.datagrid('toExcel', {
filename: $node.datagrid('options').title + '-' + filter + '.xls',
rows: rows,
});