How to import data from a spreadsheet to blueprints structured fields?

1

Hi
I would like to create a list of appartments in the backend where users can change price, status (sold, free, …) and so on.
I thought structured fields would be a good solution.
Something like that:

image
image1457×216 7.08 KB

But how can I import that data from an excelsheet and write it to the page-txt-file?
Later I would like to export the modified structured data of the txt-file to an excelsheet (I guess this is possible with the phpspreadsheet library).

Kind regards
Alin

2

You’d have to read the Excelsheet (using a library) into an array that has the format you need for the structure field, then update the page with the yaml encoded array.

Basically like in this function Add to structure, apart from the adding to it.