I am using fs currently in my node script to write output from a puppeteer action to a text file. I am manually inputting certain parameters.

What I want to do is take all values from a certain column in a sheet in a .numbers file and add them to an array to loop over. Then output my results back into another column in the same file. I'm fine handling all of that functionality, but reading from the numbers file escapes me!

I'm really struggling to find the best way to do this - all the info seems to point to working with excel files which doesnt work.

Any pointers appreciated.

Update: I'm trying to use fs.createReadStream, but seeing very unusual output in the console: