ExportUsersToExcel.js

import XLSX from 'xlsx';
export default {
    methods: {
        exportUsersToExcel (rows) {
            let formattedRows = [];
            if (rows.length > 0) {
                const self = this;
                rows.forEach(function (user) {
                    formattedRows.push({
                        username: user.username,
                        firstname: user.firstname,
                        lastname: user.lastname,
                        email: user.email,
                        phone_number: user.phone_number,
                        active: user.active == 1 ? 'Activado' : 'Desactivado',
                        role: self.$_.has(user, 'role.name') ? user.role.name : '',
                    })
                })
            }
            let data = XLSX.utils.json_to_sheet(
                formattedRows,
                {
                    header: ['username', 'firstname', 'lastname', 'email', 'phone_number', 'active', 'role']
                }
            )
            data['A1'].v = 'Usuario';
            data['B1'].v = 'Nombre';
            data['C1'].v = 'Apellidos';
            data['D1'].v = 'Correo electrónico';
            data['E1'].v = 'Teléfono';
            data['F1'].v = 'Activado';
            data['G1'].v = 'Rol';
            const workbook = XLSX.utils.book_new()
            const filename = 'usuarios';
            XLSX.utils.book_append_sheet(workbook, data, filename)
            XLSX.writeFile(workbook, `${filename}.xlsx`)
        }
    }
}