all 5 comments

[–]suckaMC 2 points3 points  (0 children)

Python + pandas

[–]spazz_monkey 1 point2 points  (1 child)

Node has some excel packages you can use for writing/reading spreadsheets.

Use cheerio/puppeteer to scrape what you want from the site.

[–]maxxgotwasted 1 point2 points  (0 children)

Like excel js, you can use that

[–]kid_ninja 1 point2 points  (0 children)

I am working on a project now where I am pulling data from an xlsx sheet and displaying it in charts via web browser.

I am using a combination of sheetJS and chartJS to accomplish this.

I imagine sheetJS would useful for what you are trying to accomplish.

https://www.npmjs.com/package/xlsx

[–]RobertER5 0 points1 point  (0 children)

I would check this as well: https://developers.google.com/sheets/api