Friday, 4 September 2020

How can I read a spreadsheet with more than 2k lines the fastest way?

So, I'm actually noob at node but I've done some projects following tutorials on YouTube using mainly Node and Express.I need to make a way to read a spreadsheet with one reference product and N similar products per line and I need to register the N similar products in the reference product using a third party API.I've heard about node streams used to read files but never used it. I was thinking about executing the function to register the product line by line so this would probably take less time or at least be more efficient but I don't know if this is possible.Numbers: I have to read one unique spreadsheet with more than two thousand lines every time the process is done. I have one reference product and N similar products to register per line. I have to make a request for that API for each similar product.I intend to use React and Axios for the front-end and Express and some library to read the spreadsheet on the back-end and have no need to store the spreadsheet items since I just need to register them.Thanks in advance and if I forgot any information just ask.

Submitted September 04, 2020 at 02:28PM by Samukxs

No comments:

Post a Comment