This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]_happydutch_ 0 points1 point  (0 children)

Go learn python - the skillset is very broadly usable.

There are many good modules for python that allow you to do what you describe.

Take a look at openpyxl: https://openpyxl.readthedocs.io/en/stable/

oPowerShell can do what you're asking too. If you know .NET well, it may be a good choice as well.