Ubuntu – How to print sheetnames of a spreadsheet using Linux command-line

command linecsvxls

I am aware of using in2csv to save a particular worksheet as a .csv:

in2csv --sheet "sheet name" file1.xls > sheet-name.csv

But are there any other tools to just print the sheetnames?

Perhaps there are options with Perl?

Best Answer

in2csv from the csvkit package provides the --names or -n option for that: ^[Source]

 -n, --names     Display sheet names from the input Excel file.

In your example the command would be:

in2csv -n file1.xls

This feature was added in csvkit 1.0.2, which is not available from the official package sources for releases older than Bionic. If you’re running Xenial you need to either

compile the program from source or
install it via pip with
```
sudo pip install csvkit
```

to get the latest version.

Related Solutions

Ubuntu – Converting XSL files to CSV files in command line

I would start by closing LibreOffice. That has caused issues for me in the past with unoconv but it has been hard to predict. It's easiest to just let unoconv launch its own processing server. If you think you've done that but you're seeing the same error, run killall soffice.bin and try again.

In terms of retaining the same name, it does that by default.

unoconv -f csv filename.xls

That will create a filename.csv file. In my mind, this is really desirable because then you know the format of the file (and you won't try to do silly things by accident). And that works for wildcards too:

$ ls *.xls
ie_data.xls  QTL_Sample_data.xls  WBC_FTTC_Price_List_Entry_16-Aug-10.xls

$ unoconv -f csv *.xls 

$ ls *.csv
ie_data.csv  QTL_Sample_data.csv  WBC_FTTC_Price_List_Entry_16-Aug-10.csv

So you just need to get it up and running and it'll do what you want.

Ubuntu – Comparing two text files

Try this command:

 grep -v -f file2.csv file1.csv > file3.csv

According to grep manual:

  -f FILE, --file=FILE
          Obtain  patterns  from  FILE,  one  per  line.   The  empty file
          contains zero patterns, and therefore matches nothing.   (-f  is
          specified by POSIX.)

  -v, --invert-match
          Invert the sense of matching, to select non-matching lines.  (-v
          is specified by POSIX.)

As Steeldriver said in his comment is better add also -x and -F that:

  -F, --fixed-strings
          Interpret PATTERN as a  list  of  fixed  strings,  separated  by
          newlines,  any  of  which is to be matched.  (-F is specified by
          POSIX.)
  -x, --line-regexp
          Select  only  those  matches  that exactly match the whole line.
          (-x is specified by POSIX.)

So, better command is:

 grep -xvFf file2.csv file1.csv > file3.csv

This command use file2.csv line as pattern and print line of file1.csv that doesn't match (-v).

Best Answer

Related Solutions

Ubuntu – Converting XSL files to CSV files in command line

Ubuntu – Comparing two text files

Related Question