//导入文件
//从excel表格中读取信息
$PHPExcel= new PHPExcel();
$extension = strtolower(pathinfo($name, PATHINFO_EXTENSION));
//不同文件后缀的读取
if ($extension =='xlsx') {
$PHPReader = new PHPExcel_Reader_Excel2007();
$PHPExcel = $PHPReader ->load($path.$name);
} else if ($extension =='xls') {
$PHPReader = new PHPExcel_Reader_Excel5();
$PHPExcel = $PHPReader ->load($path.$name);
} else if ($extension=='csv') {
$PHPReader = new PHPExcel_Reader_CSV();
//默认输入字符集
$PHPReader->setInputEncoding('GBK');
//默认的分隔符
$PHPReader->set
php 上传文件读取多个工作表总结
最新推荐文章于 2022-07-27 11:26:16 发布