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:
