PEAR Manual
Prev |  | Next

# Format::setRight

Format::setRight -- Sets the width for the right border of the cell

## Synopsis

    require_once "Spreadsheet/Excel/Writer.php";

``void Format::setRight` (integer $style)`

## Description

Sets the width for the right border of the cell

## Parameter

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

## Note

This function can not be called statically.

## Example

Example 37-1. Using setRight()
    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(0, 20, 6);

    // 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(5, 7, $cloud);
    $worksheet->writeBlank(4, 8, $cloud);
    $worksheet->writeBlank(5, 8, $cloud);
    $worksheet->writeBlank(6, 8, $cloud);
    $worksheet->writeBlank(4, 9, $cloud);
    $worksheet->writeBlank(5, 9, $cloud);
    $worksheet->writeBlank(5, 10, $cloud);

    // Bricks
    for ($j = 0; $j < 20; $j++)
    {
        for ($i = 5; $i <= 11; $i++)
        {
            if (($i + $j)%2 == 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();

Prev | Home | Next
Format::setLeft | Up | Format::setBorder