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.
Yeah, that's a good idea. I would have to look into it, as I am not used to working in power shell. Honestly wouldn't surprise me if they had somehow made it impossible for us to open power shell without entering admin credentials though.
See if you can do it in PowerShell. Not the greatest anything, but it's already there.
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.
Yeah, that's a good idea. I would have to look into it, as I am not used to working in power shell. Honestly wouldn't surprise me if they had somehow made it impossible for us to open power shell without entering admin credentials though.