phpoffice/spreadsheet如何在图表中向每一列添加值

composer require phpoffice/spreadsheet

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Chart\Chart;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$sheet->setCellValue('A1', 'Column 1');
$sheet->setCellValue('B1', 'Column 2');
$sheet->setCellValue('C1', 'Column 3');

$chart = new Chart('ColumnChart');
$chart->setCategories($sheet->getCellRangeByColumnAndRow(1, 2, 1, $sheet->getHighestRow()));
$chart->setValues($sheet->getCellRangeByColumnAndRow(2, 2, 2, $sheet->getHighestRow()));

$sheet->addChart($chart);
$chart->setTopLeftPosition('E1');
$chart->setBottomRightPosition('K10');

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
$writer->save('example.xlsx');