保持图表/图形样式 [英] Keep chart/graph style

问题描述

读取和写入xlsx文件时是否可以保留图表样式(形状样式)?在下面的代码中，样式丢失了.

Is it possible to keep the chart style (shape styles) from a xlsx file when I read and write it? With my code below the style is lost .

require 'vendor/autoload.php';



use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx AS WXlsx;
use PhpOffice\PhpSpreadsheet\Chart\Chart;
use PhpOffice\PhpSpreadsheet\Settings;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;


echo "Opening file...<br>";
$spreadsheet = new Xlsx();
$spreadsheet->setIncludeCharts(true);
$spreadsheet = $spreadsheet->load("test.xlsx");

echo "Saving file...<br>";
$fileName = "testKeepChart.xlsx";
$writer = new WXlsx($spreadsheet);
$writer->setIncludeCharts(true);
$writer->setPreCalculateFormulas(false);
$writer->save($fileName);

echo "File saved as $fileName.\n";

推荐答案

当使用excel之类的模板(来自现有文件)时，将不会加载图表.发出在此处报告，尽管可能不会得到解决.

When using excel like templates (from existing files), charts won't load. Issue reported here, though probably won't be fixed.

这篇关于保持图表/图形样式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！