1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
| <?php
|
| use PhpOffice\PhpSpreadsheet\Chart\Chart;
| use PhpOffice\PhpSpreadsheet\Chart\DataSeries;
| use PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues;
| use PhpOffice\PhpSpreadsheet\Chart\Layout;
| use PhpOffice\PhpSpreadsheet\Chart\Legend;
| use PhpOffice\PhpSpreadsheet\Chart\PlotArea;
| use PhpOffice\PhpSpreadsheet\Chart\Title;
| use PhpOffice\PhpSpreadsheet\IOFactory;
| use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
| require __DIR__ . '/../Header.php';
|
| $spreadsheet = new Spreadsheet();
| $worksheet = $spreadsheet->getActiveSheet();
| $worksheet->fromArray(
| [
| ['', 2010, 2011, 2012],
| ['Jan', 47, 45, 71],
| ['Feb', 56, 73, 86],
| ['Mar', 52, 61, 69],
| ['Apr', 40, 52, 60],
| ['May', 42, 55, 71],
| ['Jun', 58, 63, 76],
| ['Jul', 53, 61, 89],
| ['Aug', 46, 69, 85],
| ['Sep', 62, 75, 81],
| ['Oct', 51, 70, 96],
| ['Nov', 55, 66, 89],
| ['Dec', 68, 62, 0],
| ]
| );
|
| // Set the Labels for each data series we want to plot
| // Datatype
| // Cell reference for data
| // Format Code
| // Number of datapoints in series
| // Data values
| // Data Marker
| $dataSeriesLabels = [
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Worksheet!$C$1', null, 1), // 2011
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Worksheet!$D$1', null, 1), // 2012
| ];
| // Set the X-Axis Labels
| // Datatype
| // Cell reference for data
| // Format Code
| // Number of datapoints in series
| // Data values
| // Data Marker
| $xAxisTickValues = [
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Worksheet!$A$2:$A$13', null, 12), // Jan to Dec
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Worksheet!$A$2:$A$13', null, 12), // Jan to Dec
| ];
| // Set the Data values for each data series we want to plot
| // Datatype
| // Cell reference for data
| // Format Code
| // Number of datapoints in series
| // Data values
| // Data Marker
| $dataSeriesValues = [
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Worksheet!$C$2:$C$13', null, 12),
| new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Worksheet!$D$2:$D$13', null, 12),
| ];
|
| // Build the dataseries
| $series = new DataSeries(
| DataSeries::TYPE_RADARCHART, // plotType
| null, // plotGrouping (Radar charts don't have any grouping)
| range(0, count($dataSeriesValues) - 1), // plotOrder
| $dataSeriesLabels, // plotLabel
| $xAxisTickValues, // plotCategory
| $dataSeriesValues, // plotValues
| null, // plotDirection
| null, // smooth line
| DataSeries::STYLE_MARKER // plotStyle
| );
|
| // Set up a layout object for the Pie chart
| $layout = new Layout();
|
| // Set the series in the plot area
| $plotArea = new PlotArea($layout, [$series]);
| // Set the chart legend
| $legend = new Legend(Legend::POSITION_RIGHT, null, false);
|
| $title = new Title('Test Radar Chart');
|
| // Create the chart
| $chart = new Chart(
| 'chart1', // name
| $title, // title
| $legend, // legend
| $plotArea, // plotArea
| true, // plotVisibleOnly
| 0, // displayBlanksAs
| null, // xAxisLabel
| null // yAxisLabel - Radar charts don't have a Y-Axis
| );
|
| // Set the position where the chart should appear in the worksheet
| $chart->setTopLeftPosition('F2');
| $chart->setBottomRightPosition('M15');
|
| // Add the chart to the worksheet
| $worksheet->addChart($chart);
|
| // Save Excel 2007 file
| $filename = $helper->getFilename(__FILE__);
| $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
| $writer->setIncludeCharts(true);
| $callStartTime = microtime(true);
| $writer->save($filename);
| $helper->logWrite($writer, $filename, $callStartTime);
|
|
