Worksheet::hideGridlines -- Set the option to hide gridlines on the printed page.
Description
Set the option to hide gridlines on the printed page.
Note
This function can not be called
statically.
Example
Example 43-1. Using hideGridlines()
<?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();
?>
|
|
|
Worksheet::printArea (Previous)
|
(Next) Worksheet::printRowColHeaders
|
|
|
Download Documentation
|
Last updated: Sun, 28 Sep 2008 |
|
Do you think that something on this page is wrong? Please file a bug report or add a note.
|
| User Notes: |
Note by: gprod.net@gmail.com
Haaaa Thank you for this comment
Note by: mike@ezinearticles.com
Note there is now the hideScreenGridlines() function to hide the gridlines on the document as viewable on your screen, rather than in print. There is currently no documentation for this.
|
|