4 ms·
Thanks! I've had to deal with docx files from time to time. I'm going to try this out. Does anyone know of a good way to read xlsx files with Python? I think I
by benatkin 17y ago
Thanks! I've had to deal with docx files from time to time. I'm going to try this out.
Does anyone know of a good way to read xlsx files with Python? I think I tried one library and it didn't quite work for this 20,000 row file, and I wound up using OpenOffice to convert it to csv. If not, hopefully this can be used as a starting point for developing a nice xlsx library.
- brendano 17y agoI wrote the following python script to read xlsx. It's extremely basic, but works very well for me. http://github.com/brendano/tsvutils/blob/master/xlsx2tsv http://github.com/brendano/tsvutils/blob/master/xlsx2tsv I've never tried it on a 20,000 row file. I suspect it would work. A really large file might need to switch to a streaming XML parser, but probably Excel itself wouldn't handle that use case too well.