1. Einführung
  2. Tutorial über
    Formatierungen
  3. Workbook::close
  4. Workbook::&addWorksheet
  5. Workbook::&addFormat
  6. Workbook::&setTempDir
  7. Workbook::setCustomColor
  8. Worksheet::getName
  9. Worksheet::
    setInputEncoding
  10. Worksheet::select
  11. Worksheet::activate
  12. Worksheet::setFirstSheet
  13. Worksheet::protect
  14. Worksheet::setColumn
  15. Worksheet::setSelection
  16. Worksheet::freezePanes
  17. Worksheet::thawPanes
  18. Worksheet::setPortrait
  19. Worksheet::setLandscape
  20. Worksheet::setPaper
  21. Worksheet::setHeader
  22. Worksheet::setFooter
  23. Worksheet::
    centerHorizontally
  24. Worksheet::
    centerVertically
  25. Worksheet::setMargins
  26. Worksheet::setMargins_LR
  27. Worksheet::setMargins_TB
  28. Worksheet::setMarginLeft
  29. Worksheet::
    setMarginRight
  30. Worksheet::setMarginTop
  31. Worksheet::
    setMarginBottom
  32. Worksheet::repeatRows
  33. Worksheet::repeatColumns
  34. Worksheet::printArea
  35. Worksheet::hideGridlines
  36. Worksheet::
    printRowColHeaders
  37. Worksheet::fitToPages
  38. Worksheet::
    setHPagebreaks
  39. Worksheet::
    setVPagebreaks
  40. Worksheet::setZoom
  41. Worksheet::setPrintScale
  42. Worksheet::write
  43. Worksheet::writeNumber
  44. Worksheet::writeString
  45. Worksheet::writeNote
  46. Worksheet::writeBlank
  47. Worksheet::writeFormula
  48. Worksheet::writeUrl
  49. Worksheet::setRow
  50. Worksheet::mergeCells
  51. Worksheet::insertBitmap
  52. Worksheet::setOutline
  53. Spreadsheet_Excel_Writer
  54. send
  55. rowcolToCell
  56. Format::setAlign
  57. Format::setVAlign
  58. Format::setHAlign
  59. Format::setMerge
  60. Format::setBold
  61. Format::setBottom
  62. Format::setTop
  63. Format::setLeft
  64. Format::setRight
  65. Format::setBorder
  66. Format::setBorderColor
  67. Format::setBottomColor
  68. Format::setTopColor
  69. Format::setLeftColor
  70. Format::setRightColor
  71. Format::setFgColor
  72. Format::setBgColor
  73. Format::setColor
  74. Format::setPattern
  75. Format::setUnderline
  76. Format::setItalic
  77. Format::setSize
  78. Format::setTextWrap
  79. Format::setTextRotation
  80. Format::setNumFormat
  81. Format::setStrikeOut
  82. Format::setOutLine
  83. Format::setShadow
  84. Format::setScript
  85. Format::setFontFamily

Format::setBottom

Format::setBottom – Sets the width for the bottom border of the cell

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Format::setBottom ( integer $style )

Description

Sets the width for the bottom border of the cell

Parameter

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

Note

This function can not be called statically.

Example

Using setBottom()

<?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->setBottom(1);
$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();
?>
Sets the boldness of the text. (Previous) Sets the width for the top border of the cell (Next)
Last updated: Sun, 19 Dec 2010 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report or add a note.
View this page in:

User Notes:

There are no user contributed notes for this page.