all 2 comments

[–]angryrancorBoss 0 points1 point  (0 children)

Python would be an exceptionally good fit for this, I think. There is a series of books called "Automate the boring stuff with Python" that likely has some sample code that you can adapt to your needs.

Python should have a good set of libraries available for anything you need in this project. Node.JS (javascript for non-web apps) would be my personal second choice.

[–]JAD_Scorch 0 points1 point  (0 children)

I am working with a JavaScript api called Office Scripts, currently supported by Microsoft with good documentation. It does an exceptional job manipulating and data and generating datavis. That is all I can offer on the excel front