xlsx to json to API

[emond07]

Hi,

Can we have sample for converting xlsx to json then post to Api per row/or bulk?
Thanks

[marianomd]

You have to listen to the parsed event:

<xlsx-read :file="file" @parsed="parsed">

And then you can iterate over the parsed data:

methods: {
            onChange(event) {
                this.file = event.target.files ? event.target.files[0] : null;
            },
            parsed(event) {
                let sheet = event.SheetNames[0];
                let row = 4;
                while (true) {
                    let cell = event.Sheets[sheet]['C' + row];
                    if (!cell || !cell.v) break;
                    console.log(cell.v);
                    row++;
                }
            }
        }