Nisha Patel
Problem
Using the script below, I'm trying to enter into cells A1 to C3, the following values:
This is the script:
The problem is on row:
How to output the values of the object jsonData into the cells?
Solution
Convert dummyData into a 2D array before writing data to cells.
If you do not like the hardcode key name (eg. item.Fluxo1), below is a dynamic approach.
Suggested blogs:
>Type key of the record in a self-referential manner in TypeScript?
>How to get the last cell with data for a given column in TypeScript?
>Ignore requests by interceptors based on request content in TypeScript?
>Create data with Typescript Sequelize model without passing in an id?
>How to delete duplicate names from an Array in Typescript?
>How to Select checkboxes on an HTML treeview with JavaScript?
>How to use querySelectorAll()" with multiple conditions in JavaScript?
>How to fix the mouseover event glitch in JavaScript?
>How to do light and dark mode in a website using HTML and JavaScript?