php导入excel文件_php实现excel表共享

php导入excel文件_php实现excel表共享 phpExcel早已停止维护，现在都用phpSpreadSheet。

网上那些phpSpreadSheet教程都啰里啰唆，叨叨这个那个，没个能打的~还得看我这个，代码拷走，改改就能用，就是这么粗鲁！安装composer require phpoffice/phpspreadsheet代码<?phpdeclare (strict_types = 1);namespace app\controller;use think\Request;use think\facade\View;use think\facade\Db;use PhpOffice\PhpSpreadsheet\Cell\Coordinate;use PhpOffice\PhpSpreadsheet\IOFactory;use PhpOffice\PhpSpreadsheet\Spreadsheet;use PhpOffice\PhpSpreadsheet\Writer\Csv;use PhpOffice\PhpSpreadsheet\Writer\Xlsx;class Xiangmu{public function exportExcel(){// 查询要导出的数据$data = Db::query(“select project,price from xiangmu”);// 实例化$spreadsheet = new Spreadsheet();// 获取活动单元格$sheet = $spreadsheet->getActiveSheet();// 获取单元格$cellA = $sheet->getCell(‘A1’);// 设置单元格的值$cellA->setValue(‘项目名称’);// 设置 A 列 列宽$sheet->getColumnDimension(‘A’)->setWidth(100);// 设置第一行 行高$sheet->getRowDimension(1)->setRowHeight(20);$cellB = $sheet->getCell(‘B1’);$cellB->setValue(‘ *** 作人’);$sheet->getColumnDimension(‘B’)->setWidth(20);$cellC = $sheet->getCell(‘C1’);$cellC->setValue(‘检测量’);$sheet->getColumnDimension(‘C’)->setWidth(10);// 设置样式 标题$styleArray = [‘alignment’ => [‘horizontal’ => ‘center’, //水平居中‘vertical’ => ‘center’, //垂直居中],‘font’ => [‘name’ => ‘黑体’,‘bold’ => false,‘size’ => 10]];// 设置样式 正文$styleArrayBody = [‘alignment’ => [‘horizontal’ => ‘center’, //水平居中‘vertical’ => ‘center’, //垂直居中],‘font’ => [‘name’ => ‘宋体’,‘bold’ => false,‘size’ => 10]];// 应用样式$sheet->getStyle(‘A1’)->applyFromArray($styleArray);$sheet->getStyle(‘B1’)->applyFromArray($styleArray);$sheet->getStyle(‘C1’)->applyFromArray($styleArray);// 给sheet起个名字$sheet->setTitle(‘项目’);// 从 A2 开始填充数据foreach ($data as $k => $v) {$n = $k + 2;// 获取单元格$cellA = $sheet->getCell(‘A’ . $n);// 设置单元格的值$cellA->setValue($v[‘project’]);$cellB = $sheet->getCell(‘B’ . $n);$cellB->setValue(‘民族复兴不可阻挡’);$cellC = $sheet->getCell(‘C’ . $n);$cellC->setValue($v[‘price’]);}$file_name = ‘导出数据.xlsx’;// 实例化导出类header(‘Content-Type:application/vnd.ms-excel’);header(‘Content-Disposition:attachment;filename=’ . $file_name);header(‘Cache-Control:max-age=0’);$writer = IOFactory::createWriter($spreadsheet, ‘Xlsx’);$writer->save(‘php://output’);}}上面代码直接保存成一个.php文件，就能用。