webshell

Ghost Exploiter Team Official

Directory >> /home/softsuitetech/public_html/DEMO/dasphene/vendor/phpoffice/phpexcel/Examples/

File / Folder	Size	Action
.	-
data	--	ren
images	--	ren
templates	--	ren
.gitignore	0.013KB	edt ren
.htaccess	0.27KB	edt ren
01pharSimple.php	4.092KB	edt ren
01simple-download-ods.php	3.212KB	edt ren
01simple-download-pdf.php	3.483KB	edt ren
01simple-download-xls.php	3.179KB	edt ren
01simple-download-xlsx.php	3.226KB	edt ren
01simple.php	4.333KB	edt ren
01simplePCLZip.php	3.839KB	edt ren
02types-xls.php	7.698KB	edt ren
02types.php	7.595KB	edt ren
03formulas.php	6.441KB	edt ren
04printing.php	5.033KB	edt ren
05featuredemo.inc.php	18.166KB	edt ren
05featuredemo.php	2.904KB	edt ren
06largescale-with-cellc...	4.863KB	edt ren
06largescale-with-cellc...	4.864KB	edt ren
06largescale-with-cellc...	4.804KB	edt ren
06largescale-xls.php	4.712KB	edt ren
06largescale.php	4.722KB	edt ren
07reader.php	2.72KB	edt ren
07readerPCLZip.php	2.854KB	edt ren
08conditionalformatting...	8.15KB	edt ren
08conditionalformatting...	5.203KB	edt ren
09pagebreaks.php	5.012KB	edt ren
10autofilter-selection-...	8.269KB	edt ren
10autofilter-selection-...	8.062KB	edt ren
10autofilter-selection-...	7.351KB	edt ren
10autofilter.php	7.515KB	edt ren
11documentsecurity-xls.php	4.095KB	edt ren
11documentsecurity.php	4.104KB	edt ren
12cellProtection.php	3.73KB	edt ren
13calculation.php	10.838KB	edt ren
14excel5.php	2.253KB	edt ren
15datavalidation-xls.php	6.007KB	edt ren
15datavalidation.php	6.071KB	edt ren
16csv.php	4.608KB	edt ren
17html.php	2.353KB	edt ren
18extendedcalculation.php	4.298KB	edt ren
19namedrange.php	5.193KB	edt ren
20readexcel5.php	2.871KB	edt ren
21pdf.php	3.335KB	edt ren
22heavilyformatted.php	4.178KB	edt ren
23sharedstyles.php	4.498KB	edt ren
24readfilter.php	2.546KB	edt ren
25inmemoryimage.php	3.267KB	edt ren
26utf8.php	4.826KB	edt ren
27imagesexcel5.php	2.438KB	edt ren
28iterator.php	2.313KB	edt ren
29advancedvaluebinder.php	7.514KB	edt ren
30template.php	3.146KB	edt ren
31docproperties_write-x...	4.94KB	edt ren
31docproperties_write.php	4.97KB	edt ren
32chartreadwrite.php	4.437KB	edt ren
33chartcreate-area.php	4.547KB	edt ren
33chartcreate-bar-stack...	4.678KB	edt ren
33chartcreate-bar.php	4.684KB	edt ren
33chartcreate-column-2.php	5.191KB	edt ren
33chartcreate-column.php	4.686KB	edt ren
33chartcreate-composite...	6.252KB	edt ren
33chartcreate-line.php	4.524KB	edt ren
33chartcreate-multiple-...	7.026KB	edt ren
33chartcreate-pie.php	6.408KB	edt ren
33chartcreate-radar.php	4.895KB	edt ren
33chartcreate-scatter.php	4.502KB	edt ren
33chartcreate-stock.php	5.124KB	edt ren
34chartupdate.php	2.595KB	edt ren
35chartrender.php	4.11KB	edt ren
36chartreadwriteHTML.php	4.859KB	edt ren
36chartreadwritePDF.php	5.592KB	edt ren
37page_layout_view.php	3.22KB	edt ren
38cloneWorksheet.php	4.126KB	edt ren
39dropdown.php	5.835KB	edt ren
40duplicateStyle.php	1.672KB	edt ren
41password.php	3.11KB	edt ren
42richText.php	5.235KB	edt ren
Excel2003XMLReader.php	2.256KB	edt ren
Excel2003XMLTest.xml	937.047KB	edt ren
GnumericReader.php	2.255KB	edt ren
GnumericTest.gnumeric	7.64KB	edt ren
OOCalcReader.php	2.246KB	edt ren
OOCalcReaderPCLZip.php	2.321KB	edt ren
OOCalcTest.ods	17.511KB	edt ren
Quadratic.php	2.309KB	edt ren
Quadratic.xlsx	8.699KB	edt ren
Quadratic2.php	2.354KB	edt ren
SylkReader.php	1.859KB	edt ren
SylkTest.slk	2.273KB	edt ren
XMLReader.php	2.261KB	edt ren
XMLTest.xml	20.294KB	edt ren
runall.php	3.668KB	edt ren

<?php
/**
 * PHPExcel
 *
 * Copyright (C) 2006 - 2014 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 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
 * @version    ##VERSION##, ##DATE##
 */

