How can I make all fields equal to the text size? #3014

New Issue

Alexander-Sochi · 2023-10-18T15:25:36Z

Alexander-Sochi commented

2023-10-18 15:25:36 +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 y = 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(y);
const workbook = XLSX.utils.book_new();

XLSX.utils.sheet_add_aoa(worksheet, [e], { origin: "A1" });



XLSX.utils.book_append_sheet(workbook, worksheet, "Dates");
XLSX.writeFile(workbook, "Presidents.xlsx", { compression: true });

}

sheetjs commented

2023-10-18 16:25:17 +00:00

In the export demo https://docs.sheetjs.com/docs/getting-started/examples/export#clean-up-workbook , look at the code sample and explanation in "Changing Column Widths" (you will have to click to expand that section)

sheetjs closed this issue

2023-10-18 16:25:17 +00:00

Alexander-Sochi commented

2023-10-19 09:28:55 +00:00

this piece of code does not work, please help me, I can only access the first column of type A, but I need to access all a, b...

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

18 KiB

Alexander-Sochi reopened this issue

2023-10-19 09:28:55 +00:00

Sign in to join this conversation.