phpexcel早已停止维护，现在都用phpspreadsheet。

网上那些phpspreadsheet教程都啰里啰唆，叨叨这个那个，没个能打的~

还得看我这个，代码拷走，改改就能用，就是这么粗鲁！

安装

compor require phpoffice/phpspreadsheet

代码

<?php

declare (strict_types = 1);

namespace app\controller;

u think\request;

u think\facade\view;

u think\facade\db;

u phpoffice\phpspreadsheet\cell\coordinate;

u phpoffice\phpspreadsheet\iofactory;

u phpoffice\phpspreadsheet\spreadsheet;

u phpoffice\phpspreadsheet\writer\csv;

u phpoffice\phpspreadsheet\writer\xlsx;

class xiangmu

{

public function exportexcel()

{

// 查询要导出的数据

$data = db::query(“lect project,price from xiangmu”);

// 实例化

$spreadsheet = new spreadsheet();

// 获取活动单元格

$sheet = $spreadsheet->getactivesheet();

// 获取单元格

$cella = $sheet->getcell(‘a1’);

// 设置单元格的值

$cella->tvalue(‘项目名称’);

// 设置 a 列 列宽

$sheet->getcolumndimension(‘a’)->twidth(100);

// 设置第一行 行高

$sheet->getrowdimension(1)->trowheight(20);

$cellb = $sheet->getcell(‘b1’);

$cellb->tval我的世界下雪了ue(‘操作人’);

$sheet->getcolumndimension(‘b’)->twidth(20);

$cellc = $生源所在地怎么填sheet->getcell(‘c1’);

$cellc->tvalue(‘检测量’);

$sheet->getcolumndimension(‘c’)->twidth(10);

// 设置样式 标题

漂亮孕妇

$stylearray = [

‘alignment’ => [

‘horizontal’ => ‘center’, //水平居中

‘vertical’ => ‘center’, //垂直居中

],

‘font’ => [

‘name’ => ‘黑体’,

‘bold’ => fal,

‘size’ => 10

]

];

// 设置样式 正文

$stylearraybody = [

‘alignment’ => [

‘horizontal’ => ‘center’, //水平居中

‘vertical’ => ‘center’, //垂直居中

],

‘font’ => [

‘name’ => ‘宋体’,

‘bold’ => fal,

‘size’ => 10

]

];

// 应用样式

$sheet->getstyle(‘a1’)->applyfromarray($stylearray);

$sheet->getstyle(‘b1’)->applyfromarray($描写角度stylearray);

$sheet->getstyle(‘c1’)->applyfromarray($stylearray);

// 给sheet起个名字

$sheet->ttitle(‘项目’);

// 从 a2 开始填充数据

foreach ($data as $k => $v) {

$n = $k + 2;

// 获取单元格

$cella = $sheet->getcell(‘a’ . $n);

// 设置单元格的值

$cella->tvalue($v[‘project’]);职高是什么学历

$cellb = $sheet->getcell(‘b’ . $n);

$cellb->tvalue(‘民族复兴不可阻挡’);

$cellc = $sheet->getcell(‘c’ . $n);

$cellc->tvalue($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文件，就能用。