Hello,
I have an excel sheet (.xlsx), with 11 worksheets. I need to run my bash scripts on the 1st worksheet and write the output to the 2nd worksheet.
I am currently manually converting the worksheet into a tab delimited to run the script and then pasting it back to excel.
Is there a way to do this in bash as there are several excel sheets to work on ?
Thank you.
Several posts, including:
Hello, I have gone through most of the questions on the forums but none of them have quite helped me to what I want. For example, I tried xls2csv but I end up with an error
xls2csv -b Unannotated S12.xlsx > test.csv
S12.xlsx is not OLE file or Error
as well as gnumeric
ssconvert -S S12.xlsx test.csv
(ssconvert:28398): GLib-GObject-WARNING **: invalid (NULL) pointer instance