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.145.36.252
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 : 32chartreadwrite.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## */ /** Include path **/ set_include_path(get_include_path() . PATH_SEPARATOR . dirname(__FILE__) . '/../Classes/'); /** PHPExcel_IOFactory */ include 'PHPExcel/IOFactory.php'; $inputFileType = 'Excel2007'; $inputFileNames = 'templates/32readwrite*[0-9].xlsx'; if ((isset($argc)) && ($argc > 1)) { $inputFileNames = array(); for($i = 1; $i < $argc; ++$i) { $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i]; } } else { $inputFileNames = glob($inputFileNames); } foreach($inputFileNames as $inputFileName) { $inputFileNameShort = basename($inputFileName); if (!file_exists($inputFileName)) { echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL; continue; } echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL; $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objReader->setIncludeCharts(TRUE); $objPHPExcel = $objReader->load($inputFileName); echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL; foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { $sheetName = $worksheet->getTitle(); echo 'Worksheet: ' , $sheetName , EOL; $chartNames = $worksheet->getChartNames(); if(empty($chartNames)) { echo ' There are no charts in this worksheet' , EOL; } else { natsort($chartNames); foreach($chartNames as $i => $chartName) { $chart = $worksheet->getChartByName($chartName); if (!is_null($chart->getTitle())) { $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"'; } else { $caption = 'Untitled'; } echo ' ' , $chartName , ' - ' , $caption , EOL; echo str_repeat(' ',strlen($chartName)+3); $groupCount = $chart->getPlotArea()->getPlotGroupCount(); if ($groupCount == 1) { $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType(); echo ' ' , $chartType , EOL; } else { $chartTypes = array(); for($i = 0; $i < $groupCount; ++$i) { $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType(); } $chartTypes = array_unique($chartTypes); if (count($chartTypes) == 1) { $chartType = 'Multiple Plot ' . array_pop($chartTypes); echo ' ' , $chartType , EOL; } elseif (count($chartTypes) == 0) { echo ' *** Type not yet implemented' , EOL; } else { echo ' Combination Chart' , EOL; } } } } } $outputFileName = basename($inputFileName); echo date('H:i:s') , " Write Tests to Excel2007 file " , EOL; $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->setIncludeCharts(TRUE); $objWriter->save($outputFileName); echo date('H:i:s') , " File written to " , $outputFileName , EOL; $objPHPExcel->disconnectWorksheets(); unset($objPHPExcel); } // 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 files" , EOL; echo 'Files have been created in ' , getcwd() , EOL;
Close
