42richText.php File Reference

Go to the source code of this file.

Namespaces
	PHPExcel

Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
Create new PHPExcel	object
	$objPHPExcel = new PHPExcel()
Set document	properties
Add some	data
	$html1
	$html2
	$html3 ='2<sup>3</sup> equals 8'
	$html4 ='H<sub>2</sub>SO<sub>4</sub> is the chemical formula for Sulphuric acid'
	$wizard = new PHPExcel_Helper_HTML
	$richText = $wizard->toRichTextObject($html1)
Rename	worksheet
Write to Excel2007	format
	$callStartTime = microtime(true)
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
	$callEndTime = microtime(true)
	$callTime = $callEndTime - $callStartTime
File written	to
sprintf('%.4f', $callTime)	seconds
memory_get_usage(true)/1024/1024)	MB
Peak memory	usage
Done writing	files

Variable Documentation

$callEndTime

$callEndTime = microtime(true)

Definition at line 130 of file 42richText.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 126 of file 42richText.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 131 of file 42richText.php.

$html1

$html1

Initial value:

='<font color="#0000ff">
<h1 align="center">My very first example of rich text<br />generated from html markup</h1>
<p>
<font size="14" COLOR="rgb(0,255,128)">
<b>This block</b> contains an <i>italicized</i> word;
while this block uses an <u>underline</u>.
</font>
</p>
<p align="right"><font size="9" color="red">
I want to eat <ins><del>healthy food</del><strong>pizza</strong></ins>.
</font>
'

Definition at line 58 of file 42richText.php.

Referenced by ilExternalFeedBlockGUI\create(), and ilBookmarkAdministrationGUI\newFormBookmark().

$html2

$html2

Initial value:

='<p>
<font color="#ff0000">
    100&deg;C is a hot temperature
</font>
<br>
<font color="#0080ff">
    10&deg;F is cold
</font>
</p>'

Definition at line 71 of file 42richText.php.

Referenced by ilExternalFeedBlockGUI\create(), ilBookmarkAdministrationGUI\newFormBookmark(), and ilContainerContentGUI\renderItemGroup().

$html3

$html3 ='2<sup>3</sup> equals 8'

Definition at line 81 of file 42richText.php.

$html4

$html4 ='H<sub>2</sub>SO<sub>4</sub> is the chemical formula for Sulphuric acid'

Definition at line 83 of file 42richText.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 42 of file 42richText.php.

$objWriter

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')

Definition at line 128 of file 42richText.php.

$richText

$richText = $wizard->toRichTextObject($html1)

Definition at line 87 of file 42richText.php.

Referenced by PHPExcel_Reader_Excel5\_readLabelSst().

$wizard

$wizard = new PHPExcel_Helper_HTML

Definition at line 86 of file 42richText.php.

data

Add some data

Definition at line 56 of file 42richText.php.

EOL

getcwd () EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Definition at line 34 of file 42richText.php.

files

Done writing files

Definition at line 158 of file 42richText.php.

format

Write to Excel5 format

Definition at line 125 of file 42richText.php.

MB

Peak memory memory_get_peak_usage (true)/1024/1024) MB

Definition at line 136 of file 42richText.php.

object

Create new PHPExcel object

Definition at line 37 of file 42richText.php.

properties

Set document properties

Definition at line 45 of file 42richText.php.

seconds

sprintf ('%.4f', $callTime) seconds

Definition at line 134 of file 42richText.php.

to

File written to

Definition at line 133 of file 42richText.php.

usage

Peak memory usage

Definition at line 155 of file 42richText.php.

worksheet

Rename worksheet

Definition at line 116 of file 42richText.php.