search

iommirocks / iommi

Your first pick for a django power cord
http://iommi.rocks
BSD 3-Clause "New" or "Revised" License
654 stars 45 forks source link

Table as xlsx #453

Open berycz opened 10 months ago

berycz commented 10 months ago

another enhancement (in the future) might be export table as xlsx (table.endpoints.xlsx) using openpyxl

the annoying thing with csv is that M$ excel opens csv by default in wrong encoding (in czech it uses cp1250) and you have to teach all end users how to change it to utf-8

I'm not sure if openpyxl should be required tho, might be better to have it optional and let the endpoint crash with ImportError when the lib is not installed

andreighh commented 3 months ago

I think the issue is related to encoding. For Excel to pick up the CSV properly it needs to be encoded as utf-8-sig.