Using phpexcel to export and import data. Currently, two data format problems have emerged. & nbsp; illegal phrase & nbsp; only ------ solution -------------------- include & nbsp; PluginPHPExcelClassesPHPExcelIOFactory. php; $ excel & nbsp; PHPExcel_IOFac using phpexcel for export and import. Currently, two data format problems have occurred.
The release says there are illegal phrases.
------ Solution --------------------
Include 'plugin/PHPExcel/Classes/PHPExcel/IOFactory. php ';
$ Excel = PHPExcel_IOFactory: load('2.xls ');
$ Sheet = $ excel-> getActiveSheet ();
Echo $ sheet-> getCell ('A1')-> getValue (), '', $ sheet-> getCell ('A2 ')-> getValue ();
5.9335552883783E + 14 41728.732916667.
What should I do if I read it out?
Think about it.
------ Solution --------------------
First solve the problem of time
The read time is the number of days.
The excel date is calculated starting from (php is from)
There is a day difference between the two: 25569
The time is Greenwich Mean Time.
So there are
USD d = 25569;
$ T = 24*60*60;
Echo gmdate ('Y-m-d H: I: S', (41728.732916667-$ d) * $ t );
2014-03-30 17:35:24
