Female “professional” in an existential crisis after ChatGPT tells them they do make-work in adult day care
(media.kotakuinaction2.win)
You're viewing a single comment thread. View all comments, or full comment thread.
Comments (65)
sorted by:
Must be nice. At my job there is a nontrivial portion of work that involves making regular reports for customers out of data that exists in an excel sheet. There is a degree of customization and case-by-case nature to it, but 99% of the logic that goes into the reports could be encapsulated in a relatively simple script.
But IT rules our computers with an iron fist and every time I've suggested they allow me to download python or AHK or something where I could write a script to automate it, it gets shot down in like 2 seconds because of it being a security risk. I get it, most employees couldn't be trusted with shit like that, but there has to be some solution there....
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.