addMathEquation

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

addMathEquation

BASIC / ADVANCED / PREMIUM

Adds math equations into the Excel spreadsheet.

Description

public addMathEquation($equation, $type, $position, $equationStyles = array(), $options = array())

This method allows adding math equations into the Excel spreadsheet.

Parameters

equation

OMML equation string or MathML.

type

Type of equation: omml, mathml.

position

Cell position in the active sheet: A1, C3, AB7...

equationStyles

Key	Type	Description
align	string	left, center, right.
color	string	Hexadecimal color value: 'FF0000', '000000'...
fontSize	int	8, 9, 10...

options

Key	Type	Description
colOffset	array	'from' (int) column size offset from. 'to' (int) column size offset to.
colSize	int	Number of columns used by the text box.
editAs	string	Possible values are: 'oneCell' (default) : move but don't size with cells. 'twoCell' : move and size with cells. 'absolute' : don't move or size with cells.
name	string	Sets a name value.
rowOffset	array	'from' (int) row size offset from. 'to' (int) row size offset to.
rowSize	int	Number of rows used by the text box.

Exceptions

Not valid type.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$options = array(
    'colSize' => 2,
    'editAs' => 'twoCell',
);
$xlsx->addMathEquation('<m:oMathPara xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math"><m:oMath><m:r><m:t>∪±∞=~×</m:t></m:r></m:oMath></m:oMathPara>', 'omml', 'B2', array(), $options);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Example #2

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$mathML = '<math xmlns="http://www.w3.org/1998/Math/MathML">
	<mrow>
		<mi>A</mi>
		<mo>=</mo>
		<mfenced open="[" close="]">
			<mtable>
				<mtr>
					<mtd>
						<mi>x</mi>
					</mtd>
					<mtd>
						<mn>2</mn>
					</mtd>
				</mtr>
				<mtr>
					<mtd>
						<mn>3</mn>
					</mtd>
					<mtd>
						<mi>w</mi>
					</mtd>
				</mtr>
			</mtable>
		</mfenced>
	</mrow>
</math>';

$options = array(
    'colSize' => 3,
    'rowSize' => 3,
);
$xlsx->addMathEquation($mathML, 'mathml', 'A1', array(), $options);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 3.0: new method.