News for hackers. Stuff that matters.

A comment on Show HN: sheet2dict – simple Python XLSX/CSV reader/to dictionary converter.

Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by gpapilion on Wednesday April 21, 2021 @09:29AM (#26889393)
Isn’t this already in the csv module with dictreader?

Xlsx I know nothing about.

[ Parent | on HN ]
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by barbazoo on Wednesday April 21, 2021 @12:43PM (#26892016)
Correct, it's a wrapper around csv.DictReader

https://github.com/Pytlicek/sheet2dict/blob/main/sheet2dict/...

[ Parent | on HN ]
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by dragonwriter on Wednesday April 21, 2021 @10:40AM (#26890260)
There are several light (compared to pandas) xlsx/xls libraries for Python, but none that I know of have a simple read-to-dict API.
[ Parent | on HN ]
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by thebigspacefuck on Wednesday April 21, 2021 @10:34AM (#26890175)
openpyxl has good xlsx support and is easy to use. This seems to be an abstraction layer on top of both. Unfortunately this will use a lot of RAM working with large files.
[ Parent | on HN ]
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by werds on Wednesday April 21, 2021 @10:22AM (#26890052)
yes. if you are only going to be working with CSV files then this is overkill
[ Parent | on HN ]
Re:Show HN: sheet2dict – simple Python XLSX/CSV reader/to di... by pytlicek on Wednesday April 21, 2021 @10:29AM (#26890117)
It is true. I usually use it in tandem with flask / fast-api to parse both: CSV and XLSX. In the near future I will add XLS (yes, someone still uses it) and also the open document format.
[ Parent | on HN ]