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/[deleted] Dec 15 '17

I've been using it since Office 2000, so for quite a few different things. The last was, we got loads of data (like one database record per worksheet) in separate workbooks. So I just copy all that data in a new sheet as a nicely formatted table.

1

u/Corm Dec 15 '17

Cool, another option in that case would be to use the openpyxl lib to read and write those https://automatetheboringstuff.com/chapter12/