How to get all all data in all sheets using node-red-contrib-spreadsheet-in?

[AK51]

Hi. After I have downloaded the spreadsheet-in and run the built-in example, it works fine except that I need to specify the sheet name (e.g. sheet1), how can I read all data in all sheets?

Thanks.

[zenofmud]

The Book node returns an array of the sheet names in msg.payload.SheetNames

You will need to loop thru the array and pass each sheet name to the sheet to json node