Explorer

home / zoteqbgb / public_html / vendor / phpoffice / phpexcel / Examples

Location: /home/zoteqbgb/public_html/vendor/phpoffice/phpexcel/Examples
Root path: /home/zoteqbgb/public_html/config/676626

Editing: 06largescale-with-cellcaching.php

<?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);

define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');

date_default_timezone_set('Europe/London');

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

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
if (!PHPExcel_Settings::setCacheStorageMethod($cacheMethod)) {
	die($cacheMethod . " caching method is not available" . EOL);
}
echo date('H:i:s') , " Enable Cell Caching using " , $cacheMethod , " method" , EOL;

// 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 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");

// Create a first sheet
echo date('H:i:s') , " Add data" , EOL;
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");
$objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");
$objPHPExcel->getActiveSheet()->setCellValue('C1', "Phone");
$objPHPExcel->getActiveSheet()->setCellValue('D1', "Fax");
$objPHPExcel->getActiveSheet()->setCellValue('E1', "Is Client ?");

// Hide "Phone" and "fax" column
echo date('H:i:s') , " Hide 'Phone' and 'fax' columns" , EOL;
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);

// Set outline levels
echo date('H:i:s') , " Set outline levels" , EOL;
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
                                                       ->setVisible(false)
                                                       ->setCollapsed(true);

// Freeze panes
echo date('H:i:s') , " Freeze panes" , EOL;
$objPHPExcel->getActiveSheet()->freezePane('A2');

// Rows to repeat at top
echo date('H:i:s') , " Rows to repeat at top" , EOL;
$objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);

// Add data
for ($i = 2; $i <= 5000; $i++) {
	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
	                              ->setCellValue('B' . $i, "LName $i")
	                              ->setCellValue('C' . $i, "PhoneNo $i")
	                              ->setCellValue('D' . $i, "FaxNo $i")
	                              ->setCellValue('E' . $i, true);
}

// 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 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;

Directory Contents

