PHP | Spreadsheet_Excel_Writer | setItalic() Function
source link: https://www.geeksforgeeks.org/php-spreadsheet_excel_writer-setitalic-function/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
- Difficulty Level : Easy
- Last Updated : 21 Dec, 2018
The setItalic() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set the font style as italic.
Syntax:
void Format::setItalic()
Parameters: This function does not accept any parameter.
Return Value: This function returns TRUE on success and PEAR_ERROR on failure.
Example 1:
filter_none
edit
close
play_arrow
link
brightness_4
code
<?php
// require_once 'Spreadsheet/Excel/Writer.php';
// Add Workbook
$workbook
=
new
Spreadsheet_Excel_Writer();
// Add Format to spreadsheet
$format_italic
=&
$workbook
->addFormat();
// Set Italic
$format_italic
->setItalic();
// 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();
?>
Output:
Example 2:
filter_none
edit
close
play_arrow
link
brightness_4
code
<?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_setItalic
=&
$workbook
->addFormat();
$format_setItalic
->setFontFamily(
'Times New Roman'
);
// Set Italic Property
$format_setItalic
->setItalic();
// Set Shadow to text
$format_setItalic
->setShadow();
// Write to Worksheet
$worksheet
->write(0, 0,
"Information"
);
$worksheet
->write(1, 0,
"Website Name"
,
$format_setItalic
);
$worksheet
->write(1, 1,
"Address"
,
$format_setItalic
);
$worksheet
->write(2, 0,
"GeeksforGeeks"
,
$format_setItalic
);
$format_setItalic
);
$workbook
->send(
'test.xls'
);
$workbook
->close();
?>
Output:
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK