Visidata: Excel (xls, xlsx) files have no column names in the header

[aborruso]

Hi,
I have this input file.

If I run vd a.xlsx and open the sheet inside I have the header cells values are row values and not header values.

But I think it should be in this way.

I have openpyxl 2.4.11 and and visidata 1.4.

Thank you

[saulpw]

Hi @aborruso, this is because Excel sheels can have any number of headers and it is impossible to know how many there are. You can "hoist" the current row into the header with g^ and then ddelete the row to get the result you want.

[aborruso]

@saulpw a feature requests: enable --header=int option also for xls and xlsx.

Thank you

[saulpw]

This is also addressed in v1.5 with the --header option (defaulting to 1).

[aborruso]

@saulpw I'm very happy, I feel myself an influencer :D :D :D

Great, thank you

[aborruso]

Hi @saulpw ,
when I open the sheet inside this xls file it has no column names.

I'm using vd 1.5.

Thank you

[saulpw]

This works for me. Could you try with current develop branch? If that works, then this will be fixed in 1.5.1.

[aborruso]

hi @saulpw I'm not able to install and use vd via pip visidata, I have always python environment problem (not able to solve this).

The the way for me to have an update version is only to use the deb version.

Than I cannot make any test with develop branch :(

[saulpw]

@aborruso did 1.5.1 fix this issue for you?

[aborruso]

@saulpw I have always the same :(

Traceback (most recent call last):
  File "/home/andybandy/miniconda3/bin/vd", line 152, in <module>
    main()
  File "/home/andybandy/miniconda3/bin/vd", line 130, in main
    vdtui.run(*sources)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 2838, in run
    ret = wrapper(cursesMain, sheetlist)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 2828, in wrapper
    return curses.wrapper(setupcolors, f, *args)
  File "/home/andybandy/miniconda3/lib/python3.6/curses/__init__.py", line 94, in wrapper
    return func(stdscr, *args, **kwds)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 2825, in setupcolors
    return f(stdscr, *args)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 2851, in cursesMain
    return vd().run(_scr)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 866, in run
    keystroke = self.getkeystroke(scr, sheet)
  File "/home/andybandy/miniconda3/lib/python3.6/site-packages/visidata/vdtui.py", line 734, in getkeystroke
    k = scr.get_wch()
AttributeError: '_curses.window' object has no attribute 'get_wch'