@TOC`
public function import(){
if (Request::method() == 'POST') {
//获取表格的大小,限制上传表格的大小5M
if (isset($_FILES['inputExcelclass'])) {
$file_size = $_FILES['inputExcelclass']['size'];
if ($file_size > 5 * 1024 * 1024) {
$this->error('文件大小不能超过5M');
exit();
}
}
//限制上传表格类型
if (isset($_FILES['inputExcelclass'])) {
$fileExtendName = substr(strrchr($_FILES['inputExcelclass']["name"], '.'), 1);
//application/vnd.ms-excel 为xls文件类型
if ($fileExtendName != 'xls' && $fileExtendName != 'xlsx') {
$this->error('必须为excel表格,且必须为xls格式!');
exit();
}
// 有Xls和Xlsx格式两种
if ($fileExtendName == 'xlsx') {
$objReader = IOFactory::createReader('Xlsx');
} else {
$objReader = IOFactory::createReader('Xls');
}
$objReader->setReadDataOnly(TRUE);
$filename = $_FILES['inputExcelclass']['tmp_name'];
$objPHPExcel = $objReader->load($filename); //$filename可以是上传的表格,或者是指定的表格
$sheet = $objPHPExcel->getSheet(0); //excel中的第一张sheet
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
\PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn);
$lines = $highestRow - 1;
if ($lines <= 0) {
$this->error('excel表格,没有数据!');
}
//循环读取excel表格,整合成数组。如果是不指定key的二维,就用$data[i][j]表示。
for ($j = 2; $j <= $highestRow; $j++) {
$data[$j - 2] = [
'title' => trim($objPHPExcel->getActiveSheet()->getCell("A" . $j)->getValue()),
'content' => trim($objPHPExcel->getActiveSheet()->getCell("B" . $j)->getValue()),
'prices' => trim($objPHPExcel->getActiveSheet()->getCell("C" . $j)->getValue()),
'create_time' => ($objPHPExcel->getActiveSheet()->getCell("D" . $j)->getValue() -</