Try to copy the data from CSV file to XLS using shell scripting

P. BHAVANA 0
Viewed 27

Input file: a.csv

eid,ename,esal 345,megha,7890 898,sunil,9870 247,vignesh,5649 893,mahi,6542 496,ram,3598

ouput file: v.xls

awk sed unix
2 Answers

There is no Unix command that will create an Excel file out of a text file.

Andy Lester0

UNIX command to copy the data from txt file to XLS

If you are allowed to install tools you might try ssconvert which is companion to Gnumeric. Firstly successfully install gnumeric and then you should be able to use ssconvert like so

ssconvert file.csv file.xls
Daweo0
Related