Рекурсивный акроним словосочетания «PHP: Hypertext Preprocessor»
Добро пожаловать на форум PHP программистов!
За последние 24 часа нас посетил 17221 программист и 1834 робота. Сейчас ищут 1635 программистов ...
Format::setHAlign
Вернуться к: Spreadsheet_Excel_Writer
Format::setHAlign
Format::setHAlign – Set cell alignment.
Synopsis
require_once "Spreadsheet/Excel/Writer.php";
void Format::setHAlign ( string $location )
Set cell alignment. This is an alternative to setAlign()
Parameter
-
string $location - alignment for the cell
left, center, right, fill, justify, merge, equal_space.
Note
This function can not be called statically.
Example
Using setHAlign()
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
// put text at the top
$format_top =& $workbook->addFormat();
$format_top->setHAlign('top');
$format_top->setTextWrap(1);
// center the text horizontally
$format_center =& $workbook->addFormat();
$format_center->setHAlign('center');
// put text at the top and center it horizontally
$format_top_center =& $workbook->addFormat();
$format_top_center->setHAlign('top');
$format_top_center->setHAlign('center');
$worksheet->write(0, 0, 'On top of the world!',
$format_top);
$worksheet->write(1, 0, 'c', $format_center);
$worksheet->write(2, 0, 'tc', $format_top_center);
$workbook->send('align.xls');
$workbook->close();
?> Вернуться к: Spreadsheet_Excel_Writer