Format::setTop

Format::setTop – Sets the width for the top border of the cell

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Format::setTop ( integer $style )

Описание

Sets the width for the top border of the cell

Parameter

  • integer $style - style of the cell top border. 1 => thin, 2 => thick.

Замечание

This function can not be called statically.

Пример

Using setTop()

<?php
require_once 'Spreadsheet/Excel/Writer.php';

$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
// we can set set all properties on instantiation
$upper_right_side_brick =& $workbook->addFormat(array('right' => 5'top' => 5'size' => 15,
                                                      
'pattern' => 1'bordercolor' => 'blue',
                                                      
'fgcolor' => 'red'));
// or set all properties one by one
$upper_left_side_brick =& $workbook->addFormat();
$upper_left_side_brick->setLeft(5);
$upper_left_side_brick->setTop(5);
$upper_left_side_brick->setSize(15);
$upper_left_side_brick->setPattern(1);
$upper_left_side_brick->setBorderColor('blue');
$upper_left_side_brick->setFgColor('red');

$lower_right_side_brick =& $workbook->addFormat(array('right' => 5'bottom' => 5'size' => 15,
                                                      
'pattern' => 1'bordercolor' => 'blue',
                                                      
'fgcolor' => 'red'));
$lower_left_side_brick =& $workbook->addFormat(array('left' => 5'bottom' => 5'size' => 15,
                                                     
'pattern' => 1'bordercolor' => 'blue',
                                                     
'fgcolor' => 'red'));

$worksheet->setColumn(0206);

// Sky
$sky =& $workbook->addFormat(array('fgcolor' => 'cyan''pattern' => 1'size' => 15));
for (
$i 0$i <= 10$i++)
{
    for (
$j 0$j 20$j++) {
        
$worksheet->writeBlank($i$j$sky);
    }
}

// Cloud
$cloud =& $workbook->addFormat(array('fgcolor' => 'white''pattern' => 1'size' => 15));
$worksheet->writeBlank(57$cloud);
$worksheet->writeBlank(48$cloud);
$worksheet->writeBlank(58$cloud);
$worksheet->writeBlank(68$cloud);
$worksheet->writeBlank(49$cloud);
$worksheet->writeBlank(59$cloud);
$worksheet->writeBlank(510$cloud);

// Bricks
for ($j 0$j 20$j++)
{
    for (
$i 5$i <= 11$i++)
    {
        if ((
$i $j)%== 1// right side of brick
        
{
            
$worksheet->writeBlank(2*$i$j$upper_right_side_brick);
            
$worksheet->writeBlank(2*$i 1$j$lower_right_side_brick);
        }
        else 
// left side of brick
        
{
            
$worksheet->writeBlank(2*$i$j$upper_left_side_brick);
            
$worksheet->writeBlank(2*$i 1$j$lower_left_side_brick);
        }
    }
}

// hide gridlines so they don't mess with our Excel art.
$worksheet->hideGridLines();

$workbook->send('bricks.xls');
$workbook->close();
?>
    Поддержать сайт на родительском проекте КГБ