Page 1 of 1
Excel - CSV ?
Posted: Thu Jan 06, 2005 7:56 pm
by Steveo31
I'm lookin for a way to get Excel data to CSV, in which I can deal with it in PHP to put into MySQL. I'm havin probs figuring where to start. I thohgt Excel could export directly to CSV, but I can't find anything on it.

Posted: Thu Jan 06, 2005 7:56 pm
by markl999
In Excel File->Save As has a CSV option (in the save as type drop down).
Posted: Thu Jan 06, 2005 7:58 pm
by feyd
File > Save As...
Scroll down the pull down to CSV.
There's probably a macro you can create to do it too, dunno it though as I hate scripting Excel.
mark beat me!

*bang-bang-bang*
Posted: Thu Jan 06, 2005 7:58 pm
by markl999
whahahahah

Posted: Thu Jan 06, 2005 8:55 pm
by Steveo31
Doh... duh. Hah, saw that right after I posted.
Why this get moved? I guess I ..yeah, I didn't make clear what I'm trying to do. I think there's some regex involved.. I need to get those values in an easy to use fashion. Not askin someone to do it for me, but is regex what I'm after?
Posted: Thu Jan 06, 2005 8:56 pm
by markl999
Is
fgetcsv what you want? Works for me
