Worksheet::setColumn
Worksheet::setColumn – Set the width of a single column or a range of columns.
Synopsis
require_once "Spreadsheet/Excel/Writer.php";
void Worksheet::setColumn (
integer $firstcol
,
integer $lastcol
,
float $width
,
mixed $format=0
,
integer $hidden=0
)
Description
Set the width of a single column or a range of columns.
Parameter
-
integer $firstcol- first column on the range -
integer $lastcol- last column on the range -
float $width- width to set -
mixed $format- The optional XF format to apply to the columns -
integer $hidden- The optional hidden atribute
Note
This function can not be called statically.
Example
Using setColumn()
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
$radius = 20;
$worksheet->setColumn(0,$radius*2,1);
// Face
for ($i = 0; $i < 360; $i++)
{
$worksheet->write(floor(sin((2*pi()*$i)/360)*$radius) + $radius + 1, floor(cos((2*pi()*$i)/360)*$radius) + $radius + 1, "x");
}
// Eyes (maybe use a format instead?)
$worksheet->writeURL(floor($radius*0.8), floor($radius*0.8), "0");
$worksheet->writeURL(floor($radius*0.8), floor($radius*1.2), "0");
// Smile
for ($i = 65; $i < 115; $i++)
{
$worksheet->write(floor(sin((2*pi()*$i)/360)*$radius*1.3) + floor($radius*0.2), floor(cos((2*pi()*$i)/360)*$radius*1.3) + $radius + 1, "x");
}
// hide gridlines so they don't mess with our Excel art.
$worksheet->hideGridLines();
$workbook->send('face.xls');
$workbook->close();
?>