PHP | Spreadsheet_Excel_Writer | setScript() Function
The setScript() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set the script type of the text.
Syntax:
void Format::setScript( $script )
Parameters: This function accepts single parameter $script which contains two value as 1 for superscript and 2 for subscript.
Return Value: This function returns TRUE on success and PEAR_ERROR on failure.
Example 1:
<?php
require_once 'Spreadsheet/Excel/Writer.php' ;
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
$format_superscript =& $workbook ->addFormat();
$format_superscript ->setScript(1);
$worksheet =& $workbook ->addWorksheet();
$worksheet ->write(0, 0, "x2" , $format_superscript );
$workbook ->send( 'test.xls' );
$workbook ->close();
?>
|
Output:
Example 2:
<?php
require_once 'Spreadsheet/Excel/Writer.php' ;
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
$format_superscript =& $workbook ->addFormat();
$format_subscript ->setScript(2);
$worksheet =& $workbook ->addWorksheet();
$worksheet ->write(0, 0, "Mg2SO4" , $format_subscript );
$workbook ->send( 'test.xls' );
$workbook ->close();
?>
|
Output:
Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setscript.php
Last Updated :
21 Dec, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...