how to read the date values from excel sheet using CI

[eluser]chellam[/eluser]
how to read the date values from excel sheet using CI

[eluser]umefarooq[/eluser]
Hi i just google and found some links may be helpful for you

CI library
http://codeigniter.com/wiki/Excel_Reader_Class/

using phpexcel with CI
http://techxplorer.com/2008/12/08/using-...deigniter/

[eluser]chellam[/eluser]
do u knw how to upload the excel file to mysql table using CI..

[eluser]umefarooq[/eluser]
its better to convert you excel it csv file and upload it to mysql table. try this library really handy im using for my directory projects

http://codeigniter.com/wiki/CSVReader/

just read the whole document of the library will help you to solve your problem. if you have any question ask anytime.

[eluser]chellam[/eluser]
actually my module have a excel upload page once upload the excel i need to insert the excel data into mysql. but the string ,numbers are properly reading the excel reader ,except the date value ..
example '2009-11-29' its coming like 45565.i need the exact date.if u knw help me ..
thank you...

[eluser]umefarooq[/eluser]
i told you earlier just convert you excel file to csv file because excel files has complex header and csv file has simple header and really easy to parse the data and put in mysql.

[eluser]KKS[/eluser]
I'm using codeigniter excel reader library to read xls file.
$this->load->library('excel_reader');

How can i get the names of the all the sheets,