xlxs import / export about django-import-export HOT 10 CLOSED

Check if you have dev version of tablib installed.

from django-import-export.

tablib 0.9.11
xlrd 0.9.2
openpyxl 1.6.2

from django-import-export.

This is 2 years old, install dev version. See
https://github.com/bmihelac/django-import-export/issues/20#issuecomment-21094655

from django-import-export.

Installed but still have no xlxs option to import/export.

I found in admin.py below. Maybe need to add XLSX ?

#: import / export formats
DEFAULT_FORMATS = (
    base_formats.CSV,
    base_formats.XLS,
    base_formats.TSV,
    base_formats.ODS,
    base_formats.JSON,
    base_formats.YAML,
    base_formats.HTML,
)

from django-import-export.

ok add and can export but no option for import

DEFAULT_FORMATS = (
    base_formats.XLSX,
)

from django-import-export.

sorry, I thought you are asking for xls and not xlsx. Does tablib
support both reading and writing to this format? If so, it is easy to add
it to django-import-export. Patch would be welcomed.

best,
Bojan

from django-import-export.

in overview I can see this "Datasets can be imported from JSON, YAML, and CSV; they can be exported to XLSX, XLS, ODS, JSON, YAML, CSV, TSV, and HTML." I know there is openpyxl in tablib. Just not sure about importing XLSX format.
I added below and export is working fine.

DEFAULT_FORMATS = (
    base_formats.XLSX,
)

Could you give clue where i should start to add import for XLSX in django-import-export.

Tanks,
Jakub

from django-import-export.

quick check shows that tablib does not have support to import xlsx:

https://github.com/kennethreitz/tablib/blob/develop/tablib/formats/_xlsx.py

if xlsx importing matters, you would have to write import_book support.

see existing xls tablib importer
https://github.com/kennethreitz/tablib/blob/develop/tablib/formats/_xls.py

from django-import-export.

Thx will try

from django-import-export.

i had seen xlsx option in import formats only after install openpyxl (openpyxl-2.4.0) python module

from django-import-export.