CODEWITHSUNDEEP
excelbashshellcsvcmd
user1948847
user1948847

Reputation: 995

save csv file as excel files using shell

is there anyway to save csv file as an excel files using shell scripts/command prompt?

I know that I can do it manually via the save as in the excel gui, but how do I make it an automated process?

Thanks!

Upvotes: 3

Views: 5426

Answers (3)

V H
V H

Reputation: 8587

Take a look at http://www.perlmonks.org/?node_id=635437 You can use Perl Modules to parse and write Excel spread sheets.

You will need:

https://metacpan.org/pod/Spreadsheet::WriteExcel
and
https://metacpan.org/pod/Text::CSV::Simple

or 

sudo apt-get install libspreadsheet-writeexcel-perl libtext-csv-perl

Then that script should work for you -

Upvotes: 0

Larry1833681
Larry1833681

Reputation: 186

csv2odf:

csv2odf data.csv template.xlsx output.xlsx

Upvotes: 4

ds440
ds440

Reputation: 891

If you don't mind doing it from within Excel, you can probably do something with VBA which will process multiple files at the same time.

Rather like: http://www.go4expert.com/forums/convert-xls-csv-using-vbscript-t18188/ but changing the saveas type.

Upvotes: 0

Related Questions