Sign in to follow this  
Followers 0
Hooch

*.xls to *.csv ? ideas ?

7 posts in this topic

I am trying to eliminate the manual process of saving a particular xls file to csv format. I want to do it via command line if at all possible. I have searched here and google'd my butt off but I am not finding anything appropriate.

Anyone have any thoughts on how I might accomplish this one?

Share this post


Link to post
Share on other sites



I am trying to eliminate the manual process of saving a particular xls file to csv format. I want to do it via command line if at all possible. I have searched here and google'd my butt off but I am not finding anything appropriate.

Anyone have any thoughts on how I might accomplish this one?

<{POST_SNAPBACK}>

...mmm hold up I may just be able to copy/paste to a text file and use tab for delim....

Share this post


Link to post
Share on other sites

...mmm nah, clunky as hell, if only I could do it all from command line...

Share this post


Link to post
Share on other sites

Is it the same file being saved over and over, or is the filename different?

Share this post


Link to post
Share on other sites

Is it the same file being saved over and over, or is the filename different?

<{POST_SNAPBACK}>

It is the same file with updated values every month.

Share this post


Link to post
Share on other sites

Pricy, but there is http://www.ozgrid.com/Services/convert-excel-csv.htm

I imagine that COM support (which is in the works for the next AutoIt release) would make this task easy....

<{POST_SNAPBACK}>

Thank Cyber, I did dig up an application that, for $120, can do what I want on the command line but I won't be able to squeeze that out of the company. I can just do it manually but I was hoping to remove as many of those steps as I can.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0