Name	Size	Perms	Modified	Actions
.gitignore	13 bytes	0644	2015-05-01 12:00	âï¸
01pharSimple.php	4,190 bytes	0644	2015-05-01 12:00	âï¸
01simple-download-ods.php	3,289 bytes	0644	2015-05-01 12:00	âï¸
01simple-download-pdf.php	3,567 bytes	0644	2015-05-01 12:00	âï¸
01simple-download-xls.php	3,255 bytes	0644	2015-05-01 12:00	âï¸
01simple-download-xlsx.php	3,303 bytes	0644	2015-05-01 12:00	âï¸
01simple.php	4,437 bytes	0644	2015-05-01 12:00	âï¸
01simplePCLZip.php	3,931 bytes	0644	2015-05-01 12:00	âï¸
02types-xls.php	7,883 bytes	0644	2015-05-01 12:00	âï¸
02types.php	7,777 bytes	0644	2015-05-01 12:00	âï¸
03formulas.php	6,596 bytes	0644	2015-05-01 12:00	âï¸
04printing.php	5,154 bytes	0644	2015-05-01 12:00	âï¸
05featuredemo.inc.php	18,602 bytes	0644	2015-05-01 12:00	âï¸
05featuredemo.php	2,974 bytes	0644	2015-05-01 12:00	âï¸
06largescale-with-cellcaching-sqlite.php	4,980 bytes	0644	2015-05-01 12:00	âï¸
06largescale-with-cellcaching-sqlite3.php	4,981 bytes	0644	2015-05-01 12:00	âï¸
06largescale-with-cellcaching.php	4,919 bytes	0644	2015-05-01 12:00	âï¸
06largescale-xls.php	4,825 bytes	0644	2015-05-01 12:00	âï¸
06largescale.php	4,835 bytes	0644	2015-05-01 12:00	âï¸
07reader.php	2,785 bytes	0644	2015-05-01 12:00	âï¸
07readerPCLZip.php	2,923 bytes	0644	2015-05-01 12:00	âï¸
08conditionalformatting.php	8,346 bytes	0644	2015-05-01 12:00	âï¸
08conditionalformatting2.php	5,328 bytes	0644	2015-05-01 12:00	âï¸
09pagebreaks.php	5,132 bytes	0644	2015-05-01 12:00	âï¸
10autofilter-selection-1.php	8,467 bytes	0644	2015-05-01 12:00	âï¸
10autofilter-selection-2.php	8,255 bytes	0644	2015-05-01 12:00	âï¸
10autofilter-selection-display.php	7,527 bytes	0644	2015-05-01 12:00	âï¸
10autofilter.php	7,695 bytes	0644	2015-05-01 12:00	âï¸
11documentsecurity-xls.php	4,193 bytes	0644	2015-05-01 12:00	âï¸
11documentsecurity.php	4,203 bytes	0644	2015-05-01 12:00	âï¸
12cellProtection.php	3,820 bytes	0644	2015-05-01 12:00	âï¸
13calculation.php	11,098 bytes	0644	2015-05-01 12:00	âï¸
14excel5.php	2,307 bytes	0644	2015-05-01 12:00	âï¸
15datavalidation-xls.php	6,151 bytes	0644	2015-05-01 12:00	âï¸
15datavalidation.php	6,217 bytes	0644	2015-05-01 12:00	âï¸
16csv.php	4,719 bytes	0644	2015-05-01 12:00	âï¸
17html.php	2,409 bytes	0644	2015-05-01 12:00	âï¸
18extendedcalculation.php	4,401 bytes	0644	2015-05-01 12:00	âï¸
19namedrange.php	5,318 bytes	0644	2015-05-01 12:00	âï¸
20readexcel5.php	2,940 bytes	0644	2015-05-01 12:00	âï¸
21pdf.php	3,415 bytes	0644	2015-05-01 12:00	âï¸
22heavilyformatted.php	4,278 bytes	0644	2015-05-01 12:00	âï¸
23sharedstyles.php	4,606 bytes	0644	2015-05-01 12:00	âï¸
24readfilter.php	2,607 bytes	0644	2015-05-01 12:00	âï¸
25inmemoryimage.php	3,345 bytes	0644	2015-05-01 12:00	âï¸
26utf8.php	4,942 bytes	0644	2015-05-01 12:00	âï¸
27imagesexcel5.php	2,497 bytes	0644	2015-05-01 12:00	âï¸
28iterator.php	2,369 bytes	0644	2015-05-01 12:00	âï¸
29advancedvaluebinder.php	7,694 bytes	0644	2015-05-01 12:00	âï¸
30template.php	3,221 bytes	0644	2015-05-01 12:00	âï¸
31docproperties_write-xls.php	5,059 bytes	0644	2015-05-01 12:00	âï¸
31docproperties_write.php	5,089 bytes	0644	2015-05-01 12:00	âï¸
32chartreadwrite.php	4,543 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-area.php	4,656 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-bar-stacked.php	4,790 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-bar.php	4,796 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-column-2.php	5,316 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-column.php	4,798 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-composite.php	6,402 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-line.php	4,633 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-multiple-charts.php	7,195 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-pie.php	6,562 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-radar.php	5,012 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-scatter.php	4,610 bytes	0644	2015-05-01 12:00	âï¸
33chartcreate-stock.php	5,247 bytes	0644	2015-05-01 12:00	âï¸
34chartupdate.php	2,657 bytes	0644	2015-05-01 12:00	âï¸
35chartrender.php	4,209 bytes	0644	2015-05-01 12:00	âï¸
36chartreadwriteHTML.php	4,976 bytes	0644	2015-05-01 12:00	âï¸
36chartreadwritePDF.php	5,726 bytes	0644	2015-05-01 12:00	âï¸
37page_layout_view.php	3,297 bytes	0644	2015-05-01 12:00	âï¸
38cloneWorksheet.php	4,225 bytes	0644	2015-05-01 12:00	âï¸
39dropdown.php	5,975 bytes	0644	2015-05-01 12:00	âï¸
40duplicateStyle.php	1,712 bytes	0644	2015-05-01 12:00	âï¸
41password.php	3,185 bytes	0644	2015-05-01 12:00	âï¸
42richText.php	5,361 bytes	0644	2015-05-01 12:00	âï¸
Excel2003XMLReader.php	2,310 bytes	0644	2015-05-01 12:00	âï¸
Excel2003XMLTest.xml	959,536 bytes	0644	2015-05-01 12:00	âï¸
GnumericReader.php	2,309 bytes	0644	2015-05-01 12:00	âï¸
GnumericTest.gnumeric	7,823 bytes	0644	2015-05-01 12:00	âï¸
OOCalcReader.php	2,300 bytes	0644	2015-05-01 12:00	âï¸
OOCalcReaderPCLZip.php	2,377 bytes	0644	2015-05-01 12:00	âï¸
OOCalcTest.ods	17,931 bytes	0644	2015-05-01 12:00	âï¸
Quadratic.php	2,364 bytes	0644	2015-05-01 12:00	âï¸
Quadratic.xlsx	8,908 bytes	0644	2015-05-01 12:00	âï¸
Quadratic2.php	2,411 bytes	0644	2015-05-01 12:00	âï¸
SylkReader.php	1,904 bytes	0644	2015-05-01 12:00	âï¸
SylkTest.slk	2,328 bytes	0644	2015-05-01 12:00	âï¸
XMLReader.php	2,315 bytes	0644	2015-05-01 12:00	âï¸
XMLTest.xml	20,781 bytes	0644	2015-05-01 12:00	âï¸
data	-	0755	2015-05-01 12:00
images	-	0755	2015-05-01 12:00
runall.php	3,756 bytes	0644	2015-05-01 12:00	âï¸
templates	-	0755	2015-05-01 12:00