You'd need to grab the Import-Excel module, which is going to run into the problem of his IT department being pants-on-head retarded. If this was just a .csv file then yeah native Powershell will absolutely get you there and back with no problems, but building out the com objects from scratch to interact with an Excel spreadsheet is going to be hell on earth for even a seasoned veteran, which is why we all just grab the Import-Excel module rather than reinvent that wheel.
You'd need to grab the Import-Excel module, which is going to run into the problem of his IT department being pants-on-head retarded. If this was just a .csv file then yeah native Powershell will absolutely get you there and back with no problems, but building out the com objects from scratch to interact with an Excel spreadsheet is going to be hell on earth for even a seasoned veteran, which is why we all just grab the Import-Excel module rather than reinvent that wheel.
There's always scripting inside Excel with VBA, but I wouldn't wish that on anyone.
They're adding Python to Excel. Not sure when that's rolling out or if it's already here. I try not to interact with Excel if I can help it.