There are some shorter ways to do the same by using the SheetJS utils functions to convert directly the sheet content to another format. Here is a codepen where you can test this method. If you want to use this import statement in an html page you'll need to do it inside those scripts tags. I managed to view the basic information about the 158 projects that are contained in the JSON file by transforming the list to a table and then expanding the other columns. If you want more informations you could check the SheetJS documentation and there is a more detailed example here : How to read an excel file contents on client side? I am desperately trying to parse the data from a nested JSON file (that has many records and lists in it) to Excel. Like this 'A1:J215' from it you could get the amount of lines or the char of the last column. '!ref' is more interesting as it contains the plage of cells containing data wich is a string
'!margin' refers to cells margins so it may not represent any interest. This array also have two more entries with those keys '!margin' and '!ref': The content of a sheet accessed this way is a single dimension object array wich contains all the cells of the sheet starting from the first cell of the header to the last cell wich contains data.Įach of those cells has a key like this 'A1', 'B250', 'J3'
0 kommentar(er)
