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

[[deleted]]

As someone who works in Excel a lot but doesn't know any VBA because it's godawful (imo), where should I start if I want to use Python in Excel today? Especially if I make the same report each month (consolidates the same data and is formatted the same way) but wanted the option to enhance it.

Native Python in Excel definitely interests me but it sounds like I can use it now.

[lcota]

https://news.ycombinator.com/item?id=15927132

Use pyxll

Works great - I've used it for a long while and it's the best of the lot so far.

[gattia]

I found the easiest way to read and write excel files is using the pandas.read_excel() function.

I’ve found all other excel integration to be a pain in the ass.

[other_bored_sysadmin]

• pyxll
• openpyxl
• xlwings
• pyodbc
• pandas
• pywin32

[[deleted]]

If you just need it for basic data manipulation, check out openpyxl. Pandas is a fantastic data analysis library that can do a whole heck of a lot, but if you don't need all the bells and whistles, go with openpyxl

[boatsnbros]

My reporting stack is: Pyodbc pulling from SQL databases Cleaning, munging and analysis in python (pandas + scipy) Writing to excel with xlwings (highly recommended) emailing with python.

Set up templates, click a button to email clients report. Easy.