Hello ! My client absolutely wants an Excel export, whereas there already is CSV export, but that’s not enough for him.
Anyone know how to do that ? I’m trying to run a javascript but i’m just getting “False” although there are data in my collection :
// Get the data from the collection
const data = wwLib.wwVariable.getValue(“CA’s_paginated_groupe”);
// Check if data exists and is an array
if (!data || !Array.isArray(data)) {
console.error(“No valid data found”);
return false;
}
// Create CSV content
const csvContent = data.map(item => {
return {
‘Montant CA’: item.montant_ca || 0,
‘Remise’: item.remise || 0,
‘Fournisseur’: item.fournisseurs?.nom_fournisseur || ‘’,
‘Date de création’: item.created_at || ‘’
};
});
// Convert to CSV string
const headers = Object.keys(csvContent[0]);
const csvString = [
headers.join(‘,’),
…csvContent.map(row => headers.map(header => row[header]).join(‘,’))
].join(‘\n’);
// Create and download file
const blob = new Blob([csvString], { type: ‘text/csv;charset=utf-8;’ });
const link = document.createElement(‘a’);
link.href = URL.createObjectURL(blob);
link.download = ‘export_ca.csv’;
link.click();
return true;
Thanks