search

wireservice / csvkit

A suite of utilities for converting to and working with CSV, the king of tabular file formats.
https://csvkit.readthedocs.io
MIT License
6.03k stars 603 forks source link

in2csv empty result #1155

Closed adrianmihalko closed 2 years ago

adrianmihalko commented 2 years ago

I would like to convert this XLSX file:

https://www.telekom.sk/docs/updates/ins/Zoznam_planovanych_lokalit.xlsx

$ in2csv Zoznam_planovanych_lokalit.xlsx > zoznam.csv
/usr/lib/python3.6/importlib/_bootstrap.py:219: ImportWarning: can't resolve package from __spec__ or __package__, falling back on __name__ and __path__
Row 0 has 11 values, but Table only has 1 columns.

The result is an empty file.

jpmckinney commented 2 years ago

The first row in the Excel file is non-data "Report uložený: 4.3.2022"

You can use --skip-lines to skip it.

in2csv -K1 Zoznam_planovanych_lokalit.xlsx

I've added a note about this to the docs for in2csv.