$PHPExcel = new PHPExcel(); //实例化PHPExcel类,类似于在桌面上新建一个Excel表格
$re_path="d:/bill.xlsx";
$obj_reader = \PHPExcel_IOFactory::createReaderForFile($re_path);
$obj_excel = $obj_reader->load($re_path, $encode = "utf-8");
if (!$obj_excel) {
$res["code"] = 2;
$res["msg"] = "文件读取失败";
return $res;
}
$excel_array = $obj_excel->getSheet(0)->toArray();
dump($excel_array);
/*
// 获取sheet数量
$sheet_len = $obj_excel->getSheetCount();
// dump($sheet_len);
for ($i = 0; $i < $sheet_len; $i++) {
// excel表格内容转换为数组
$excel_array = $obj_excel->getSheet($i)->toArray();
dump($excel_array);
}
*/