how can I access all columns at once show me a ready-made solution please #3017

New Issue

Alexander-Sochi · 2023-10-19T09:47:56Z

Alexander-Sochi commented

2023-10-19 09:47:56 +00:00

const a = document.querySelector(".loaddata-command-btn-data-setup")
//const url = JSON.parse(CachedData);
//const raw_data = await(await fetch(url)).json();

function DownloadRawCacheDataToExcel() {

let e = Object.values(CachedData.fields);
let rows = CachedData.data.map(d => {

    return {
        id: d.id,
        date: new Date(d.date).toISOString(),
        value: d.value,
        analitica2: d.analitica2,
        analitica3: d.analitica3,
        analitica4: d.analitica4
    }

})



const worksheet = XLSX.utils.json_to_sheet(rows);
const workbook = XLSX.utils.book_new();




XLSX.utils.sheet_add_aoa(worksheet["!cols"] = [{ wch: 50 }], [e], { origin: "A1" });
XLSX.utils.book_append_sheet(workbook, worksheet, "Dates");
XLSX.writeFile(workbook, "Presidents.xlsx", { compression: true });

}

2023-10-19_12-47-28.png

122 KiB

Sign in to join this conversation.