save csv file as excel files using shell

Question

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!

You can use vbscript to do this. support.microsoft.com/kb/198703 — Tim Williams
– Tim Williams, Commented Feb 28, 2013 at 19:27

Larry1833681 · Accepted Answer · 2013-03-08 05:57:20Z

4

csv2odf data.csv template.xlsx output.xlsx

answered Mar 8, 2013 at 5:57

Larry1833681

1864 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

this works on both windows and linux, and tiny enough compared to the huge dependencies of ssconvert/gnumeric. thanks

ds440 · Accepted Answer · 2013-02-28 19:27:30Z

0

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.

answered Feb 28, 2013 at 19:27

ds440

8911 gold badge6 silver badges18 bronze badges

sid_com · Accepted Answer · 2014-04-09 11:30:27Z

0

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:

or

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

Then that script should work for you -

sid_com

25.4k28 gold badges104 silver badges193 bronze badges

answered Feb 28, 2013 at 21:03

V H

8,6372 gold badges30 silver badges48 bronze badges