I'm trying to convert a .csv file to Excel using unix shell script. Tried the below script but it didn't work.
./csv2xls -csv-file-name="file1.csv" -xls-file-name="file1.xls" -csv-delimiter="|"
I tried using the below script to convert csv to unix format
dos2unix file1.csv
Not sure how to convert it to Excel format.
Can anyone guide how to convert this using bash shell script?
Thank in advance!
CodePudding user response:
You can simply can use ssconvert
ssconvert file1.csv file1.xlsx