EasyUI Forum
April 27, 2024, 01:59:19 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Excel export formatter  (Read 6003 times)
Gemorroj
Newbie
*
Posts: 13


View Profile
« 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,
            });
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!