EasyUI Forum

General Category => Bug Report => Topic started by: Gemorroj on October 28, 2019, 05:12:58 AM



Title: Excel export formatter
Post by: Gemorroj on October 28, 2019, 05:12:58 AM
Excel export is not format data as defined formatter.
My fix:
Code:
            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,
            });