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' ;
// Create Spreadsheet_Excel_Writer object $workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
// Creating the formats $format_superscript =& $workbook ->addFormat();
$format_superscript ->setScript(1);
// Add Worksheet $worksheet =& $workbook ->addWorksheet();
// Add superscript Text to cell $worksheet ->write(0, 0, "x2" , $format_superscript );
$workbook ->send( 'test.xls' );
$workbook ->close();
?> |
Output:
Example 2:
<?php require_once 'Spreadsheet/Excel/Writer.php' ;
// Create Spreadsheet_Excel_Writer object $workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook ->addWorksheet();
// Creating the formats $format_superscript =& $workbook ->addFormat();
$format_subscript ->setScript(2);
// Add Worksheet $worksheet =& $workbook ->addWorksheet();
// Add subscript text to cell $worksheet ->write(0, 0, "Mg2SO4" , $format_subscript );
$workbook ->send( 'test.xls' );
$workbook ->close();
?> |
Output: