Thinkphp6之PhpspreadSheet（2）导出数据库存入excel表

<?php
namespace app\controller;

use app\BaseController;
use think\facade\DB;
use think\facade\View;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
class Sheet extends BaseController
{
  public function index()
{
      # 实例化 Spreadsheet 对象
      $spreadsheet = new Spreadsheet();
      # 获取活动工作薄
      $sheet = $spreadsheet->getActiveSheet();
      # 获取单元格
      $cell = $sheet->getCell('A1');
      //$cell = $sheet->getCellByColumnAndRow(1,1);
      var_dump($sheet);
  }

  private function excel($title = [], $data = [], $path = '')
{
    // 获取Spreadsheet对象
      $spreadsheet = new Spreadsheet();
      $sheet = $spreadsheet->getActiveSheet();
    // 表头单元格内容 第一行
    $titCol = 'A';
      foreach ($title as $value) {
          // 单元格内容写入
          $sheet->setCellValue($titCol . '1', $value);
          $titCol++;
      }  
      // 从第二行开始写入数据
      $row = 2;
      foreach ($data as $item) {
          $dataCol = 'A';
          foreach ($item as $value) {
              // 单元格内容写入
              $sheet->setCellValue($dataCol . $row, $value);
              $dataCol++;
          }
          $row++;
      }
      $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
      $result = $writer->save($path . '.xlsx');
  }
  public function t1()
{
    $data = Db::table('stu_test')->select();
    //dump($data);
    $title = ['ID','班级','学号','姓名','语文','数学','英语','政治','历史','物理','化学','体育','总分','班名次','级名次','镇名次','上次','进步'];
    $this->excel($title, $data, $filename = './excel/03');

  }                    
}