r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

Show parent comments

2

u/Corm Dec 14 '17

Interesting. What have you used it for?

9

u/nuffin_stuff Dec 15 '17

I’m in the same boat as that guy - I had a sheet that took CMM data from a portable laser scanner and converted it into machine code for adaptive matching, I had a sheet that I programmed to take in a user’s input and then create a work order for my shop, tying in all of the serial numbers and pulling the correct revision controlled templates for the data inputs (a manual and terrible process before)... I had a sheet that took my company’s garbage ERP export data and then corrected and displayed it in a useful manner... I’ve done loads of projects with it. Some incredibly simple and some more complex time savers.

I love the integration with excel. As far as the language itself I think it’s a little easier to learn for beginners but it is kind of a pain to deal with daily. It feels limited sometimes but I’ve only got some rudimentary experience with other languages.

For those wondering I am a mechanical engineer who manages new product development for land based and aero turbine engines. Primarily land based turbines though. Learned VBA in my spare time at my first job.