``` $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx'); # 打开文件、载入excel表格 $spreadsheet = $reader->load('1.xlsx'); # 获取活动工作薄 $sheet = $spreadsheet->getActiveSheet(); # 获取 单元格值 和 坐标 $cellC1 = $sheet->getCell('B2'); echo '值: ', $cellC1->getValue(),PHP_EOL; echo '坐标: ', $cellC1->getCoordinate(),PHP_EOL;//B2 // $sheet->setCellValue('B2','欧阳锋'); # 获取总列数 即从左至右显示列的最后一个 $total_Column = $sheet->getHighestColumn(); dump($total_Column);//B # 列数 改为数字显示 $total_ColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($total_Column); dump( $total_ColumnIndex);//2 # 获取总行数 $total_row = $sheet->getHighestRow(); dump($total_row);//3 $log = []; //$row_number=2 是排除地一行的标题 for($row_number=2; $row_number <= $total_row; $row_number++){ $title = $sheet->getCellByColumnAndRow(1,$row_number)->getValue(); $cat_fname = $sheet->getCellByColumnAndRow(2,$row_number)->getValue(); $cat_name = $sheet->getCellByColumnAndRow(3,$row_number)->getValue(); $price = $sheet->getCellByColumnAndRow(4,$row_number)->getValue(); $img = $sheet->getCellByColumnAndRow(5,$row_number)->getValue(); // $cat_fid = find('shop_cat','id','name="'.$cat_fname.'"'); // $cat_id = find('shop_cat','id','name="'.$cat_name.'"'); // getFieldValue('user','name'); $data = [ 'title' => $title, 'cat_fname'=>$cat_fname, 'cat_name'=>$cat_name, // 'cat_id' => $cat_id['id'], 'price' => $price, 'img' => $img, 'add_time' => time(), ]; dump('第'.$row_number.'条'); dump($data); //插入数据库 // ... } ```