/** 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 />');

/** Include PHPExcel */
require_once dirname(__FILE__) . '/../Classes/PHPExcel.php';

// Create new PHPExcel object
echo date('H:i:s') , " Create new PHPExcel object" , EOL;
$objPHPExcel = new PHPExcel();

// Set document properties
echo date('H:i:s') , " Set document properties" , EOL;
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
							 ->setLastModifiedBy("Maarten Balliauw")
							 ->setTitle("Office 2007 XLSX Test Document")
							 ->setSubject("Office 2007 XLSX Test Document")
							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
							 ->setKeywords("office 2007 openxml php")
							 ->setCategory("Test result file");

// Set default font
echo date('H:i:s') , " Set default font" , EOL;
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial')
                                          ->setSize(10);

// Add some data, resembling some different data types
echo date('H:i:s') , " Add some data" , EOL;
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'String')
                              ->setCellValue('B1', 'Simple')
                              ->setCellValue('C1', 'PHPExcel');

$objPHPExcel->getActiveSheet()->setCellValue('A2', 'String')
                              ->setCellValue('B2', 'Symbols')
                              ->setCellValue('C2', '!+&=()~§±æþ');

$objPHPExcel->getActiveSheet()->setCellValue('A3', 'String')
                              ->setCellValue('B3', 'UTF-8')
                              ->setCellValue('C3', 'Создать MS Excel Книги из PHP скриптов');

$objPHPExcel->getActiveSheet()->setCellValue('A4', 'Number')
                              ->setCellValue('B4', 'Integer')
                              ->setCellValue('C4', 12);

$objPHPExcel->getActiveSheet()->setCellValue('A5', 'Number')
                              ->setCellValue('B5', 'Float')
                              ->setCellValue('C5', 34.56);

$objPHPExcel->getActiveSheet()->setCellValue('A6', 'Number')
                              ->setCellValue('B6', 'Negative')
                              ->setCellValue('C6', -7.89);

$objPHPExcel->getActiveSheet()->setCellValue('A7', 'Boolean')
                              ->setCellValue('B7', 'True')
                              ->setCellValue('C7', true);

$objPHPExcel->getActiveSheet()->setCellValue('A8', 'Boolean')
                              ->setCellValue('B8', 'False')
                              ->setCellValue('C8', false);

$dateTimeNow = time();
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Date/Time')
                              ->setCellValue('B9', 'Date')
                              ->setCellValue('C9', PHPExcel_Shared_Date::PHPToExcel( $dateTimeNow ));
$objPHPExcel->getActiveSheet()->getStyle('C9')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2);

$objPHPExcel->getActiveSheet()->setCellValue('A10', 'Date/Time')
                              ->setCellValue('B10', 'Time')
                              ->setCellValue('C10', PHPExcel_Shared_Date::PHPToExcel( $dateTimeNow ));
$objPHPExcel->getActiveSheet()->getStyle('C10')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4);

$objPHPExcel->getActiveSheet()->setCellValue('A11', 'Date/Time')
                              ->setCellValue('B11', 'Date and Time')
                              ->setCellValue('C11', PHPExcel_Shared_Date::PHPToExcel( $dateTimeNow ));
$objPHPExcel->getActiveSheet()->getStyle('C11')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME);

$objPHPExcel->getActiveSheet()->setCellValue('A12', 'NULL')
                              ->setCellValue('C12', NULL);

$objRichText = new PHPExcel_RichText();
$objRichText->createText('你好 ');

$objPayable = $objRichText->createTextRun('你 好 吗？');
$objPayable->getFont()->setBold(true);
$objPayable->getFont()->setItalic(true);
$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_DARKGREEN ) );

$objRichText->createText(', unless specified otherwise on the invoice.');

$objPHPExcel->getActiveSheet()->setCellValue('A13', 'Rich Text')
                              ->setCellValue('C13', $objRichText);

$objRichText2 = new PHPExcel_RichText();
$objRichText2->createText("black text\n");

$objRed = $objRichText2->createTextRun("red text");
$objRed->getFont()->setColor( new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_RED  ) );

$objPHPExcel->getActiveSheet()->getCell("C14")->setValue($objRichText2);
$objPHPExcel->getActiveSheet()->getStyle("C14")->getAlignment()->setWrapText(true);

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);

// Rename worksheet
echo date('H:i:s') , " Rename worksheet" , EOL;
$objPHPExcel->getActiveSheet()->setTitle('Datatypes');

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);

// Save Excel 2007 file
echo date('H:i:s') , " Write to Excel2007 format" , EOL;
$callStartTime = microtime(true);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
$callEndTime = microtime(true);
$callTime = $callEndTime - $callStartTime;

echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
// Echo memory usage
echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;

echo date('H:i:s') , " Reload workbook from saved file" , EOL;
$callStartTime = microtime(true);

$objPHPExcel = PHPExcel_IOFactory::load(str_replace('.php', '.xlsx', __FILE__));

$callEndTime = microtime(true);
$callTime = $callEndTime - $callStartTime;
echo 'Call time to reload Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
// Echo memory usage
echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;

var_dump($objPHPExcel->getActiveSheet()->toArray());

// 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 testing file" , EOL;
echo 'File has been created in ' , getcwd() , EOL;