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:
The last time someone made me try to work with an Excel spreadsheet I just automated away the entire process rather learn how to deal with Excel. I dislike Excel spreadsheets that much.
Excel is cancer, it gave me cancer and gives cancer to everyone that uses it
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.
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.