 Worksheet::setFooter (Previous)
|
(Next) Worksheet::centerHorizontally
|
||||
| |
|||||
|
|||||
Worksheet::setMerge
Worksheet::setMerge – Sets a merged cell range
Synopsis
require_once 'Spreadsheet/Excel/Writer/Worksheet.php';
void Worksheet::setMerge (
integer $first_row
, integer $first_col
, integer $last_row
, integer $last_col
)
Description
This package is not documented yet.
Parameter
- integer $first_row
-
First row of the area to merge
- integer $first_col
-
First column of the area to merge
- integer $last_row
-
Last row of the area to merge
- integer $last_col
-
Last column of the area to merge
Throws
throws no exceptions thrown
Note
This function can not be called statically.
Example
Using setMerge()
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet = $workbook->addWorksheet('SetMerge');
// Sets the color of a cell's content
$format = $workbook->addFormat();
$format->setFgColor(10);
$worksheet->write(0, 0, 'Cell Start', $format);
// Merge cells from row 0, col 0 to row 2, col 2
$worksheet->setMerge(0, 0, 2, 2);
$workbook->send('SetMerge.xls');
$workbook->close();
?>
|
Worksheet::setFooter (Previous)
|
(Next) Worksheet::centerHorizontally
|
||||||||
| |
|||||||||
|
|||||||||