Fetching Values From Excel

[ashinaidu]

Hello ,
I want to fetch values from [FONT=Arial]excel sheet and store it into mysql database[/FONT]. I also searched for this But i could only find the code for (fetching values from mysql database and storing it into Excel Sheet.)

Any Help would be use,

Thanks

[jackiw]

I don't think there's a way to open Excell files with readable data on it without using Excell because Microsoft encrypts the data on the files. An alternative would be saving your XLS files to CSV(comma separated values), so this way you could open the file, maniputalte it and store the data on your mysql db.