setUnderline()函数是PHP中的内置函数| Spreadsheet_Excel_Writer用于设置文本的下划线。
用法:
void Format::setUnderline( $underline )
参数:该函数接受单个参数$underline。对于单行,此参数的可能值为1;对于双行,此参数的可能值为2。
返回值:成功时返回TRUE,失败时返回PEAR_ERROR。
范例1:
<?php
require_once 'Spreadsheet/Excel/Writer.php';
// Add Workbook
$workbook = new Spreadsheet_Excel_Writer();
// Add Format to spreadsheet
$format_italic =& $workbook->addFormat();
// Set Underline
$format_italic->setUnderline(1);
// Add Worksheet to Sprerdsheet
$worksheet =& $workbook->addWorksheet();
// Write to Worksheet
$worksheet->write(0, 0, "Details of GeeksforGeeks
Contributors", $format_italic);
$worksheet->write(1, 0, "Author", $format_italic);
$worksheet->write(1, 1, "User Handle", $format_italic);
$worksheet->write(2, 0, "Sarthak", $format_italic);
$worksheet->write(2, 1, "sarthak_ishu11", $format_italic);
// Send .xlsx file to header
$workbook->send('test.xls');
// Close Workbook Object
$workbook->close();
?>
输出:
范例2:
<?php
require_once 'Spreadsheet/Excel/Writer.php';
// Create Spreadsheet_Excel_Writer Object
$workbook = new Spreadsheet_Excel_Writer();
// Add Worksheet
$worksheet =& $workbook->addWorksheet();
// Set Font Family Times New Roman
$format_setUnderline =& $workbook->addFormat();
$format_setUnderline->setFontFamily('Times New Roman');
// Set Italic Property
$format_setUnderline->setItalic();
// Set Underline to text
$format_setUnderline->setUnderline(2);
// Write to Worksheet
$worksheet->write(0, 0, "Information");
$worksheet->write(1, 0, "Website Name", $format_setUnderline);
$worksheet->write(1, 1, "Address", $format_setUnderline);
$worksheet->write(2, 0, "GeeksforGeeks", $format_setUnderline);
$worksheet->write(2, 1, "https://www.geeksforgeeks.org/",
$format_setUnderline);
$workbook->send('test.xls');
$workbook->close();
?>
输出:
相关用法
- p5.js str()用法及代码示例
- p5.js min()用法及代码示例
- PHP cos( )用法及代码示例
- PHP each()用法及代码示例
- PHP sin( )用法及代码示例
- PHP pos()用法及代码示例
- p5.js hue()用法及代码示例
- PHP end()用法及代码示例
- p5.js hex()用法及代码示例
- PHP abs()用法及代码示例
- PHP Ds\Map map()用法及代码示例
- p5.js cos()用法及代码示例
注:本文由纯净天空筛选整理自sarthak_ishu11大神的英文原创作品 PHP | Spreadsheet_Excel_Writer | setUnderline() Function。非经特殊声明,原始代码版权归原作者所有,本译文未经允许或授权,请勿转载或复制。