+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: how to read the date values from excel sheet using CI (/showthread.php?tid=25060)
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[eluser]chellam[/eluser]
how to read the date values from excel sheet using CI
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[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-phpexcel-with-codeigniter/
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[eluser]chellam[/eluser]
do u knw how to upload the excel file to mysql table using CI..
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[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.
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[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...
how to read the date values from excel sheet using CI - El Forum - 11-30-2009
[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.
how to read the date values from excel sheet using CI - El Forum - 02-25-2010
[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,