parsing excel file 2

[theEclipse]

I am about to start a part of a project that requires parsing an excel file (120 rows x 12 columns) and inserting that data into mySql.

I searched here and found lots of people wanting to go the other way (sql -> excel) but cant seem to find anyone that wants to read an excel file. I suppose that might mean that I am missing something completly obvious.



Robert Carpenter
"You and I have need of the strongest spell that can be found to wake us from the evil enchantment of worldliness." - C.S. Lewis (The Weight of Glory)

http://www.robertcarpenter.net

 

[kenrbnsn]

The most obvious way would be to save the data in a csv file and use the functions fgetcsv() (

http://www.php.net/fgetcsv)

to read the CSV file.

Ken

 

[theEclipse]

I was missing something completly obvious!

Robert Carpenter
"You and I have need of the strongest spell that can be found to wake us from the evil enchantment of worldliness." - C.S. Lewis (The Weight of Glory)

http://www.robertcarpenter.net

 

[ingresman]

Windows has an ODBC driver that will read .xls files. Each sheet is a table and you have rows and cols from there. It's really straightforward. If you need some help reply here.

 

[theEclipse]

ing-

Thanks for the tip but (un)fourtunately we run linux servers.
I will be processing the excel file as a csv as kenrbnsn suggested.

Robert Carpenter
"Disobedience to conscience is voluntary; bad poetry, on the other hand, is usually not made on purpose." - C.S. Lewis (Preface to Paradise Lost)
ô¿ô

http://www.robertcarpenter.net

 

[LinuXelite]

Use Excel XML format. I force my users to use OpenOffice or MS OFFICE 2003. They save their document as Office XML file. Quite easy to parse.

 

[theEclipse]

linuxElite-

I like that idea because I dont have much expirence with XML files....it would force me to learn them.

thread68-1084677 in the MS office forum about getting excel to behave.

thanks!

Robert Carpenter
"Disobedience to conscience is voluntary; bad poetry, on the other hand, is usually not made on purpose." - C.S. Lewis (Preface to Paradise Lost)
ô¿ô

http://www.robertcarpenter.net