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:
