Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.137.175.83
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
collportal /
PHPExcel /
Examples /
[ HOME SHELL ]
Name
Size
Permission
Action
data
[ DIR ]
drwxrwxr-x
images
[ DIR ]
drwxrwxr-x
.gitignore
36
B
-rw-rw-r--
01pharSimple.php
4.2
KB
-rw-rw-r--
01simple-download-ods.php
3.3
KB
-rw-rw-r--
01simple-download-pdf.php
3.58
KB
-rw-rw-r--
01simple-download-xls.php
3.27
KB
-rw-rw-r--
01simple-download-xlsx.php
3.31
KB
-rw-rw-r--
01simple.php
4.78
KB
-rw-rw-r--
01simple.xls
4.5
KB
-rw-rw-r--
01simple.xlsx
6.28
KB
-rw-rw-r--
01simplePCLZip.php
3.94
KB
-rw-rw-r--
01simplePCLZip.xlsx
6.25
KB
-rw-rw-r--
02types-xls.php
7.88
KB
-rw-rw-r--
02types-xls.xls
5.5
KB
-rw-rw-r--
02types.php
8.53
KB
-rw-rw-r--
02types.xlsx
7.41
KB
-rw-rw-r--
03formulas.php
6.59
KB
-rw-rw-r--
03formulas.xls
5
KB
-rw-rw-r--
03formulas.xlsx
6.33
KB
-rw-rw-r--
04printing.php
5.16
KB
-rw-rw-r--
04printing.xls
14.5
KB
-rw-rw-r--
04printing.xlsx
15.69
KB
-rw-rw-r--
05featuredemo.inc.php
18.55
KB
-rw-rw-r--
05featuredemo.php
2.98
KB
-rw-rw-r--
06largescale-with-cellcaching-...
4.99
KB
-rw-rw-r--
06largescale-with-cellcaching-...
159.84
KB
-rw-rw-r--
06largescale-with-cellcaching-...
4.99
KB
-rw-rw-r--
06largescale-with-cellcaching-...
159.84
KB
-rw-rw-r--
06largescale-with-cellcaching....
4.93
KB
-rw-rw-r--
06largescale-with-cellcaching....
159.84
KB
-rw-rw-r--
06largescale-xls.php
4.84
KB
-rw-rw-r--
06largescale-xls.xls
803
KB
-rw-rw-r--
06largescale.php
4.85
KB
-rw-rw-r--
06largescale.xlsx
159.84
KB
-rw-rw-r--
07reader.php
2.79
KB
-rw-rw-r--
07readerPCLZip.php
2.93
KB
-rw-rw-r--
08conditionalformatting.php
8.33
KB
-rw-rw-r--
08conditionalformatting.xls
5.5
KB
-rw-rw-r--
08conditionalformatting.xlsx
6.75
KB
-rw-rw-r--
08conditionalformatting2.php
5.34
KB
-rw-rw-r--
08conditionalformatting2.xls
4.5
KB
-rw-rw-r--
08conditionalformatting2.xlsx
6.4
KB
-rw-rw-r--
09pagebreaks.php
5.14
KB
-rw-rw-r--
09pagebreaks.xls
12.5
KB
-rw-rw-r--
09pagebreaks.xlsx
7.88
KB
-rw-rw-r--
10autofilter-selection-1.php
8.48
KB
-rw-rw-r--
10autofilter-selection-1.xls
1.01
MB
-rw-rw-r--
10autofilter-selection-1.xlsx
230.18
KB
-rw-rw-r--
10autofilter-selection-2.php
8.27
KB
-rw-rw-r--
10autofilter-selection-2.xls
1.01
MB
-rw-rw-r--
10autofilter-selection-2.xlsx
230.16
KB
-rw-rw-r--
10autofilter-selection-display...
7.54
KB
-rw-rw-r--
10autofilter.php
7.68
KB
-rw-rw-r--
10autofilter.xls
10
KB
-rw-rw-r--
10autofilter.xlsx
7.28
KB
-rw-rw-r--
11documentsecurity-xls.php
4.2
KB
-rw-rw-r--
11documentsecurity-xls.xls
4
KB
-rw-rw-r--
11documentsecurity.php
4.21
KB
-rw-rw-r--
11documentsecurity.xlsx
6.2
KB
-rw-rw-r--
12cellProtection.php
3.83
KB
-rw-rw-r--
12cellProtection.xlsx
6.18
KB
-rw-rw-r--
13calculation.php
11.07
KB
-rw-rw-r--
13calculation.xlsx
7.29
KB
-rw-rw-r--
13calculationCyclicFormulae.ph...
3.92
KB
-rw-rw-r--
13calculationCyclicFormulae.xl...
6.05
KB
-rw-rw-r--
14excel5.php
2.31
KB
-rw-rw-r--
15datavalidation-xls.php
6.44
KB
-rw-rw-r--
15datavalidation-xls.xls
5.5
KB
-rw-rw-r--
15datavalidation.php
6.51
KB
-rw-rw-r--
15datavalidation.xlsx
6.61
KB
-rw-rw-r--
16csv.php
4.55
KB
-rw-rw-r--
17html.php
2.42
KB
-rw-rw-r--
18extendedcalculation.php
4.4
KB
-rw-rw-r--
19namedrange.php
5.32
KB
-rw-rw-r--
19namedrange.xlsx
7.39
KB
-rw-rw-r--
20readexcel5.php
2.87
KB
-rw-rw-r--
21pdf.php
3.43
KB
-rw-rw-r--
22heavilyformatted.php
4.29
KB
-rw-rw-r--
22heavilyformatted.xls
26
KB
-rw-rw-r--
22heavilyformatted.xlsx
10.42
KB
-rw-rw-r--
23sharedstyles.php
4.62
KB
-rw-rw-r--
23sharedstyles.xls
26
KB
-rw-rw-r--
23sharedstyles.xlsx
10.39
KB
-rw-rw-r--
24readfilter.php
2.62
KB
-rw-rw-r--
24readfilter.xlsx
6.74
KB
-rw-rw-r--
25inmemoryimage.html
2.75
KB
-rw-rw-r--
25inmemoryimage.php
3.65
KB
-rw-rw-r--
25inmemoryimage.xlsx
8.59
KB
-rw-rw-r--
26utf8.php
4.95
KB
-rw-rw-r--
27imagesexcel5.php
2.5
KB
-rw-rw-r--
28iterator.php
2.91
KB
-rw-rw-r--
29advancedvaluebinder.php
7.69
KB
-rw-rw-r--
29advancedvaluebinder.xls
7
KB
-rw-rw-r--
29advancedvaluebinder.xlsx
6.92
KB
-rw-rw-r--
30template.php
3.15
KB
-rw-rw-r--
31docproperties_write-xls.php
4.94
KB
-rw-rw-r--
31docproperties_write.php
4.97
KB
-rw-rw-r--
32chartreadwrite.php
4.44
KB
-rw-rw-r--
33chartcreate-area.php
4.69
KB
-rw-rw-r--
33chartcreate-area.xlsx
8.34
KB
-rw-rw-r--
33chartcreate-bar-stacked.php
4.82
KB
-rw-rw-r--
33chartcreate-bar-stacked.xlsx
8.36
KB
-rw-rw-r--
33chartcreate-bar.php
4.83
KB
-rw-rw-r--
33chartcreate-bar.xlsx
8.36
KB
-rw-rw-r--
33chartcreate-column-2.php
5.34
KB
-rw-rw-r--
33chartcreate-column-2.xlsx
8.6
KB
-rw-rw-r--
33chartcreate-column.php
4.83
KB
-rw-rw-r--
33chartcreate-column.xlsx
8.36
KB
-rw-rw-r--
33chartcreate-composite.php
6.45
KB
-rw-rw-r--
33chartcreate-composite.xlsx
8.67
KB
-rw-rw-r--
33chartcreate-line.php
4.66
KB
-rw-rw-r--
33chartcreate-line.xlsx
8.33
KB
-rw-rw-r--
33chartcreate-multiple-charts....
7.24
KB
-rw-rw-r--
33chartcreate-multiple-charts....
9.67
KB
-rw-rw-r--
33chartcreate-pie.php
6.62
KB
-rw-rw-r--
33chartcreate-pie.xlsx
9.04
KB
-rw-rw-r--
33chartcreate-radar.php
5.1
KB
-rw-rw-r--
33chartcreate-radar.xlsx
8.52
KB
-rw-rw-r--
33chartcreate-scatter.php
4.71
KB
-rw-rw-r--
33chartcreate-scatter.xlsx
8.33
KB
-rw-rw-r--
33chartcreate-stock.php
5.27
KB
-rw-rw-r--
33chartcreate-stock.xlsx
8.46
KB
-rw-rw-r--
34chartupdate.php
2.67
KB
-rw-rw-r--
34chartupdate.xlsx
8.39
KB
-rw-rw-r--
35chartrender.php
4.24
KB
-rw-rw-r--
36chartreadwriteHTML.php
5.01
KB
-rw-rw-r--
36chartreadwritePDF.php
5.76
KB
-rw-rw-r--
37page_layout_view.php
3.3
KB
-rw-rw-r--
37page_layout_view.xls
4
KB
-rw-rw-r--
37page_layout_view.xlsx
6.12
KB
-rw-rw-r--
38cloneWorksheet.php
4.24
KB
-rw-rw-r--
38cloneWorksheet.xlsx
7.39
KB
-rw-rw-r--
39dropdown.php
6.01
KB
-rw-rw-r--
39dropdown.xlsx
8.89
KB
-rw-rw-r--
40duplicateStyle.php
1.72
KB
-rw-rw-r--
40duplicateStyle.xlsx
25.94
KB
-rw-rw-r--
41password.php
3.19
KB
-rw-rw-r--
42richText.php
5.56
KB
-rw-rw-r--
42richText.xls
5.5
KB
-rw-rw-r--
42richText.xlsx
7.09
KB
-rw-rw-r--
43mergeWorkbooks.php
3.44
KB
-rw-rw-r--
44worksheetInfo.php
1.93
KB
-rw-rw-r--
Excel2003XMLReader.php
2.26
KB
-rw-rw-r--
Excel2003XMLReader.xls
15
KB
-rw-rw-r--
Excel2003XMLTest.xml
937.05
KB
-rw-rw-r--
GnumericReader.php
2.25
KB
-rw-rw-r--
GnumericReader.xlsx
14.2
KB
-rw-rw-r--
GnumericTest.gnumeric
7.64
KB
-rw-rw-r--
OOCalcReader.php
2.25
KB
-rw-rw-r--
OOCalcReader.xlsx
12
KB
-rw-rw-r--
OOCalcReaderPCLZip.php
2.38
KB
-rw-rw-r--
OOCalcReaderPCLZip.xlsx
12.03
KB
-rw-rw-r--
OOCalcTest.ods
17.51
KB
-rw-rw-r--
Quadratic.php
2.31
KB
-rw-rw-r--
Quadratic2.php
2.35
KB
-rw-rw-r--
SylkReader.php
1.86
KB
-rw-rw-r--
SylkReader.xlsx
6.75
KB
-rw-rw-r--
SylkTest.slk
2.27
KB
-rw-rw-r--
XMLReader.php
2.26
KB
-rw-rw-r--
XMLReader.xlsx
9.09
KB
-rw-rw-r--
XMLTest.xml
20.29
KB
-rw-rw-r--
runall.php
3.85
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : 33chartcreate-multiple-charts.php
<?php /** Error reporting */ error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); date_default_timezone_set('Europe/London'); define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); date_default_timezone_set('Europe/London'); /** * PHPExcel * * Copyright (c) 2006 - 2015 PHPExcel * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA * * @category PHPExcel * @package PHPExcel * @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel) * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL * @version ##VERSION##, ##DATE## */ /** PHPExcel */ require_once dirname(__FILE__) . '/../Classes/PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objWorksheet = $objPHPExcel->getActiveSheet(); $objWorksheet->fromArray( array( array('', 2010, 2011, 2012), array('Q1', 12, 15, 21), array('Q2', 56, 73, 86), array('Q3', 52, 61, 69), array('Q4', 30, 32, 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 $dataSeriesLabels1 = array( new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 new PHPExcel_Chart_DataSeriesValues('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 $xAxisTickValues1 = array( new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 ); // 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 $dataSeriesValues1 = array( new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), ); // Build the dataseries $series1 = new PHPExcel_Chart_DataSeries( PHPExcel_Chart_DataSeries::TYPE_AREACHART, // plotType PHPExcel_Chart_DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping range(0, count($dataSeriesValues1)-1), // plotOrder $dataSeriesLabels1, // plotLabel $xAxisTickValues1, // plotCategory $dataSeriesValues1 // plotValues ); // Set the series in the plot area $plotArea1 = new PHPExcel_Chart_PlotArea(NULL, array($series1)); // Set the chart legend $legend1 = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_TOPRIGHT, NULL, false); $title1 = new PHPExcel_Chart_Title('Test %age-Stacked Area Chart'); $yAxisLabel1 = new PHPExcel_Chart_Title('Value ($k)'); // Create the chart $chart1 = new PHPExcel_Chart( 'chart1', // name $title1, // title $legend1, // legend $plotArea1, // plotArea true, // plotVisibleOnly 0, // displayBlanksAs NULL, // xAxisLabel $yAxisLabel1 // yAxisLabel ); // Set the position where the chart should appear in the worksheet $chart1->setTopLeftPosition('A7'); $chart1->setBottomRightPosition('H20'); // Add the chart to the worksheet $objWorksheet->addChart($chart1); // 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 $dataSeriesLabels2 = array( new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 new PHPExcel_Chart_DataSeriesValues('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 $xAxisTickValues2 = array( new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 ); // 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 $dataSeriesValues2 = array( new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), ); // Build the dataseries $series2 = new PHPExcel_Chart_DataSeries( PHPExcel_Chart_DataSeries::TYPE_BARCHART, // plotType PHPExcel_Chart_DataSeries::GROUPING_STANDARD, // plotGrouping range(0, count($dataSeriesValues2)-1), // plotOrder $dataSeriesLabels2, // plotLabel $xAxisTickValues2, // plotCategory $dataSeriesValues2 // plotValues ); // Set additional dataseries parameters // Make it a vertical column rather than a horizontal bar graph $series2->setPlotDirection(PHPExcel_Chart_DataSeries::DIRECTION_COL); // Set the series in the plot area $plotArea2 = new PHPExcel_Chart_PlotArea(NULL, array($series2)); // Set the chart legend $legend2 = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false); $title2 = new PHPExcel_Chart_Title('Test Column Chart'); $yAxisLabel2 = new PHPExcel_Chart_Title('Value ($k)'); // Create the chart $chart2 = new PHPExcel_Chart( 'chart2', // name $title2, // title $legend2, // legend $plotArea2, // plotArea true, // plotVisibleOnly 0, // displayBlanksAs NULL, // xAxisLabel $yAxisLabel2 // yAxisLabel ); // Set the position where the chart should appear in the worksheet $chart2->setTopLeftPosition('I7'); $chart2->setBottomRightPosition('P20'); // Add the chart to the worksheet $objWorksheet->addChart($chart2); // Save Excel 2007 file echo date('H:i:s') , " Write to Excel2007 format" , EOL; $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->setIncludeCharts(TRUE); $objWriter->save(str_replace('.php', '.xlsx', __FILE__)); echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; // Echo memory peak usage echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; // Echo done echo date('H:i:s') , " Done writing file" , EOL; echo 'File has been created in ' , getcwd() , EOL;
Close
