Re:Python past, present, and future with Guido van Rossum [a...
by omegaham on Thursday February 23, 2017 @07:52AM
(#13713456)
I learned this when my boss was wringing his hands over an Excel job that was too complicated to do comfortably in VBA. I'm not allowed to install anything on the computers because I'm a flunky technician.
I started poking around the C:\Windows directory to see if there was something that I could use, and I found C:\Windows\Windows.NET\
"Wait a second - C# is .NET, right?"
A hundred lines of C# later, I had a solution for my boss where you drag the CSV onto the program and it spits out another CSV. I would've liked to have the ability to grab an Excel file, but that requires installing another library... can't do it.
I started poking around the C:\Windows directory to see if there was something that I could use, and I found C:\Windows\Windows.NET\
"Wait a second - C# is .NET, right?"
A hundred lines of C# later, I had a solution for my boss where you drag the CSV onto the program and it spits out another CSV. I would've liked to have the ability to grab an Excel file, but that requires installing another library... can't do it.