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

Worksheet::writeBlank

Worksheet::writeBlank – Write a blank cell to the specified row and column (zero indexed).

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::writeBlank ( integer $row , integer $col , mixed $format )

Description

Write a blank cell to the specified row and column (zero indexed). A blank cell is used to specify formatting without adding a string or a number. A blank cell without a format serves no purpose. Therefore, we don't write a BLANK record unless a format is specified. This is mainly an optimisation for the write_row() and write_col() methods. Returns 0 : normal termination (including no format) -1 : insufficient number of arguments -2 : row or column out of range

Parameter

  • integer $row - Zero indexed row

  • integer $col - Zero indexed column

  • mixed $format - The XF format

Note

This function can not be called statically.

Example

Using writeBlank()

<?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();
?>
Writes a note associated with the cell given by the row and column. (Previous) Write a formula to the specified row and column (zero indexed). (Next)
Last updated: Sat, 16 Feb 2019 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report.
View this page in:
  • English

User Notes:

There are no user contributed notes for this page.