test.php 554 B

12345678910111213141516171819202122232425
  1. <?php
  2. $config = [
  3. 'path' => './tests'
  4. ];
  5. $fileObject = new \Vtiful\Kernel\Excel($config);
  6. $fileObject = $fileObject->fileName('tutorial.xlsx');
  7. $fileHandle = $fileObject->getHandle();
  8. $chart = new \Vtiful\Kernel\Chart($fileHandle, \Vtiful\Kernel\Chart::CHART_LINE);
  9. $chartResource = $chart->series('Sheet1!$A$2:$A$7')->toResource();
  10. $filePath = $fileObject->header(['number'])
  11. ->data([
  12. [10],
  13. [40],
  14. [50],
  15. [20],
  16. [10],
  17. [50],
  18. ])
  19. ->insertChart(0, 3, $chartResource)
  20. ->output();