visualizer / vendor / phpoffice / phpexcel / Examples / 42richText.php

42richText.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 2.2.0, at vendor/phpoffice/phpexcel/Examples/42richText.php

160 lines 5.2 KB

Raw Download Zip

1	<?php
2	/**
3	* PHPExcel
4	*
5	* Copyright (C) 2006 - 2014 PHPExcel
6	*
7	* This library is free software; you can redistribute it and/or
8	* modify it under the terms of the GNU Lesser General Public
9	* License as published by the Free Software Foundation; either
10	* version 2.1 of the License, or (at your option) any later version.
11	*
12	* This library is distributed in the hope that it will be useful,
13	* but WITHOUT ANY WARRANTY; without even the implied warranty of
14	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15	* Lesser General Public License for more details.
16	*
17	* You should have received a copy of the GNU Lesser General Public
18	* License along with this library; if not, write to the Free Software
19	* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
20	*
21	* @category PHPExcel
22	* @package PHPExcel
23	* @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
24	* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
25	* @version ##VERSION##, ##DATE##
26	*/
27
28	/** Error reporting */
29	error_reporting(E_ALL);
30	ini_set('display_errors', TRUE);
31	ini_set('display_startup_errors', TRUE);
32	date_default_timezone_set('Europe/London');
33
34	define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
35
36	/** Include PHPExcel */
37	require_once dirname(__FILE__) . '/../Classes/PHPExcel.php';
38
39
40	// Create new PHPExcel object
41	echo date('H:i:s') , " Create new PHPExcel object" , EOL;
42	$objPHPExcel = new PHPExcel();
43
44	// Set document properties
45	echo date('H:i:s') , " Set document properties" , EOL;
46	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
47	->setLastModifiedBy("Maarten Balliauw")
48	->setTitle("PHPExcel Test Document")
49	->setSubject("PHPExcel Test Document")
50	->setDescription("Test document for PHPExcel, generated using PHP classes.")
51	->setKeywords("office PHPExcel php")
52	->setCategory("Test result file");
53
54
55	// Add some data
56	echo date('H:i:s') , " Add some data" , EOL;
57
58	$html1='<font color="#0000ff">
59	<h1 align="center">My very first example of rich text<br />generated from html markup</h1>
60	<p>
61	<font size="14" COLOR="rgb(0,255,128)">
62	<b>This block</b> contains an <i>italicized</i> word;
63	while this block uses an <u>underline</u>.
64	</font>
65	</p>
66	<p align="right"><font size="9" color="red">
67	I want to eat <ins><del>healthy food</del><strong>pizza</strong></ins>.
68	</font>
69	';
70
71	$html2='<p>
72	<font color="#ff0000">
73	100°C is a hot temperature
74	</font>
75	<br>
76	<font color="#0080ff">
77	10°F is cold
78	</font>
79	</p>';
80
81	$html3='2<sup>3</sup> equals 8';
82
83	$html4='H<sub>2</sub>SO<sub>4</sub> is the chemical formula for Sulphuric acid';
84
85
86	$wizard = new PHPExcel_Helper_HTML;
87	$richText = $wizard->toRichTextObject($html1);
88
89	$objPHPExcel->setActiveSheetIndex(0)
90	->setCellValue('A1', $richText);
91
92	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(48);
93	$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
94	$objPHPExcel->getActiveSheet()->getStyle('A1')
95	->getAlignment()
96	->setWrapText(true);
97
98	$richText = $wizard->toRichTextObject($html2);
99
100	$objPHPExcel->setActiveSheetIndex(0)
101	->setCellValue('A2', $richText);
102
103	$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
104	$objPHPExcel->getActiveSheet()->getStyle('A2')
105	->getAlignment()
106	->setWrapText(true);
107
108	$objPHPExcel->setActiveSheetIndex(0)
109	->setCellValue('A3', $wizard->toRichTextObject($html3));
110
111	$objPHPExcel->setActiveSheetIndex(0)
112	->setCellValue('A4', $wizard->toRichTextObject($html4));
113
114
115	// Rename worksheet
116	echo date('H:i:s') , " Rename worksheet" , EOL;
117	$objPHPExcel->getActiveSheet()->setTitle('Simple');
118
119
120	// Set active sheet index to the first sheet, so Excel opens this as the first sheet
121	$objPHPExcel->setActiveSheetIndex(0);
122
123
124	// Save Excel 2007 file
125	echo date('H:i:s') , " Write to Excel2007 format" , EOL;
126	$callStartTime = microtime(true);
127
128	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
129	$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
130	$callEndTime = microtime(true);
131	$callTime = $callEndTime - $callStartTime;
132
133	echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
134	echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
135	// Echo memory usage
136	echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
137
138
139	// Save Excel 95 file
140	echo date('H:i:s') , " Write to Excel5 format" , EOL;
141	$callStartTime = microtime(true);
142
143	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
144	$objWriter->save(str_replace('.php', '.xls', __FILE__));
145	$callEndTime = microtime(true);
146	$callTime = $callEndTime - $callStartTime;
147
148	echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
149	echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
150	// Echo memory usage
151	echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
152
153
154	// Echo memory peak usage
155	echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
156
157	// Echo done
158	echo date('H:i:s') , " Done writing files" , EOL;
159	echo 'Files have been created in ' , getcwd() , EOL;
160