Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
F1
 
Posts: n/a
Default How do i convert excel to csv in command line? ( not save as)


I am trying to automate a system which needs the files in csv format.

Is there any way to convert excel to csv in command line, instead of the
usual 'save as'?

PS: If you know any UNIX utilities too, please mention.

  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

F1,

No way I can think of from the command line. You could write an Excel macro
that controls the whole process. Open a file, save as csv, close, next
file, loop.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"F1" wrote in message
...

I am trying to automate a system which needs the files in csv format.

Is there any way to convert excel to csv in command line, instead of the
usual 'save as'?

PS: If you know any UNIX utilities too, please mention.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert Excel 2003 to Excel 98 format? Lady Layla New Users to Excel 8 March 31st 05 12:47 AM
How can I convert an Excel file to someone who doesn't have Excel. donnythejazz Excel Discussion (Misc queries) 3 March 30th 05 11:59 PM
How do I convert a csv file to an Excel file? Anne B Excel Discussion (Misc queries) 2 March 29th 05 09:17 PM
Convert HTML into an Excel skydiving99 Excel Worksheet Functions 1 March 18th 05 11:35 PM
Improve Convert function in Excel Mike VV Excel Worksheet Functions 0 February 3rd 05 04:45 AM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"