导入Excel到数据库:import.php
require_once 'PHPExcel/Excel.php';
$config = array(
'fields'=>array('name','tel','email','date'),
'datefield'=>array('date'),
);
$excel = new \wdphp\Excel($config);
$data = $excel->import('demo.xlsx');
/* 如需写入数据库,将$data foreach循环 入库即可 这里只做var_dump输出演示*/
echo '<pre>';
var_dump($data);
echo '</pre>';
var_dump打印结果:
array(3) {
[0]=>
array(4) {
["name"]=>
string(6) "王五"
["tel"]=>
int(1381113811)
["email"]=>
string(11) "221@163.com"
["date"]=>
string(10) "2018-07-26"
}
[1]=>
array(4) {
["name"]=>
string(6) "赵刘"
["tel"]=>
float(13800138022)
["email"]=>
string(12) "665@19jp.com"
["date"]=>
string(10) "2018-07-28"
}
[2]=>
array(4) {
["name"]=>
string(6) "李四"
["tel"]=>
float(13800138033)
["email"]=>
string(10) "751@h99.cn"
["date"]=>
string(10) "2018-08-05"
}
}
导出数据到Excel并下载:export.php
require_once 'PHPExcel/Excel.php';
$data = array (
array ( 'name' => '王五', 'tel' => 13811138000, 'email' => '221@163.com', 'date' => '2018-07-26', ),
array ( 'name' => '赵刘', 'tel' => 13800138022, 'email' => '665@19jp.com', 'date' => '2018-07-28', ),
array ( 'name' => '李四', 'tel' => 13800138033, 'email' => '751@h99.cn', 'date' => '2018-08-05', )
);
$config = array(
'datefield'=>'date',
'data'=>$data,
'fields'=>array('姓名','电话','Emial','时间'),
'savename'=>'ExcelDemo',
);
$excel = new \wdphp\Excel($config);
/* 除$data外,其他参数均为可选 */
$excel->export();