Рекурсивный акроним словосочетания «PHP: Hypertext Preprocessor»
Добро пожаловать на форум PHP программистов!
За последние 24 часа нас посетили 23912 программистов и 1389 роботов. Сейчас ищут 1467 программистов ...
Format::setVAlign
Вернуться к: Spreadsheet_Excel_Writer
Format::setVAlign
Format::setVAlign – Set cell alignment.
Synopsis
require_once "Spreadsheet/Excel/Writer.php";
void Format::setVAlign ( string $location )
Set cell alignment. This is an alternative to setAlign()
Parameter
-
string $location - alignment for the cell
top, vcenter, bottom, vjustify, vequal_space.
Note
This function can not be called statically.
Example
Using setVAlign()
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
// justify
$format_justify =& $workbook->addFormat('vAlign' => 'vjustify');
// center the text vertically
$format_center =& $workbook->addFormat('vAlign' => 'vcenter');
// justify and center vertically
$format_justify_center =& $workbook->addFormat();
$format_justify_center->setVAlign('vjustify');
$format_justify_center->setVAlign('vcenter');
$worksheet->write(0, 0, 'justify', $format_justify);
$worksheet->write(1, 0, 'center', $format_center);
$worksheet->write(2, 0, 'jc', $format_justify_center);
$workbook->send('align.xls');
$workbook->close();
?> Вернуться к: Spreadsheet_Excel_Writer