CODEWITHSUNDEEP
excelbashcsv
Vivek Soni
Vivek Soni

Reputation: 3

get sheetname from xlsx2csv linux command

I want to extract text from the excel file so i used xlsx2csv command

the text extracted does not give me sheetname

I have used command as :
/usr/bin/xlsx2csv #{excel_name}.xls >> #{excel_name}.txt

Can we get sheetname from using xlsx2csv??

Upvotes: 0

Views: 2696

Answers (1)

anishsane
anishsane

Reputation: 20980

Try:

xlsx2csv -s 0 ${excel_name}.xlsx >> ${excel_name}.txt

From man xlsx2csv:

   -s SHEETID, --sheet=SHEETID
       Sheet to convert (0 for all sheets).

Upvotes: 2

Related Questions