5 ms·
A couple of years ago I played with xlwings, but found it too slow for our usecase (a few cells modified per second) plus we found the Windows requirement quite
by sonofgod 8y ago
A couple of years ago I played with xlwings, but found it too slow for our usecase (a few cells modified per second) plus we found the Windows requirement quite onerous.
I wound up reading/writing our spreadsheets in pure Python -- we used xlwt which doesn't support xlsx, so I'd probably consider using openpyxl these days.
(Specifically we were selecting parts of spreadsheets based on row/column headers inside the spreadsheet even if they weren't in the first row/column or there were multiple tables per tab; if this sounds useful to you check out https://github.com/sensiblecodeio/xypath https://github.com/sensiblecodeio/xypath )
- montenegrohugo 8y agoWhy not just use Pandas? Whenever I want to do any slightly complex modification to an excel table I just load it into Pandas instead. It's a complete breeze and very fast.
- pletnes 8y agoPandas uses the openpyxl module, which can both read and write. It’s quite nice and pure python, too. Pandas is more high level and gives less control but also less code.
- mutagen 8y agoProps to openpyxl, just used that module to do some quick and dirty spreadsheet manipulation to save some colleagues a bunch of time.
- sonofgod 8y agoI don't think it came up in our review of Excel/Python technologies -- perhaps because that's not the primary focus of the library.