I need a batch file covertor, xlsx to csv

[formula_2002]

Any help would be appreciated..

thanks
Formula

[ranchwest]

How about Excel?

[formula_2002]

How about Excel?
how about it!!
did you find a batch file convertor in the excel software?

I've used the "save file as...csv".. but I have never used their batch file conversion. They have one?

[DJofSD]

Did you try a search of the internet using "xlsx converter csv"?

I did. Here's one hit: http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm

[formula_2002]

Did you try a search of the internet using "xlsx converter csv"?

I did. Here's one hit: http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm
I did.. not happy with "free downlods" and then you have to give your first born to them :)

I'm looking for another alternative..like FREE :cool:

[Jeff P]

Joe,

Are you just looking to convert file extensions for a bunch of files sitting on a folder from one character string to another?

For example, are you looking to:

1. Be able to programmatically find all files on a folder with the characters "FINDTHESE" (without the quotes) as part of the file name that also have the characters ".OLD" (again without the quotes) as the file extension?

2. And change the file extension for all files fitting that description to the characters ".NEW" (again without the quote chars.)

Note that there's nothing special about the characters "FINDTHESE", ".OLD", and ".NEW." Just using them as examples. In real life the character strings could be anything you need them to be.

Is that what you are looking to do?



-jp

.

[formula_2002]

Joe,

Are you just looking to convert file extensions for a bunch of files sitting on a folder from one character string to another?

For example, are you looking to:

1. Be able to programmatically find all files on a folder with the characters "FINDTHESE" (without the quotes) as part of the file name that also have the characters ".OLD" (again without the quotes) as the file extension?

2. And change the file extension for all files fitting that description to the characters ".NEW" (again without the quote chars.)

Note that there's nothing special about the characters "FINDTHESE", ".OLD", and ".NEW." Just using them as examples. In real life the character strings could be anything you need them to be.

Is that what you are looking to do?



-jp

.


Hi jeff
I need to convert an ".xlsx" file format to a ".csv" file format.
That singular conversion can be done within excel, but I have a hundred or so files I want to convert. A batch file conversion is required
I can then import those files into DBase for analysis.

[DJofSD]

See if this gives you any ideas: http://msdn.microsoft.com/en-us/office/Video/cc527466

[Jeff P]

You might approach it by writing VBA code to be executed from within Excel to do the following:

1. Instantiate the File System Object - so that all files having an .xls file extension on a given folder are exposed.

2. Looping through the exposed files handling them one at a time. If the current file being handled is an .xls file, simply convert it to a .csv file using the SaveAs method in Excel's object model.

You might find these threads useful:
http://63.236.73.220/showthread.php?t=569238

http://www.vbforums.com/showthread.php?t=408487


An alternative option would be to process them manually one at a time.


-jp

.

[Red Knave]

The newest MSOffice files are 'just' zipped XML files so you may be able to unzip them to xml and then run them through a converter like the one here http://a7soft-xml2csv.a7soft.qarchive.org/

[hcap]

Any help would be appreciated..

thanks
FormulaI had set something up to do a similar operation. Modified it without a chance to really debug. Tried some files seems ok. Check your PM's.

[formula_2002]

To all. thanks for your help..
I have one other option left to me if I can work it out.

I 'll let you know how it comes along

[DJofSD]

Please do. Seriously.

[dukeofperl]

Any help would be appreciated..

thanks
Formula

I created a xls(x) -> csv program a while back for a client. It runs in batch mode and will automatically detect whether the input file(s) are xls or xlsx and apply the correct conversion.

In it's current state it runs on the command line (DOS window) with a list of arguments (files names) to be converted.

If you're interested in trying it, I'll dig it out of my archives and post it for download.

[raybo]

When all else fails, and you need Excel/VBA help, try the forum at http://www.mrexcel.com/

[formula_2002]

With the help of Michel Mercier of WinTask I've been able to get a batch file conversion scrip working.
Talk about customer service! He has helped me for several years.

I highly recommend WinTask and MM.
Just google it..