Sign in to follow this  
Followers 0
igmeou

Convert .xls to .csv

5 posts in this topic

Hi guys,

I have this job nowadays where I need to download some attachment from my email to a specfic folder on my desktop. Then from there I need to unzip a zip file which contains a lot of excel files that is needed to be converted to csv files so that it can be imported into my database.

Due to having these lots of files, I thought of writing a script to automate this. The main issue is that I need the excel files to be converted to .CSV files.

Please advice.


[font="Arial"]Thanks[/font]
If @error = me Then $sorry
Else
   Do
      $clarifyMe
   Until $meClear
EndIF
MsgBox(0,"Special Message!","Special Thanks to " & $allHadReplied,$Forever)

Share this post


Link to post
Share on other sites



can't you just rename the .xsl to the .csv?

Share this post


Link to post
Share on other sites

No, its different formats. I would suggest opening each file, one at a time, and just do a File->Save As...There's no easy way to just do file manipulation. Make it easy and let Excel do it for you.


Writing AutoIt scripts since
_DateAdd("d", -2, _NowCalcDate())

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

You can make an Excel macro which runs automatically whenever a file is opened. The conversion can thus be done in Excel macro; all you need to do is send the xls files to Excel.

J

PS Thanks Cyclops (see below). That's actually what I was looking for to suggest.

Edited by jdickens

If I am too verbose, just say so. You don't need to run on and on.

Share this post


Link to post
Share on other sites

or for converting you could use an external freeware like convert-xls


Sorry for my cruel english :D

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