Spreadsheet_Excel_Writer_Worksheet Class Reference

Inheritance diagram for Spreadsheet_Excel_Writer_Worksheet:

Collaboration diagram for Spreadsheet_Excel_Writer_Worksheet:

Public Member Functions
	Spreadsheet_Excel_Writer_Worksheet ($BIFF_version, $name, $index, &$activesheet, &$firstsheet, &$str_total, &$str_unique, &$str_table, &$url_format, &$parser, $tmp_dir)
	Constructor. More...
	_initialize ()
	Open a tmp file to store the majority of the Worksheet data. More...
	close ($sheetnames)
	Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook. More...
	getName ()
	Retrieve the worksheet name. More...
	getData ()
	Retrieves data from memory in one chunk, or from disk in $buffer sized chunks. More...
	setMerge ($first_row, $first_col, $last_row, $last_col)
	Sets a merged cell range. More...
	select ()
	Set this worksheet as a selected worksheet, i.e. More...
	activate ()
	Set this worksheet as the active worksheet, i.e. More...
	setFirstSheet ()
	Set this worksheet as the first visible sheet. More...
	protect ($password)
	Set the worksheet protection flag to prevent accidental modification and to hide formulas if the locked and hidden format properties have been set. More...
	setColumn ($firstcol, $lastcol, $width, $format=null, $hidden=0, $level=0)
	Set the width of a single column or a range of columns. More...
	setSelection ($first_row, $first_column, $last_row, $last_column)
	Set which cell or cells are selected in a worksheet. More...
	freezePanes ($panes)
	Set panes and mark them as frozen. More...
	thawPanes ($panes)
	Set panes and mark them as unfrozen. More...
	setPortrait ()
	Set the page orientation as portrait. More...
	setLandscape ()
	Set the page orientation as landscape. More...
	setPaper ($size=0)
	Set the paper type. More...
	setHeader ($string, $margin=0.50)
	Set the page header caption and optional margin. More...
	setFooter ($string, $margin=0.50)
	Set the page footer caption and optional margin. More...
	centerHorizontally ($center=1)
	Center the page horinzontally. More...
	centerVertically ($center=1)
	Center the page vertically. More...
	setMargins ($margin)
	Set all the page margins to the same value in inches. More...
	setMargins_LR ($margin)
	Set the left and right margins to the same value in inches. More...
	setMargins_TB ($margin)
	Set the top and bottom margins to the same value in inches. More...
	setMarginLeft ($margin=0.75)
	Set the left margin in inches. More...
	setMarginRight ($margin=0.75)
	Set the right margin in inches. More...
	setMarginTop ($margin=1.00)
	Set the top margin in inches. More...
	setMarginBottom ($margin=1.00)
	Set the bottom margin in inches. More...
	repeatRows ($first_row, $last_row=null)
	Set the rows to repeat at the top of each printed page. More...
	repeatColumns ($first_col, $last_col=null)
	Set the columns to repeat at the left hand side of each printed page. More...
	printArea ($first_row, $first_col, $last_row, $last_col)
	Set the area of each worksheet that will be printed. More...
	hideGridlines ()
	Set the option to hide gridlines on the printed page. More...
	hideScreenGridlines ()
	Set the option to hide gridlines on the worksheet (as seen on the screen). More...
	printRowColHeaders ($print=1)
	Set the option to print the row and column headers on the printed page. More...
	fitToPages ($width, $height)
	Set the vertical and horizontal number of pages that will define the maximum area printed. More...
	setHPagebreaks ($breaks)
	Store the horizontal page breaks on a worksheet (for printing). More...
	setVPagebreaks ($breaks)
	Store the vertical page breaks on a worksheet (for printing). More...
	setZoom ($scale=100)
	Set the worksheet zoom factor. More...
	setPrintScale ($scale=100)
	Set the scale factor for the printed page. More...
	write ($row, $col, $token, $format=null)
	Map to the appropriate write method acording to the token recieved. More...
	writeRow ($row, $col, $val, $format=null)
	Write an array of values as a row. More...
	writeCol ($row, $col, $val, $format=null)
	Write an array of values as a column. More...
	_XF (&$format)
	Returns an index to the XF record in the workbook. More...
	_append ($data)
	Store Worksheet data in memory using the parent's class append() or to a temporary file, the default. More...
	_substituteCellref ($cell)
	Substitute an Excel cell reference in A1 notation for zero based row and column values in an argument list. More...
	_cellToRowcol ($cell)
	Convert an Excel cell reference in A1 notation to a zero based row and column reference; converts C1 to (0, 2). More...
	_encodePassword ($plaintext)
	Based on the algorithm provided by Daniel Rentz of OpenOffice. More...
	setOutline ($visible=true, $symbols_below=true, $symbols_right=true, $auto_style=false)
	This method sets the properties for outlining and grouping. More...
	writeNumber ($row, $col, $num, $format=null)
	Write a double to the specified row and column (zero indexed). More...
	writeString ($row, $col, $str, $format=null)
	Write a string to the specified row and column (zero indexed). More...
	setInputEncoding ($encoding)
	Sets Input Encoding for writing strings. More...
	writeStringBIFF8 ($row, $col, $str, $format=null)
	Write a string to the specified row and column (zero indexed). More...
	_checkRowCol ($row, $col)
	Check row and col before writing to a cell, and update the sheet's dimensions accordingly. More...
	writeNote ($row, $col, $note)
	Writes a note associated with the cell given by the row and column. More...
	writeBlank ($row, $col, $format)
	Write a blank cell to the specified row and column (zero indexed). More...
	writeFormula ($row, $col, $formula, $format=null)
	Write a formula to the specified row and column (zero indexed). More...
	writeUrl ($row, $col, $url, $string='', $format=null)
	Write a hyperlink. More...
	_writeUrlRange ($row1, $col1, $row2, $col2, $url, $string='', $format=null)
	This is the more general form of writeUrl(). More...
	_writeUrlWeb ($row1, $col1, $row2, $col2, $url, $str, $format=null)
	Used to write http, ftp and mailto hyperlinks. More...
	_writeUrlInternal ($row1, $col1, $row2, $col2, $url, $str, $format=null)
	Used to write internal reference hyperlinks such as "Sheet1!A1". More...
	_writeUrlExternal ($row1, $col1, $row2, $col2, $url, $str, $format=null)
	Write links to external directory names such as 'c:.xls', c:.xls::Sheet1!A1', '../../foo.xls'. More...
	setRow ($row, $height, $format=null, $hidden=false, $level=0)
	This method is used to set the height and format for a row. More...
	_storeDimensions ()
	Writes Excel DIMENSIONS to define the area in which there is data. More...
	_storeWindow2 ()
	Write BIFF record Window2. More...
	_storeDefcol ()
	Write BIFF record DEFCOLWIDTH if COLINFO records are in use. More...
	_storeColinfo ($col_array)
	Write BIFF record COLINFO to define column widths. More...
	_storeSelection ($array)
	Write BIFF record SELECTION. More...
	_storeMergedCells ()
	Store the MERGEDCELLS record for all ranges of merged cells. More...
	_storeExterncount ($count)
	Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet. More...
	_storeExternsheet ($sheetname)
	Writes the Excel BIFF EXTERNSHEET record. More...
	_storePanes ($panes)
	Writes the Excel BIFF PANE record. More...
	_storeSetup ()
	Store the page setup SETUP BIFF record. More...
	_storeHeader ()
	Store the header caption BIFF record. More...
	_storeFooter ()
	Store the footer caption BIFF record. More...
	_storeHcenter ()
	Store the horizontal centering HCENTER BIFF record. More...
	_storeVcenter ()
	Store the vertical centering VCENTER BIFF record. More...
	_storeMarginLeft ()
	Store the LEFTMARGIN BIFF record. More...
	_storeMarginRight ()
	Store the RIGHTMARGIN BIFF record. More...
	_storeMarginTop ()
	Store the TOPMARGIN BIFF record. More...
	_storeMarginBottom ()
	Store the BOTTOMMARGIN BIFF record. More...
	mergeCells ($first_row, $first_col, $last_row, $last_col)
	Merges the area given by its arguments. More...
	_storePrintHeaders ()
	Write the PRINTHEADERS BIFF record. More...
	_storePrintGridlines ()
	Write the PRINTGRIDLINES BIFF record. More...
	_storeGridset ()
	Write the GRIDSET BIFF record. More...
	_storeGuts ()
	Write the GUTS BIFF record. More...
	_storeWsbool ()
	Write the WSBOOL BIFF record, mainly for fit-to-page. More...
	_storeHbreak ()
	Write the HORIZONTALPAGEBREAKS BIFF record. More...
	_storeVbreak ()
	Write the VERTICALPAGEBREAKS BIFF record. More...
	_storeProtect ()
	Set the Biff PROTECT record to indicate that the worksheet is protected. More...
	_storePassword ()
	Write the worksheet PASSWORD record. More...
	insertBitmap ($row, $col, $bitmap, $x=0, $y=0, $scale_x=1, $scale_y=1)
	Insert a 24bit bitmap image in a worksheet. More...
	_positionImage ($col_start, $row_start, $x1, $y1, $width, $height)
	Calculate the vertices that define the position of the image as required by the OBJ record. More...
	_sizeCol ($col)
	Convert the width of a cell from user's units to pixels. More...
	_sizeRow ($row)
	Convert the height of a cell from user's units to pixels. More...
	_storeObjPicture ($colL, $dxL, $rwT, $dyT, $colR, $dxR, $rwB, $dyB)
	Store the OBJ record that precedes an IMDATA record. More...
	_processBitmap ($bitmap)
	Convert a 24 bit bitmap into the modified internal format used by Windows. More...
	_storeZoom ()
	Store the window zoom factor. More...
	setValidation ($row1, $col1, $row2, $col2, &$validator)
	FIXME: add comments. More...
	_storeDataValidity ()
	Store the DVAL and DV records. More...
Public Member Functions inherited from Spreadsheet_Excel_Writer_BIFFwriter
	Spreadsheet_Excel_Writer_BIFFwriter ()
	Constructor. More...
	_setByteOrder ()
	Determine the byte order and store it as class data to avoid recalculating it for each call to new(). More...
	_prepend ($data)
	General storage function. More...
	_append ($data)
	General storage function. More...
	_storeBof ($type)
	Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file. More...
	_storeEof ()
	Writes Excel EOF record to indicate the end of a BIFF stream. More...
	_addContinue ($data)
	Excel limits the size of BIFF records. More...
	setTempDir ($dir)
	Sets the temp dir used for storing the OLE file. More...
Public Member Functions inherited from PEAR
	PEAR ($error_class=null)
	Constructor. More...
	_PEAR ()
	Destructor (the emulated type of...). More...
&	getStaticProperty ($class, $var)
	If you have a class that's mostly/entirely static, and you need static properties, you can use this method to simulate them. More...
	registerShutdownFunc ($func, $args=array())
	Use this function to register a shutdown method for static classes. More...
	isError ($data, $code=null)
	Tell whether a value is a PEAR error. More...
	setErrorHandling ($mode=null, $options=null)
	Sets how errors generated by this object should be handled. More...
	expectError ($code=' *')
	This method is used to tell which errors you expect to get. More...
	popExpect ()
	This method pops one element off the expected error codes stack. More...
	_checkDelExpect ($error_code)
	This method checks unsets an error code if available. More...
	delExpect ($error_code)
	This method deletes all occurences of the specified element from the expected error codes stack. More...
&	raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
	This method is a wrapper that returns an instance of the configured error class with this object's default error handling applied. More...
&	throwError ($message=null, $code=null, $userinfo=null)
	Simpler form of raiseError with fewer options. More...
	staticPushErrorHandling ($mode, $options=null)
	staticPopErrorHandling ()
	pushErrorHandling ($mode, $options=null)
	Push a new error handler on top of the error handler options stack. More...
	popErrorHandling ()
	Pop the last error handler used. More...
	loadExtension ($ext)
	OS independant PHP extension load. More...

Data Fields
	$name
	$index
	$_url_format
	$_parser
	$_filehandle
	$_using_tmpfile
	$_xls_rowmax
	$_xls_colmax
	$_xls_strmax
	$_dim_rowmin
	$_dim_rowmax
	$_dim_colmin
	$_dim_colmax
	$_colinfo
	$_selection
	$_panes
	$_active_pane
	$_frozen
	$selected
	$_paper_size
	$_orientation
	$_header
	$_footer
	$_hcenter
	$_vcenter
	$_margin_head
	$_margin_foot
	$_margin_left
	$_margin_right
	$_margin_top
	$_margin_bottom
	$title_rowmin
	$title_rowmax
	$title_colmin
	$print_rowmin
	$print_rowmax
	$print_colmin
	$print_colmax
	$_outline_on
	$_outline_style
	$_outline_below
	$_outline_right
	$_outline_row_level
	$_fit_page
	$_fit_width
	$_fit_height
	$_str_total
	$_str_unique
	$_str_table
	$_merged_ranges
	$_input_encoding
	$record = 0x01B8
	$length = 0x00000
if(! $format)	$url = preg_replace('/^external:/', '', $url)
	$url = preg_replace('/\//', "\\", $url)
if($str=='')	$str_error = $this->writeString($row1, $col1, $str, $format)
if(($str_error==-2) or($str_error==-3))	$absolute = 0x02
if(!preg_match("/\", $url)) if(preg_match("/^\\", $url)	$link_type ) = 0x01 | $absolute
	$dir_long = $url
if(preg_match("/\", $url))	$link_type = pack("V", $link_type)
	$up_count = preg_match_all("/\.\.\\\/", $dir_long, $useless)
	$dir_short = preg_replace("/\.\.\\\/", '', $dir_long) . "\0"
	$dir_short_len = pack("V", strlen($dir_short) )
	$dir_long_len = pack("V", strlen($dir_long) )
	$stream_len = pack("V", 0)
	$unknown1 = pack("H*",'D0C9EA79F9BACE118C8200AA004BA90B02000000' )
	$unknown2 = pack("H*",'0303000000000000C000000000000046' )
	$unknown3 = pack("H*",'FFFFADDE000000000000000000000000000000000000000')
	$unknown4 = pack("v", 0x03 )
	$data
	$header = pack("vv", $record, $length)
Data Fields inherited from Spreadsheet_Excel_Writer_BIFFwriter
	$_BIFF_version = 0x0500
	$_byte_order
	$_data
	$_datasize
	$_limit
	$_tmp_dir
Data Fields inherited from PEAR
	$_debug = false
	$_default_error_mode = null
	$_default_error_options = null
	$_default_error_handler = ''
	$_error_class = 'PEAR_Error'
	$_expected_errors = array()

Detailed Description

Definition at line 46 of file Worksheet.php.

Member Function Documentation

_append()

Spreadsheet_Excel_Writer_Worksheet::_append

(

$data

)

Store Worksheet data in memory using the parent's class append() or to a temporary file, the default.

private

Parameters

string

$data

The binary data to append

Definition at line 1274 of file Worksheet.php.

References $data, and Spreadsheet_Excel_Writer_BIFFwriter\_addContinue().

Referenced by _storeDataValidity(), _storeMergedCells(), _storeObjPicture(), _storePanes(), _storeSelection(), _storeWindow2(), _storeZoom(), _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), mergeCells(), setRow(), writeBlank(), writeFormula(), writeNote(), writeNumber(), writeString(), and writeStringBIFF8().

    {
        if ($this->_using_tmpfile) {
            // Add CONTINUE records if necessary
            if (strlen($data) > $this->_limit) {
                $data = $this->_addContinue($data);
            }
            fwrite($this->_filehandle, $data);
            $this->_datasize += strlen($data);
        } else {
            parent::_append($data);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_cellToRowcol()

Spreadsheet_Excel_Writer_Worksheet::_cellToRowcol

(

$cell

)

Convert an Excel cell reference in A1 notation to a zero based row and column reference; converts C1 to (0, 2).

private

Parameters

string

$cell

The cell reference.

Returns

array containing (row, column)

Definition at line 1334 of file Worksheet.php.

References $row.

Referenced by _substituteCellref().

    {
        preg_match("/\$?([A-I]?[A-Z])\$?(\d+)/",$cell,$match);
        $col     = $match[1];
        $row     = $match[2];

        // Convert base26 column string to number
        $chars = split('', $col);
        $expn  = 0;
        $col   = 0;

        while ($chars) {
            $char = array_pop($chars);        // LS char first
            $col += (ord($char) -ord('A') +1) * pow(26,$expn);
            $expn++;
        }

        // Convert 1-index to zero-index
        $row--;
        $col--;

        return(array($row, $col));
    }

Here is the caller graph for this function:

_checkRowCol()

Spreadsheet_Excel_Writer_Worksheet::_checkRowCol	(		$row,
			$col
	)

Check row and col before writing to a cell, and update the sheet's dimensions accordingly.

private

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column

Returns

boolean true for success, false if row and/or col are grester then maximums allowed.

Definition at line 1610 of file Worksheet.php.

References $row.

Referenced by writeFormula(), and writeStringBIFF8().

    {
        if ($row >= $this->_xls_rowmax) {
            return false;
        }
        if ($col >= $this->_xls_colmax) {
            return false;
        }
        if ($row <  $this->_dim_rowmin) {
            $this->_dim_rowmin = $row;
        }
        if ($row >  $this->_dim_rowmax) {
            $this->_dim_rowmax = $row;
        }
        if ($col <  $this->_dim_colmin) {
            $this->_dim_colmin = $col;
        }
        if ($col >  $this->_dim_colmax) {
            $this->_dim_colmax = $col;
        }
        return true;
    }

Here is the caller graph for this function:

_encodePassword()

Spreadsheet_Excel_Writer_Worksheet::_encodePassword

(

$plaintext

)

Based on the algorithm provided by Daniel Rentz of OpenOffice.

private

Parameters

string

$plaintext

The password to be encoded in plaintext.

Returns

string The encoded password

Definition at line 1365 of file Worksheet.php.

Referenced by protect().

    {
        $password = 0x0000;
        $i        = 1;       // char position

        // split the plain text password in its component characters
        $chars = preg_split('//', $plaintext, -1, PREG_SPLIT_NO_EMPTY);
        foreach ($chars as $char) {
            $value        = ord($char) << $i;   // shifted ASCII value
            $rotated_bits = $value >> 15;       // rotated bits beyond bit 15
            $value       &= 0x7fff;             // first 15 bits
            $password    ^= ($value | $rotated_bits);
            $i++;
        }

        $password ^= strlen($plaintext);
        $password ^= 0xCE4B;

        return($password);
    }

Here is the caller graph for this function:

_initialize()

Spreadsheet_Excel_Writer_Worksheet::_initialize

(

)

Open a tmp file to store the majority of the Worksheet data.

If this fails, for example due to write permissions, store the data in memory. This can be slow for large files.

private

Definition at line 478 of file Worksheet.php.

Referenced by Spreadsheet_Excel_Writer_Worksheet().

    {
        if ($this->_using_tmpfile == false) {
            return;
        }

        if ($this->_tmp_dir === '' && ini_get('open_basedir') === false) {
            // open_basedir restriction in effect - store data in memory
            // ToDo: Let the error actually have an effect somewhere
            $this->_using_tmpfile = false;  
            return new PEAR_Error('Temp file could not be opened since open_basedir restriction in effect - please use setTmpDir() - using memory storage instead');
        }

        // Open tmp file for storing Worksheet data
        if ($this->_tmp_dir === '') {
            $fh = tmpfile();
        } else {
            // For people with open base dir restriction
            $tmpfilename = tempnam($this->_tmp_dir, "Spreadsheet_Excel_Writer");
            $fh = @fopen($tmpfilename, "w+b");
        }

        if ($fh === false) {
            // If tmpfile() fails store data in memory
            $this->_using_tmpfile = false;
        } else {
            // Store filehandle
            $this->_filehandle = $fh;
        }
    }

Here is the caller graph for this function:

_positionImage()

Spreadsheet_Excel_Writer_Worksheet::_positionImage	(		$col_start,
			$row_start,
			$x1,
			$y1,
			$width,
			$height
	)

Calculate the vertices that define the position of the image as required by the OBJ record.

+---------—+---------—+ | A | B | +--—+---------—+---------—+ | |(x1,y1) | | | 1 |(A1)._______|______ | | | | | | | | | | | +--—+-—| BITMAP |--—+ | | | | | | 2 | |______________. | | | | (B2)| | | | (x2,y2)| +-— +---------—+---------—+

Example of a bitmap that covers some of the area from cell A1 to cell B2.

Based on the width and height of the bitmap we need to calculate 8 vars: $col_start, $row_start, $col_end, $row_end, $x1, $y1, $x2, $y2. The width and height of the cells are also variable and have to be taken into account. The values of $col_start and $row_start are passed in from the calling function. The values of $col_end and $row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels):

  x1 = X / W *1024
  y1 = Y / H *256
  x2 = (X-1) / W *1024
  y2 = (Y-1) / H *256

  Where:  X is distance from the left side of the underlying cell
          Y is distance from the top of the underlying cell
          W is the width of the cell
          H is the height of the cell

private

Note

the SDK incorrectly states that the height should be expressed as a percentage of 1024.

Parameters

integer	$col_start	Col containing upper left corner of object
integer	$row_start	Row containing top left corner of object
integer	$x1	Distance to left side of object
integer	$y1	Distance to top of object
integer	$width	Width of image frame
integer	$height	Height of image frame

Definition at line 3192 of file Worksheet.php.

References _sizeCol(), _sizeRow(), and _storeObjPicture().

Referenced by insertBitmap().

    {
        // Initialise end cell to the same as the start cell
        $col_end    = $col_start;  // Col containing lower right corner of object
        $row_end    = $row_start;  // Row containing bottom right corner of object

        // Zero the specified offset if greater than the cell dimensions
        if ($x1 >= $this->_sizeCol($col_start)) {
            $x1 = 0;
        }
        if ($y1 >= $this->_sizeRow($row_start)) {
            $y1 = 0;
        }

        $width      = $width  + $x1 -1;
        $height     = $height + $y1 -1;

        // Subtract the underlying cell widths to find the end cell of the image
        while ($width >= $this->_sizeCol($col_end)) {
            $width -= $this->_sizeCol($col_end);
            $col_end++;
        }

        // Subtract the underlying cell heights to find the end cell of the image
        while ($height >= $this->_sizeRow($row_end)) {
            $height -= $this->_sizeRow($row_end);
            $row_end++;
        }

        // Bitmap isn't allowed to start or finish in a hidden cell, i.e. a cell
        // with zero eight or width.
        //
        if ($this->_sizeCol($col_start) == 0) {
            return;
        }
        if ($this->_sizeCol($col_end)   == 0) {
            return;
        }
        if ($this->_sizeRow($row_start) == 0) {
            return;
        }
        if ($this->_sizeRow($row_end)   == 0) {
            return;
        }

        // Convert the pixel values to the percentage value expected by Excel
        $x1 = $x1     / $this->_sizeCol($col_start)   * 1024;
        $y1 = $y1     / $this->_sizeRow($row_start)   *  256;
        $x2 = $width  / $this->_sizeCol($col_end)     * 1024; // Distance to right side of object
        $y2 = $height / $this->_sizeRow($row_end)     *  256; // Distance to bottom of object

        $this->_storeObjPicture($col_start, $x1,
                                 $row_start, $y1,
                                 $col_end, $x2,
                                 $row_end, $y2);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_processBitmap()

Spreadsheet_Excel_Writer_Worksheet::_processBitmap

(

$bitmap

)

Convert a 24 bit bitmap into the modified internal format used by Windows.

This is described in BITMAPCOREHEADER and BITMAPCOREINFO structures in the MSDN library.

private

Parameters

string

$bitmap

The bitmap to process

Returns

array Array with data and properties of the bitmap

Definition at line 3385 of file Worksheet.php.

References $data, $header, $size, and PEAR\raiseError().

Referenced by insertBitmap().

    {
        // Open file.
        $bmp_fd = @fopen($bitmap,"rb");
        if (!$bmp_fd) {
            $this->raiseError("Couldn't import $bitmap");
        }

        // Slurp the file into a string.
        $data = fread($bmp_fd, filesize($bitmap));

        // Check that the file is big enough to be a bitmap.
        if (strlen($data) <= 0x36) {
            $this->raiseError("$bitmap doesn't contain enough data.\n");
        }

        // The first 2 bytes are used to identify the bitmap.
        $identity = unpack("A2ident", $data);
        if ($identity['ident'] != "BM") {
            $this->raiseError("$bitmap doesn't appear to be a valid bitmap image.\n");
        }

        // Remove bitmap data: ID.
        $data = substr($data, 2);

        // Read and remove the bitmap size. This is more reliable than reading
        // the data size at offset 0x22.
        //
        $size_array   = unpack("Vsa", substr($data, 0, 4));
        $size   = $size_array['sa'];
        $data   = substr($data, 4);
        $size  -= 0x36; // Subtract size of bitmap header.
        $size  += 0x0C; // Add size of BIFF header.

        // Remove bitmap data: reserved, offset, header length.
        $data = substr($data, 12);

        // Read and remove the bitmap width and height. Verify the sizes.
        $width_and_height = unpack("V2", substr($data, 0, 8));
        $width  = $width_and_height[1];
        $height = $width_and_height[2];
        $data   = substr($data, 8);
        if ($width > 0xFFFF) {
            $this->raiseError("$bitmap: largest image width supported is 65k.\n");
        }
        if ($height > 0xFFFF) {
            $this->raiseError("$bitmap: largest image height supported is 65k.\n");
        }

        // Read and remove the bitmap planes and bpp data. Verify them.
        $planes_and_bitcount = unpack("v2", substr($data, 0, 4));
        $data = substr($data, 4);
        if ($planes_and_bitcount[2] != 24) { // Bitcount
            $this->raiseError("$bitmap isn't a 24bit true color bitmap.\n");
        }
        if ($planes_and_bitcount[1] != 1) {
            $this->raiseError("$bitmap: only 1 plane supported in bitmap image.\n");
        }

        // Read and remove the bitmap compression. Verify compression.
        $compression = unpack("Vcomp", substr($data, 0, 4));
        $data = substr($data, 4);

        //$compression = 0;
        if ($compression['comp'] != 0) {
            $this->raiseError("$bitmap: compression not supported in bitmap image.\n");
        }

        // Remove bitmap data: data size, hres, vres, colours, imp. colours.
        $data = substr($data, 20);

        // Add the BITMAPCOREHEADER data
        $header  = pack("Vvvvv", 0x000c, $width, $height, 0x01, 0x18);
        $data    = $header . $data;

        return (array($width, $height, $size, $data));
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_sizeCol()

Spreadsheet_Excel_Writer_Worksheet::_sizeCol

(

$col

)

Convert the width of a cell from user's units to pixels.

By interpolation the relationship is: y = 7x +5. If the width hasn't been set by the user we use the default value. If the col is hidden we use a value of zero.

private

Parameters

integer

$col

The column

Returns

integer The width in pixels

Definition at line 3258 of file Worksheet.php.

Referenced by _positionImage().

    {
        // Look up the cell value to see if it has been changed
        if (isset($this->col_sizes[$col])) {
            if ($this->col_sizes[$col] == 0) {
                return(0);
            } else {
                return(floor(7 * $this->col_sizes[$col] + 5));
            }
        } else {
            return(64);
        }
    }

Here is the caller graph for this function:

_sizeRow()

Spreadsheet_Excel_Writer_Worksheet::_sizeRow

(

$row

)

Convert the height of a cell from user's units to pixels.

By interpolation the relationship is: y = 4/3x. If the height hasn't been set by the user we use the default value. If the row is hidden we use a value of zero. (Not possible to hide row yet).

private

Parameters

integer

$row

The row

Returns

integer The width in pixels

Definition at line 3282 of file Worksheet.php.

References $row.

Referenced by _positionImage().

    {
        // Look up the cell value to see if it has been changed
        if (isset($this->_row_sizes[$row])) {
            if ($this->_row_sizes[$row] == 0) {
                return(0);
            } else {
                return(floor(4/3 * $this->_row_sizes[$row]));
            }
        } else {
            return(17);
        }
    }

Here is the caller graph for this function:

_storeColinfo()

Spreadsheet_Excel_Writer_Worksheet::_storeColinfo

(

$col_array

)

Write BIFF record COLINFO to define column widths.

Note: The SDK says the record length is 0x0B but Excel writes a 0x0C length record.

private

Parameters

array

$col_array

This is the only parameter received and is composed of the following: 0 => First formatted column, 1 => Last formatted column, 2 => Col width (8.43 is Excel default), 3 => The optional XF format of the column, 4 => Option flags. 5 => Optional outline level

Definition at line 2308 of file Worksheet.php.

References $data, $header, $length, $record, Spreadsheet_Excel_Writer_BIFFwriter\_prepend(), and _XF().

Referenced by close().

    {
        if (isset($col_array[0])) {
            $colFirst = $col_array[0];
        }
        if (isset($col_array[1])) {
            $colLast = $col_array[1];
        }
        if (isset($col_array[2])) {
            $coldx = $col_array[2];
        } else {
            $coldx = 8.43;
        }
        if (isset($col_array[3])) {
            $format = $col_array[3];
        } else {
            $format = 0;
        }
        if (isset($col_array[4])) {
            $grbit = $col_array[4];
        } else {
            $grbit = 0;
        }
        if (isset($col_array[5])) {
            $level = $col_array[5];
        } else {
            $level = 0;
        }
        $record   = 0x007D;          // Record identifier
        $length   = 0x000B;          // Number of bytes to follow

        $coldx   += 0.72;            // Fudge. Excel subtracts 0.72 !?
        $coldx   *= 256;             // Convert to units of 1/256 of a char

        $ixfe     = $this->_XF($format);
        $reserved = 0x00;            // Reserved

        $level = max(0, min($level, 7));
        $grbit |= $level << 8;

        $header   = pack("vv",     $record, $length);
        $data     = pack("vvvvvC", $colFirst, $colLast, $coldx,
                                   $ixfe, $grbit, $reserved);
        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeDataValidity()

Spreadsheet_Excel_Writer_Worksheet::_storeDataValidity

(

)

Store the DVAL and DV records.

private

Definition at line 3498 of file Worksheet.php.

References $data, $header, $length, $record, and _append().

    {
        $record      = 0x01b2;      // Record identifier
        $length      = 0x0012;      // Bytes to follow

        $grbit       = 0x0002;      // Prompt box at cell, no cached validity data at DV records
        $horPos      = 0x00000000;  // Horizontal position of prompt box, if fixed position
        $verPos      = 0x00000000;  // Vertical position of prompt box, if fixed position
        $objId       = 0xffffffff;  // Object identifier of drop down arrow object, or -1 if not visible

        $header      = pack('vv', $record, $length);
        $data        = pack('vVVVV', $grbit, $horPos, $verPos, $objId,
                                     count($this->_dv));
        $this->_append($header.$data);

        $record = 0x01be;              // Record identifier
        foreach ($this->_dv as $dv) {
            $length = strlen($dv);      // Bytes to follow
            $header = pack("vv", $record, $length);
            $this->_append($header . $dv);
        }
    }

Here is the call graph for this function:

_storeDefcol()

Spreadsheet_Excel_Writer_Worksheet::_storeDefcol

(

)

Write BIFF record DEFCOLWIDTH if COLINFO records are in use.

private

Definition at line 2282 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record   = 0x0055;      // Record identifier
        $length   = 0x0002;      // Number of bytes to follow
        $colwidth = 0x0008;      // Default column width

        $header   = pack("vv", $record, $length);
        $data     = pack("v",  $colwidth);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeDimensions()

Spreadsheet_Excel_Writer_Worksheet::_storeDimensions

(

)

Writes Excel DIMENSIONS to define the area in which there is data.

private

Definition at line 2196 of file Worksheet.php.

References $_dim_colmin, $_dim_rowmin, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record    = 0x0200;                 // Record identifier
        $row_min   = $this->_dim_rowmin;     // First row
        $row_max   = $this->_dim_rowmax + 1; // Last row plus 1
        $col_min   = $this->_dim_colmin;     // First column
        $col_max   = $this->_dim_colmax + 1; // Last column plus 1
        $reserved  = 0x0000;                 // Reserved by Excel

        if ($this->_BIFF_version == 0x0500) {
            $length    = 0x000A;               // Number of bytes to follow
            $data      = pack("vvvvv", $row_min, $row_max,
                                       $col_min, $col_max, $reserved);
        } elseif ($this->_BIFF_version == 0x0600) {
            $length    = 0x000E;
            $data      = pack("VVvvv", $row_min, $row_max,
                                       $col_min, $col_max, $reserved);
        }
        $header = pack("vv", $record, $length);
        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeExterncount()

Spreadsheet_Excel_Writer_Worksheet::_storeExterncount

(

$count

)

Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.

Excel only stores references to external sheets that are used in formulas. For simplicity we store references to all the sheets in the workbook regardless of whether they are used or not. This reduces the overall complexity and eliminates the need for a two way dialogue between the formula parser the worksheet objects.

private

Parameters

integer

$count

The number of external sheet references in this worksheet

Definition at line 2432 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record = 0x0016;          // Record identifier
        $length = 0x0002;          // Number of bytes to follow

        $header = pack("vv", $record, $length);
        $data   = pack("v",  $count);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeExternsheet()

Spreadsheet_Excel_Writer_Worksheet::_storeExternsheet

(

$sheetname

)

Writes the Excel BIFF EXTERNSHEET record.

These references are used by formulas. A formula references a sheet name via an index. Since we store a reference to all of the external worksheets the EXTERNSHEET index is the same as the worksheet index.

private

Parameters

string

$sheetname

The name of a external worksheet

Definition at line 2451 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record    = 0x0017;         // Record identifier

        // References to the current sheet are encoded differently to references to
        // external sheets.
        //
        if ($this->name == $sheetname) {
            $sheetname = '';
            $length    = 0x02;  // The following 2 bytes
            $cch       = 1;     // The following byte
            $rgch      = 0x02;  // Self reference
        } else {
            $length    = 0x02 + strlen($sheetname);
            $cch       = strlen($sheetname);
            $rgch      = 0x03;  // Reference to a sheet in the current workbook
        }

        $header = pack("vv",  $record, $length);
        $data   = pack("CC", $cch, $rgch);
        $this->_prepend($header . $data . $sheetname);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeFooter()

Spreadsheet_Excel_Writer_Worksheet::_storeFooter

(

)

Store the footer caption BIFF record.

private

Definition at line 2649 of file Worksheet.php.

References $_footer, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0015;               // Record identifier

        $str      = $this->_footer;       // Footer string
        $cch      = strlen($str);         // Length of footer string
        if ($this->_BIFF_version == 0x0600) {
            $encoding = 0x0;                  // TODO: Unicode support
            $length   = 3 + $cch;             // Bytes to follow
        } else {
            $length  = 1 + $cch;
        }

        $header    = pack("vv", $record, $length);
        if ($this->_BIFF_version == 0x0600) {
            $data      = pack("vC",  $cch, $encoding);
        } else {
            $data      = pack("C",  $cch);
        }

        $this->_prepend($header . $data . $str);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeGridset()

Spreadsheet_Excel_Writer_Worksheet::_storeGridset

(

)

Write the GRIDSET BIFF record.

Must be used in conjunction with the PRINTGRIDLINES record.

private

Definition at line 2865 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record      = 0x0082;                        // Record identifier
        $length      = 0x0002;                        // Bytes to follow

        $fGridSet    = !($this->_print_gridlines);     // Boolean flag

        $header      = pack("vv",  $record, $length);
        $data        = pack("v",   $fGridSet);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeGuts()

Spreadsheet_Excel_Writer_Worksheet::_storeGuts

(

)

Write the GUTS BIFF record.

This is used to configure the gutter margins where Excel outline symbols are displayed. The visibility of the gutters is controlled by a flag in WSBOOL.

See also

_storeWsbool() private

Definition at line 2885 of file Worksheet.php.

References $_outline_row_level, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record      = 0x0080;   // Record identifier
        $length      = 0x0008;   // Bytes to follow

        $dxRwGut     = 0x0000;   // Size of row gutter
        $dxColGut    = 0x0000;   // Size of col gutter

        $row_level   = $this->_outline_row_level;
        $col_level   = 0;

        // Calculate the maximum column outline level. The equivalent calculation
        // for the row outline level is carried out in setRow().
        $colcount = count($this->_colinfo);
        for ($i = 0; $i < $colcount; $i++) {
           // Skip cols without outline level info.
           if (count($this->_colinfo[$i]) >= 6) {
              $col_level = max($this->_colinfo[$i][5], $col_level);
           }
        }

        // Set the limits for the outline levels (0 <= x <= 7).
        $col_level = max(0, min($col_level, 7));

        // The displayed level is one greater than the max outline levels
        if ($row_level) {
            $row_level++;
        }
        if ($col_level) {
            $col_level++;
        }

        $header = pack("vv",   $record, $length);
        $data   = pack("vvvv", $dxRwGut, $dxColGut, $row_level, $col_level);

        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeHbreak()

Spreadsheet_Excel_Writer_Worksheet::_storeHbreak

(

)

Write the HORIZONTALPAGEBREAKS BIFF record.

private

Definition at line 2972 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        // Return if the user hasn't specified pagebreaks
        if (empty($this->_hbreaks)) {
            return;
        }

        // Sort and filter array of page breaks
        $breaks = $this->_hbreaks;
        sort($breaks, SORT_NUMERIC);
        if ($breaks[0] == 0) { // don't use first break if it's 0
            array_shift($breaks);
        }

        $record  = 0x001b;               // Record identifier
        $cbrk    = count($breaks);       // Number of page breaks
        if ($this->_BIFF_version == 0x0600) {
            $length  = 2 + 6*$cbrk;      // Bytes to follow
        } else {
            $length  = 2 + 2*$cbrk;      // Bytes to follow
        }

        $header  = pack("vv", $record, $length);
        $data    = pack("v",  $cbrk);

        // Append each page break
        foreach ($breaks as $break) {
            if ($this->_BIFF_version == 0x0600) {
                $data .= pack("vvv", $break, 0x0000, 0x00ff);
            } else {
                $data .= pack("v", $break);
            }
        }

        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeHcenter()

Spreadsheet_Excel_Writer_Worksheet::_storeHcenter

(

)

Store the horizontal centering HCENTER BIFF record.

private

Definition at line 2677 of file Worksheet.php.

References $_hcenter, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record   = 0x0083;              // Record identifier
        $length   = 0x0002;              // Bytes to follow

        $fHCenter = $this->_hcenter;     // Horizontal centering

        $header    = pack("vv", $record, $length);
        $data      = pack("v",  $fHCenter);

        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeHeader()

Spreadsheet_Excel_Writer_Worksheet::_storeHeader

(

)

Store the header caption BIFF record.

private

Definition at line 2621 of file Worksheet.php.

References $_header, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0014;               // Record identifier

        $str      = $this->_header;       // header string
        $cch      = strlen($str);         // Length of header string
        if ($this->_BIFF_version == 0x0600) {
            $encoding = 0x0;                  // TODO: Unicode support
            $length   = 3 + $cch;             // Bytes to follow
        } else {
            $length  = 1 + $cch;             // Bytes to follow
        }

        $header   = pack("vv", $record, $length);
        if ($this->_BIFF_version == 0x0600) {
            $data     = pack("vC",  $cch, $encoding);
        } else {
            $data      = pack("C",  $cch);
        }

        $this->_prepend($header.$data.$str);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeMarginBottom()

Spreadsheet_Excel_Writer_Worksheet::_storeMarginBottom

(

)

Store the BOTTOMMARGIN BIFF record.

private

Definition at line 2775 of file Worksheet.php.

References $_margin_bottom, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0029;                   // Record identifier
        $length  = 0x0008;                   // Bytes to follow

        $margin  = $this->_margin_bottom;     // Margin in inches

        $header    = pack("vv",  $record, $length);
        $data      = pack("d",   $margin);
        if ($this->_byte_order) { // if it's Big Endian
            $data = strrev($data);
        }

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeMarginLeft()

Spreadsheet_Excel_Writer_Worksheet::_storeMarginLeft

(

)

Store the LEFTMARGIN BIFF record.

private

Definition at line 2712 of file Worksheet.php.

References $_margin_left, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0026;                   // Record identifier
        $length  = 0x0008;                   // Bytes to follow

        $margin  = $this->_margin_left;       // Margin in inches

        $header    = pack("vv",  $record, $length);
        $data      = pack("d",   $margin);
        if ($this->_byte_order) { // if it's Big Endian
            $data = strrev($data);
        }

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeMarginRight()

Spreadsheet_Excel_Writer_Worksheet::_storeMarginRight

(

)

Store the RIGHTMARGIN BIFF record.

private

Definition at line 2733 of file Worksheet.php.

References $_margin_right, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0027;                   // Record identifier
        $length  = 0x0008;                   // Bytes to follow

        $margin  = $this->_margin_right;      // Margin in inches

        $header    = pack("vv",  $record, $length);
        $data      = pack("d",   $margin);
        if ($this->_byte_order) { // if it's Big Endian
            $data = strrev($data);
        }

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeMarginTop()

Spreadsheet_Excel_Writer_Worksheet::_storeMarginTop

(

)

Store the TOPMARGIN BIFF record.

private

Definition at line 2754 of file Worksheet.php.

References $_margin_top, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record  = 0x0028;                   // Record identifier
        $length  = 0x0008;                   // Bytes to follow

        $margin  = $this->_margin_top;        // Margin in inches

        $header    = pack("vv",  $record, $length);
        $data      = pack("d",   $margin);
        if ($this->_byte_order) { // if it's Big Endian
            $data = strrev($data);
        }

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeMergedCells()

Spreadsheet_Excel_Writer_Worksheet::_storeMergedCells

(

)

Store the MERGEDCELLS record for all ranges of merged cells.

private

Definition at line 2402 of file Worksheet.php.

References $data, $header, $length, $record, and _append().

Referenced by close().

    {
        // if there are no merged cell ranges set, return
        if (count($this->_merged_ranges) == 0) {
            return;
        }
        $record   = 0x00E5;
        $length   = 2 + count($this->_merged_ranges) * 8;

        $header   = pack('vv', $record, $length);
        $data     = pack('v',  count($this->_merged_ranges));
        foreach ($this->_merged_ranges as $range) {
            $data .= pack('vvvv', $range[0], $range[2], $range[1], $range[3]);
        }
        $this->_append($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeObjPicture()

Spreadsheet_Excel_Writer_Worksheet::_storeObjPicture	(		$colL,
			$dxL,
			$rwT,
			$dyT,
			$colR,
			$dxR,
			$rwB,
			$dyB
	)

Store the OBJ record that precedes an IMDATA record.

This could be generalise to support other Excel objects.

private

Parameters

integer	$colL	Column containing upper left corner of object
integer	$dxL	Distance from left side of cell
integer	$rwT	Row containing top left corner of object
integer	$dyT	Distance from top of cell
integer	$colR	Column containing lower right corner of object
integer	$dxR	Distance from right of cell
integer	$rwB	Row containing bottom right corner of object
integer	$dyB	Distance from bottom of cell

Definition at line 3310 of file Worksheet.php.

References $data, $header, $length, $record, and _append().

Referenced by _positionImage().

    {
        $record      = 0x005d;   // Record identifier
        $length      = 0x003c;   // Bytes to follow

        $cObj        = 0x0001;   // Count of objects in file (set to 1)
        $OT          = 0x0008;   // Object type. 8 = Picture
        $id          = 0x0001;   // Object ID
        $grbit       = 0x0614;   // Option flags

        $cbMacro     = 0x0000;   // Length of FMLA structure
        $Reserved1   = 0x0000;   // Reserved
        $Reserved2   = 0x0000;   // Reserved

        $icvBack     = 0x09;     // Background colour
        $icvFore     = 0x09;     // Foreground colour
        $fls         = 0x00;     // Fill pattern
        $fAuto       = 0x00;     // Automatic fill
        $icv         = 0x08;     // Line colour
        $lns         = 0xff;     // Line style
        $lnw         = 0x01;     // Line weight
        $fAutoB      = 0x00;     // Automatic border
        $frs         = 0x0000;   // Frame style
        $cf          = 0x0009;   // Image format, 9 = bitmap
        $Reserved3   = 0x0000;   // Reserved
        $cbPictFmla  = 0x0000;   // Length of FMLA structure
        $Reserved4   = 0x0000;   // Reserved
        $grbit2      = 0x0001;   // Option flags
        $Reserved5   = 0x0000;   // Reserved


        $header      = pack("vv", $record, $length);
        $data        = pack("V", $cObj);
        $data       .= pack("v", $OT);
        $data       .= pack("v", $id);
        $data       .= pack("v", $grbit);
        $data       .= pack("v", $colL);
        $data       .= pack("v", $dxL);
        $data       .= pack("v", $rwT);
        $data       .= pack("v", $dyT);
        $data       .= pack("v", $colR);
        $data       .= pack("v", $dxR);
        $data       .= pack("v", $rwB);
        $data       .= pack("v", $dyB);
        $data       .= pack("v", $cbMacro);
        $data       .= pack("V", $Reserved1);
        $data       .= pack("v", $Reserved2);
        $data       .= pack("C", $icvBack);
        $data       .= pack("C", $icvFore);
        $data       .= pack("C", $fls);
        $data       .= pack("C", $fAuto);
        $data       .= pack("C", $icv);
        $data       .= pack("C", $lns);
        $data       .= pack("C", $lnw);
        $data       .= pack("C", $fAutoB);
        $data       .= pack("v", $frs);
        $data       .= pack("V", $cf);
        $data       .= pack("v", $Reserved3);
        $data       .= pack("v", $cbPictFmla);
        $data       .= pack("v", $Reserved4);
        $data       .= pack("v", $grbit2);
        $data       .= pack("V", $Reserved5);

        $this->_append($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storePanes()

Spreadsheet_Excel_Writer_Worksheet::_storePanes

(

$panes

)

Writes the Excel BIFF PANE record.

The panes can either be frozen or thawed (unfrozen). Frozen panes are specified in terms of an integer number of rows and columns. Thawed panes are specified in terms of Excel's units for rows and columns.

private

Parameters

array

$panes

This is the only parameter received and is composed of the following: 0 => Vertical split position, 1 => Horizontal split position 2 => Top row visible 3 => Leftmost column visible 4 => Active pane

Definition at line 2488 of file Worksheet.php.

References $data, $header, $length, $record, $x, $y, and _append().

Referenced by close().

    {
        $y       = $panes[0];
        $x       = $panes[1];
        $rwTop   = $panes[2];
        $colLeft = $panes[3];
        if (count($panes) > 4) { // if Active pane was received
            $pnnAct = $panes[4];
        } else {
            $pnnAct = null;
        }
        $record  = 0x0041;       // Record identifier
        $length  = 0x000A;       // Number of bytes to follow

        // Code specific to frozen or thawed panes.
        if ($this->_frozen) {
            // Set default values for $rwTop and $colLeft
            if (!isset($rwTop)) {
                $rwTop   = $y;
            }
            if (!isset($colLeft)) {
                $colLeft = $x;
            }
        } else {
            // Set default values for $rwTop and $colLeft
            if (!isset($rwTop)) {
                $rwTop   = 0;
            }
            if (!isset($colLeft)) {
                $colLeft = 0;
            }

            // Convert Excel's row and column units to the internal units.
            // The default row height is 12.75
            // The default column width is 8.43
            // The following slope and intersection values were interpolated.
            //
            $y = 20*$y      + 255;
            $x = 113.879*$x + 390;
        }


        // Determine which pane should be active. There is also the undocumented
        // option to override this should it be necessary: may be removed later.
        //
        if (!isset($pnnAct)) {
            if ($x != 0 && $y != 0) {
                $pnnAct = 0; // Bottom right
            }
            if ($x != 0 && $y == 0) {
                $pnnAct = 1; // Top right
            }
            if ($x == 0 && $y != 0) {
                $pnnAct = 2; // Bottom left
            }
            if ($x == 0 && $y == 0) {
                $pnnAct = 3; // Top left
            }
        }

        $this->_active_pane = $pnnAct; // Used in _storeSelection

        $header     = pack("vv",    $record, $length);
        $data       = pack("vvvvv", $x, $y, $rwTop, $colLeft, $pnnAct);
        $this->_append($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storePassword()

Spreadsheet_Excel_Writer_Worksheet::_storePassword

(

)

Write the worksheet PASSWORD record.

private

Definition at line 3083 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        // Exit unless sheet protection and password have been specified
        if (($this->_protect == 0) || (!isset($this->_password))) {
            return;
        }

        $record      = 0x0013;               // Record identifier
        $length      = 0x0002;               // Bytes to follow

        $wPassword   = $this->_password;     // Encoded password

        $header      = pack("vv", $record, $length);
        $data        = pack("v",  $wPassword);

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storePrintGridlines()

Spreadsheet_Excel_Writer_Worksheet::_storePrintGridlines

(

)

Write the PRINTGRIDLINES BIFF record.

Must be used in conjunction with the GRIDSET record.

private

Definition at line 2847 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record      = 0x002b;                    // Record identifier
        $length      = 0x0002;                    // Bytes to follow

        $fPrintGrid  = $this->_print_gridlines;    // Boolean flag

        $header      = pack("vv", $record, $length);
        $data        = pack("v", $fPrintGrid);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storePrintHeaders()

Spreadsheet_Excel_Writer_Worksheet::_storePrintHeaders

(

)

Write the PRINTHEADERS BIFF record.

private

Definition at line 2829 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record      = 0x002a;                   // Record identifier
        $length      = 0x0002;                   // Bytes to follow

        $fPrintRwCol = $this->_print_headers;     // Boolean flag

        $header      = pack("vv", $record, $length);
        $data        = pack("v", $fPrintRwCol);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeProtect()

Spreadsheet_Excel_Writer_Worksheet::_storeProtect

(

)

Set the Biff PROTECT record to indicate that the worksheet is protected.

private

Definition at line 3060 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        // Exit unless sheet protection has been specified
        if ($this->_protect == 0) {
            return;
        }

        $record      = 0x0012;             // Record identifier
        $length      = 0x0002;             // Bytes to follow

        $fLock       = $this->_protect;    // Worksheet is protected

        $header      = pack("vv", $record, $length);
        $data        = pack("v",  $fLock);

        $this->_prepend($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeSelection()

Spreadsheet_Excel_Writer_Worksheet::_storeSelection

(

$array

)

Write BIFF record SELECTION.

private

Parameters

array

$array

array containing ($rwFirst,$colFirst,$rwLast,$colLast)

See also

setSelection()

Definition at line 2361 of file Worksheet.php.

References $_active_pane, $data, $header, $length, $record, and _append().

Referenced by close().

    {
        list($rwFirst,$colFirst,$rwLast,$colLast) = $array;
        $record   = 0x001D;                  // Record identifier
        $length   = 0x000F;                  // Number of bytes to follow

        $pnn      = $this->_active_pane;     // Pane position
        $rwAct    = $rwFirst;                // Active row
        $colAct   = $colFirst;               // Active column
        $irefAct  = 0;                       // Active cell ref
        $cref     = 1;                       // Number of refs

        if (!isset($rwLast)) {
            $rwLast   = $rwFirst;       // Last  row in reference
        }
        if (!isset($colLast)) {
            $colLast  = $colFirst;      // Last  col in reference
        }

        // Swap last row/col for first row/col as necessary
        if ($rwFirst > $rwLast) {
            list($rwFirst, $rwLast) = array($rwLast, $rwFirst);
        }

        if ($colFirst > $colLast) {
            list($colFirst, $colLast) = array($colLast, $colFirst);
        }

        $header   = pack("vv",         $record, $length);
        $data     = pack("CvvvvvvCC",  $pnn, $rwAct, $colAct,
                                       $irefAct, $cref,
                                       $rwFirst, $rwLast,
                                       $colFirst, $colLast);
        $this->_append($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeSetup()

Spreadsheet_Excel_Writer_Worksheet::_storeSetup

(

)

Store the page setup SETUP BIFF record.

private

Definition at line 2560 of file Worksheet.php.

References $_fit_height, $_fit_width, $_margin_foot, $_margin_head, $_orientation, $_paper_size, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record       = 0x00A1;                  // Record identifier
        $length       = 0x0022;                  // Number of bytes to follow

        $iPaperSize   = $this->_paper_size;    // Paper size
        $iScale       = $this->_print_scale;   // Print scaling factor
        $iPageStart   = 0x01;                 // Starting page number
        $iFitWidth    = $this->_fit_width;    // Fit to number of pages wide
        $iFitHeight   = $this->_fit_height;   // Fit to number of pages high
        $grbit        = 0x00;                 // Option flags
        $iRes         = 0x0258;               // Print resolution
        $iVRes        = 0x0258;               // Vertical print resolution
        $numHdr       = $this->_margin_head;  // Header Margin
        $numFtr       = $this->_margin_foot;   // Footer Margin
        $iCopies      = 0x01;                 // Number of copies

        $fLeftToRight = 0x0;                     // Print over then down
        $fLandscape   = $this->_orientation;     // Page orientation
        $fNoPls       = 0x0;                     // Setup not read from printer
        $fNoColor     = 0x0;                     // Print black and white
        $fDraft       = 0x0;                     // Print draft quality
        $fNotes       = 0x0;                     // Print notes
        $fNoOrient    = 0x0;                     // Orientation not set
        $fUsePage     = 0x0;                     // Use custom starting page

        $grbit           = $fLeftToRight;
        $grbit          |= $fLandscape    << 1;
        $grbit          |= $fNoPls        << 2;
        $grbit          |= $fNoColor      << 3;
        $grbit          |= $fDraft        << 4;
        $grbit          |= $fNotes        << 5;
        $grbit          |= $fNoOrient     << 6;
        $grbit          |= $fUsePage      << 7;

        $numHdr = pack("d", $numHdr);
        $numFtr = pack("d", $numFtr);
        if ($this->_byte_order) { // if it's Big Endian
            $numHdr = strrev($numHdr);
            $numFtr = strrev($numFtr);
        }

        $header = pack("vv", $record, $length);
        $data1  = pack("vvvvvvvv", $iPaperSize,
                                   $iScale,
                                   $iPageStart,
                                   $iFitWidth,
                                   $iFitHeight,
                                   $grbit,
                                   $iRes,
                                   $iVRes);
        $data2  = $numHdr.$numFtr;
        $data3  = pack("v", $iCopies);
        $this->_prepend($header . $data1 . $data2 . $data3);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeVbreak()

Spreadsheet_Excel_Writer_Worksheet::_storeVbreak

(

)

Write the VERTICALPAGEBREAKS BIFF record.

private

Definition at line 3015 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        // Return if the user hasn't specified pagebreaks
        if (empty($this->_vbreaks)) {
            return;
        }

        // 1000 vertical pagebreaks appears to be an internal Excel 5 limit.
        // It is slightly higher in Excel 97/200, approx. 1026
        $breaks = array_slice($this->_vbreaks,0,1000);

        // Sort and filter array of page breaks
        sort($breaks, SORT_NUMERIC);
        if ($breaks[0] == 0) { // don't use first break if it's 0
            array_shift($breaks);
        }

        $record  = 0x001a;               // Record identifier
        $cbrk    = count($breaks);       // Number of page breaks
        if ($this->_BIFF_version == 0x0600) {
            $length  = 2 + 6*$cbrk;      // Bytes to follow
        } else {
            $length  = 2 + 2*$cbrk;      // Bytes to follow
        }

        $header  = pack("vv",  $record, $length);
        $data    = pack("v",   $cbrk);

        // Append each page break
        foreach ($breaks as $break) {
            if ($this->_BIFF_version == 0x0600) {
                $data .= pack("vvv", $break, 0x0000, 0xffff);
            } else {
                $data .= pack("v", $break);
            }
        }

        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeVcenter()

Spreadsheet_Excel_Writer_Worksheet::_storeVcenter

(

)

Store the vertical centering VCENTER BIFF record.

private

Definition at line 2695 of file Worksheet.php.

References $_vcenter, $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record   = 0x0084;              // Record identifier
        $length   = 0x0002;              // Bytes to follow

        $fVCenter = $this->_vcenter;     // Horizontal centering

        $header    = pack("vv", $record, $length);
        $data      = pack("v",  $fVCenter);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeWindow2()

Spreadsheet_Excel_Writer_Worksheet::_storeWindow2

(

)

Write BIFF record Window2.

private

Definition at line 2223 of file Worksheet.php.

References $_frozen, $_outline_on, $data, $header, $length, $record, $selected, and _append().

Referenced by close().

    {
        $record         = 0x023E;     // Record identifier
        if ($this->_BIFF_version == 0x0500) {
            $length         = 0x000A;     // Number of bytes to follow
        } elseif ($this->_BIFF_version == 0x0600) {
            $length         = 0x0012;
        }

        $grbit          = 0x00B6;     // Option flags
        $rwTop          = 0x0000;     // Top row visible in window
        $colLeft        = 0x0000;     // Leftmost column visible in window


        // The options flags that comprise $grbit
        $fDspFmla       = 0;                     // 0 - bit
        $fDspGrid       = $this->_screen_gridlines; // 1
        $fDspRwCol      = 1;                     // 2
        $fFrozen        = $this->_frozen;        // 3
        $fDspZeros      = 1;                     // 4
        $fDefaultHdr    = 1;                     // 5
        $fArabic        = 0;                     // 6
        $fDspGuts       = $this->_outline_on;    // 7
        $fFrozenNoSplit = 0;                     // 0 - bit
        $fSelected      = $this->selected;       // 1
        $fPaged         = 1;                     // 2

        $grbit             = $fDspFmla;
        $grbit            |= $fDspGrid       << 1;
        $grbit            |= $fDspRwCol      << 2;
        $grbit            |= $fFrozen        << 3;
        $grbit            |= $fDspZeros      << 4;
        $grbit            |= $fDefaultHdr    << 5;
        $grbit            |= $fArabic        << 6;
        $grbit            |= $fDspGuts       << 7;
        $grbit            |= $fFrozenNoSplit << 8;
        $grbit            |= $fSelected      << 9;
        $grbit            |= $fPaged         << 10;

        $header  = pack("vv",   $record, $length);
        $data    = pack("vvv", $grbit, $rwTop, $colLeft);
        // FIXME !!!
        if ($this->_BIFF_version == 0x0500) {
            $rgbHdr         = 0x00000000; // Row/column heading and gridline color
            $data .= pack("V", $rgbHdr);
        } elseif ($this->_BIFF_version == 0x0600) {
            $rgbHdr       = 0x0040; // Row/column heading and gridline color index
            $zoom_factor_page_break = 0x0000;
            $zoom_factor_normal     = 0x0000;
            $data .= pack("vvvvV", $rgbHdr, 0x0000, $zoom_factor_page_break, $zoom_factor_normal, 0x00000000);
        }
        $this->_append($header.$data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeWsbool()

Spreadsheet_Excel_Writer_Worksheet::_storeWsbool

(

)

Write the WSBOOL BIFF record, mainly for fit-to-page.

Used in conjunction with the SETUP record.

private

Definition at line 2930 of file Worksheet.php.

References $data, $header, $length, $record, and Spreadsheet_Excel_Writer_BIFFwriter\_prepend().

Referenced by close().

    {
        $record      = 0x0081;   // Record identifier
        $length      = 0x0002;   // Bytes to follow
        $grbit       = 0x0000;

        // The only option that is of interest is the flag for fit to page. So we
        // set all the options in one go.
        //
        /*if ($this->_fit_page) {
            $grbit = 0x05c1;
        } else {
            $grbit = 0x04c1;
        }*/
        // Set the option flags
        $grbit |= 0x0001;                           // Auto page breaks visible
        if ($this->_outline_style) {
            $grbit |= 0x0020; // Auto outline styles
        }
        if ($this->_outline_below) {
            $grbit |= 0x0040; // Outline summary below
        }
        if ($this->_outline_right) {
            $grbit |= 0x0080; // Outline summary right
        }
        if ($this->_fit_page) {
            $grbit |= 0x0100; // Page setup fit to page
        }
        if ($this->_outline_on) {
            $grbit |= 0x0400; // Outline symbols displayed
        }

        $header = pack("vv", $record, $length);
        $data   = pack("v",  $grbit);
        $this->_prepend($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_storeZoom()

Spreadsheet_Excel_Writer_Worksheet::_storeZoom

(

)

Store the window zoom factor.

This should be a reduced fraction but for simplicity we will store all fractions with a numerator of 100.

private

Definition at line 3469 of file Worksheet.php.

References $data, $header, $length, $record, and _append().

Referenced by close().

    {
        // If scale is 100 we don't need to write a record
        if ($this->_zoom == 100) {
            return;
        }

        $record      = 0x00A0;               // Record identifier
        $length      = 0x0004;               // Bytes to follow

        $header      = pack("vv", $record, $length);
        $data        = pack("vv", $this->_zoom, 100);
        $this->_append($header . $data);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_substituteCellref()

Spreadsheet_Excel_Writer_Worksheet::_substituteCellref

(

$cell

)

Substitute an Excel cell reference in A1 notation for zero based row and column values in an argument list.

Ex: ("A4", "Hello") is converted to (3, 0, "Hello").

private

Parameters

string

$cell

The cell reference. Or range of cells.

Returns

array

Definition at line 1298 of file Worksheet.php.

References _cellToRowcol(), PEAR_ERROR_DIE, and PEAR\raiseError().

    {
        $cell = strtoupper($cell);

        // Convert a column range: 'A:A' or 'B:G'
        if (preg_match("/([A-I]?[A-Z]):([A-I]?[A-Z])/", $cell, $match)) {
            list($no_use, $col1) =  $this->_cellToRowcol($match[1] .'1'); // Add a dummy row
            list($no_use, $col2) =  $this->_cellToRowcol($match[2] .'1'); // Add a dummy row
            return(array($col1, $col2));
        }

        // Convert a cell range: 'A1:B7'
        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+):\$?([A-I]?[A-Z]\$?\d+)/", $cell, $match)) {
            list($row1, $col1) =  $this->_cellToRowcol($match[1]);
            list($row2, $col2) =  $this->_cellToRowcol($match[2]);
            return(array($row1, $col1, $row2, $col2));
        }

        // Convert a cell reference: 'A1' or 'AD2000'
        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+)/", $cell)) {
            list($row1, $col1) =  $this->_cellToRowcol($match[1]);
            return(array($row1, $col1));
        }

        // TODO use real error codes
        $this->raiseError("Unknown cell reference $cell", 0, PEAR_ERROR_DIE);
    }

Here is the call graph for this function:

_writeUrlExternal()

Spreadsheet_Excel_Writer_Worksheet::_writeUrlExternal	(		$row1,
			$col1,
			$row2,
			$col2,
			$url,
			$str,
			$format = null
	)

Write links to external directory names such as 'c:.xls', c:.xls::Sheet1!A1', '../../foo.xls'.

and '../../foo.xls::Sheet1!A1'.

Note: Excel writes some relative links with the $dir_long string. We ignore these cases for the sake of simpler code.

private

See also

writeUrl()

Parameters

integer	$row1	Start row
integer	$col1	Start column
integer	$row2	End row
integer	$col2	End column
string	$url	URL string
string	$str	Alternative label
mixed	$format	The cell format

Returns

integer

Definition at line 2013 of file Worksheet.php.

Referenced by _writeUrlRange().

    {
        // Network drives are different. We will handle them separately
        // MS/Novell network drives and shares start with \\
        if (preg_match('[^external:\\\\]', $url)) {
            return; //($this->_writeUrlExternal_net($row1, $col1, $row2, $col2, $url, $str, $format));
        }
    
        $record      = 0x01B8;                       // Record identifier
        $length      = 0x00000;                      // Bytes to follow
    
        if (!$format) {
            $format = $this->_url_format;
        }
    
        // Strip URL type and change Unix dir separator to Dos style (if needed)
        //
        $url = preg_replace('/^external:/', '', $url);
        $url = preg_replace('/\//', "\\", $url);
    
        // Write the visible label
        if ($str == '') {
            $str = preg_replace('/\#/', ' - ', $url);
        }
        $str_error = $this->writeString($row1, $col1, $str, $format);
        if (($str_error == -2) or ($str_error == -3)) {
            return $str_error;
        }
    
        // Determine if the link is relative or absolute:
        //   relative if link contains no dir separator, "somefile.xls"
        //   relative if link starts with up-dir, "..\..\somefile.xls"
        //   otherwise, absolute
        
        $absolute    = 0x02; // Bit mask
        if (!preg_match("/\\\/", $url)) {
            $absolute    = 0x00;
        }
        if (preg_match("/^\.\.\\\/", $url)) {
            $absolute    = 0x00;
        }
        $link_type               = 0x01 | $absolute;
    
        // Determine if the link contains a sheet reference and change some of the
        // parameters accordingly.
        // Split the dir name and sheet name (if it exists)
        /*if (preg_match("/\#/", $url)) {
            list($dir_long, $sheet) = split("\#", $url);
        } else {
            $dir_long = $url;
        }
    
        if (isset($sheet)) {
            $link_type |= 0x08;
            $sheet_len  = pack("V", strlen($sheet) + 0x01);
            $sheet      = join("\0", split('', $sheet));
            $sheet     .= "\0\0\0";
        } else {
            $sheet_len   = '';
            $sheet       = '';
        }*/
        $dir_long = $url;
        if (preg_match("/\#/", $url)) {
            $link_type |= 0x08;
        }

Here is the caller graph for this function:

_writeUrlInternal()

Spreadsheet_Excel_Writer_Worksheet::_writeUrlInternal	(		$row1,
			$col1,
			$row2,
			$col2,
			$url,
			$str,
			$format = null
	)

Used to write internal reference hyperlinks such as "Sheet1!A1".

private

See also

writeUrl()

Parameters

integer	$row1	Start row
integer	$col1	Start column
integer	$row2	End row
integer	$col2	End column
string	$url	URL string
string	$str	Alternative label
mixed	$format	The cell format

Returns

integer

Definition at line 1947 of file Worksheet.php.

References $_url_format, $data, $header, $length, $options, $record, $str_error, $unknown1, $url, _append(), and writeString().

Referenced by _writeUrlRange().

    {
        $record      = 0x01B8;                       // Record identifier
        $length      = 0x00000;                      // Bytes to follow

        if (!$format) {
            $format = $this->_url_format;
        }

        // Strip URL type
        $url = preg_replace('/^internal:/', '', $url);

        // Write the visible label
        if ($str == '') {
            $str = $url;
        }
        $str_error = $this->writeString($row1, $col1, $str, $format);
        if (($str_error == -2) || ($str_error == -3)) {
            return $str_error;
        }

        // Pack the undocumented parts of the hyperlink stream
        $unknown1    = pack("H*", "D0C9EA79F9BACE118C8200AA004BA90B02000000");

        // Pack the option flags
        $options     = pack("V", 0x08);

        // Convert the URL type and to a null terminated wchar string
        $url         = join("\0", preg_split("''", $url, -1, PREG_SPLIT_NO_EMPTY));
        $url         = $url . "\0\0\0";

        // Pack the length of the URL as chars (not wchars)
        $url_len     = pack("V", floor(strlen($url)/2));

        // Calculate the data length
        $length      = 0x24 + strlen($url);

        // Pack the header data
        $header      = pack("vv",   $record, $length);
        $data        = pack("vvvv", $row1, $row2, $col1, $col2);

        // Write the packed data
        $this->_append($header . $data .
                       $unknown1 . $options .
                       $url_len . $url);
        return($str_error);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_writeUrlRange()

Spreadsheet_Excel_Writer_Worksheet::_writeUrlRange	(		$row1,
			$col1,
			$row2,
			$col2,
			$url,
			$string = '',
			$format = null
	)

This is the more general form of writeUrl().

It allows a hyperlink to be written to a range of cells. This function also decides the type of hyperlink to be written. These are either, Web (http, ftp, mailto), Internal (Sheet1!A1) or external ('c:.xls::Sheet1!A1').

private

See also

writeUrl()

Parameters

integer	$row1	Start row
integer	$col1	Start column
integer	$row2	End row
integer	$col2	End column
string	$url	URL string
string	$string	Alternative label
mixed	$format	The cell format

Returns

integer

Definition at line 1857 of file Worksheet.php.

References $url, _writeUrlExternal(), _writeUrlInternal(), and _writeUrlWeb().

Referenced by writeUrl().

    {

        // Check for internal/external sheet links or default to web link
        if (preg_match('[^internal:]', $url)) {
            return($this->_writeUrlInternal($row1, $col1, $row2, $col2, $url, $string, $format));
        }
        if (preg_match('[^external:]', $url)) {
            return($this->_writeUrlExternal($row1, $col1, $row2, $col2, $url, $string, $format));
        }
        return($this->_writeUrlWeb($row1, $col1, $row2, $col2, $url, $string, $format));
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_writeUrlWeb()

Spreadsheet_Excel_Writer_Worksheet::_writeUrlWeb	(		$row1,
			$col1,
			$row2,
			$col2,
			$url,
			$str,
			$format = null
	)

Used to write http, ftp and mailto hyperlinks.

The link type ($options) is 0x03 is the same as absolute dir ref without sheet. However it is differentiated by the $unknown2 data stream.

private

See also

writeUrl()

Parameters

integer	$row1	Start row
integer	$col1	Start column
integer	$row2	End row
integer	$col2	End column
string	$url	URL string
string	$str	Alternative label
mixed	$format	The cell format

Returns

integer

Definition at line 1887 of file Worksheet.php.

References $_url_format, $data, $header, $length, $options, $record, $str_error, $unknown1, $unknown2, $url, _append(), and writeString().

Referenced by _writeUrlRange().

    {
        $record      = 0x01B8;                       // Record identifier
        $length      = 0x00000;                      // Bytes to follow

        if (!$format) {
            $format = $this->_url_format;
        }

        // Write the visible label using the writeString() method.
        if ($str == '') {
            $str = $url;
        }
        $str_error = $this->writeString($row1, $col1, $str, $format);
        if (($str_error == -2) || ($str_error == -3)) {
            return $str_error;
        }

        // Pack the undocumented parts of the hyperlink stream
        $unknown1    = pack("H*", "D0C9EA79F9BACE118C8200AA004BA90B02000000");
        $unknown2    = pack("H*", "E0C9EA79F9BACE118C8200AA004BA90B");

        // Pack the option flags
        $options     = pack("V", 0x03);

        // Convert URL to a null terminated wchar string
        $url         = join("\0", preg_split("''", $url, -1, PREG_SPLIT_NO_EMPTY));
        $url         = $url . "\0\0\0";

        // Pack the length of the URL
        $url_len     = pack("V", strlen($url));

        // Calculate the data length
        $length      = 0x34 + strlen($url);

        // Pack the header data
        $header      = pack("vv",   $record, $length);
        $data        = pack("vvvv", $row1, $row2, $col1, $col2);

        // Write the packed data
        $this->_append($header . $data .
                       $unknown1 . $options .
                       $unknown2 . $url_len . $url);
        return($str_error);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_XF()

Spreadsheet_Excel_Writer_Worksheet::_XF

(

&

$format

)

Returns an index to the XF record in the workbook.

private

Parameters

mixed

&$format

The optional XF format

Returns

integer The XF record index

Definition at line 1250 of file Worksheet.php.

Referenced by _storeColinfo(), setRow(), writeBlank(), writeFormula(), writeNumber(), writeString(), and writeStringBIFF8().

    {
        if ($format) {
            return($format->getXfIndex());
        } else {
            return(0x0F);
        }
    }

Here is the caller graph for this function:

activate()

Spreadsheet_Excel_Writer_Worksheet::activate

(

)

Set this worksheet as the active worksheet, i.e.

the worksheet that is displayed when the workbook is opened. Also set it as selected.

public

Definition at line 710 of file Worksheet.php.

References $index.

    {
        $this->selected = 1;
        $this->activesheet = $this->index;
    }

centerHorizontally()

Spreadsheet_Excel_Writer_Worksheet::centerHorizontally

(

$center = 1

)

Center the page horinzontally.

public

Parameters

integer

$center

the optional value for centering. Defaults to 1 (center).

Definition at line 885 of file Worksheet.php.

    {
        $this->_hcenter = $center;
    }

centerVertically()

Spreadsheet_Excel_Writer_Worksheet::centerVertically

(

$center = 1

)

Center the page vertically.

public

Parameters

integer

$center

the optional value for centering. Defaults to 1 (center).

Definition at line 896 of file Worksheet.php.

    {
        $this->_vcenter = $center;
    }

close()

Spreadsheet_Excel_Writer_Worksheet::close

(

$sheetnames

)

Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.

public

See also

Spreadsheet_Excel_Writer_Workbook::storeWorkbook()

Parameters

array

$sheetnames

The array of sheetnames from the Workbook this worksheet belongs to

Definition at line 518 of file Worksheet.php.

References Spreadsheet_Excel_Writer_BIFFwriter\_storeBof(), _storeColinfo(), _storeDefcol(), _storeDimensions(), Spreadsheet_Excel_Writer_BIFFwriter\_storeEof(), _storeExterncount(), _storeExternsheet(), _storeFooter(), _storeGridset(), _storeGuts(), _storeHbreak(), _storeHcenter(), _storeHeader(), _storeMarginBottom(), _storeMarginLeft(), _storeMarginRight(), _storeMarginTop(), _storeMergedCells(), _storePanes(), _storePassword(), _storePrintGridlines(), _storePrintHeaders(), _storeProtect(), _storeSelection(), _storeSetup(), _storeVbreak(), _storeVcenter(), _storeWindow2(), _storeWsbool(), and _storeZoom().

    {
        $num_sheets = count($sheetnames);

        /***********************************************
        * Prepend in reverse order!!
        */

        // Prepend the sheet dimensions
        $this->_storeDimensions();

        // Prepend the sheet password
        $this->_storePassword();

        // Prepend the sheet protection
        $this->_storeProtect();

        // Prepend the page setup
        $this->_storeSetup();

        /* FIXME: margins are actually appended */
        // Prepend the bottom margin
        $this->_storeMarginBottom();

        // Prepend the top margin
        $this->_storeMarginTop();

        // Prepend the right margin
        $this->_storeMarginRight();

        // Prepend the left margin
        $this->_storeMarginLeft();

        // Prepend the page vertical centering
        $this->_storeVcenter();

        // Prepend the page horizontal centering
        $this->_storeHcenter();

        // Prepend the page footer
        $this->_storeFooter();

        // Prepend the page header
        $this->_storeHeader();

        // Prepend the vertical page breaks
        $this->_storeVbreak();

        // Prepend the horizontal page breaks
        $this->_storeHbreak();

        // Prepend WSBOOL
        $this->_storeWsbool();

        // Prepend GRIDSET
        $this->_storeGridset();

         //  Prepend GUTS
        if ($this->_BIFF_version == 0x0500) {
            $this->_storeGuts();
        }

        // Prepend PRINTGRIDLINES
        $this->_storePrintGridlines();

        // Prepend PRINTHEADERS
        $this->_storePrintHeaders();

        // Prepend EXTERNSHEET references
        if ($this->_BIFF_version == 0x0500) {
            for ($i = $num_sheets; $i > 0; $i--) {
                $sheetname = $sheetnames[$i-1];
                $this->_storeExternsheet($sheetname);
            }
        }

        // Prepend the EXTERNCOUNT of external references.
        if ($this->_BIFF_version == 0x0500) {
            $this->_storeExterncount($num_sheets);
        }

        // Prepend the COLINFO records if they exist
        if (!empty($this->_colinfo)) {
            $colcount = count($this->_colinfo);
            for ($i = 0; $i < $colcount; $i++) {
                $this->_storeColinfo($this->_colinfo[$i]);
            }
            $this->_storeDefcol();
        }

        // Prepend the BOF record
        $this->_storeBof(0x0010);

        /*
        * End of prepend. Read upwards from here.
        ***********************************************/

        // Append
        $this->_storeWindow2();
        $this->_storeZoom();
        if (!empty($this->_panes)) {
            $this->_storePanes($this->_panes);
        }
        $this->_storeSelection($this->_selection);
        $this->_storeMergedCells();
        /* TODO: add data validity */
        /*if ($this->_BIFF_version == 0x0600) {
            $this->_storeDataValidity();
        }*/
        $this->_storeEof();
    }

Here is the call graph for this function:

fitToPages()

Spreadsheet_Excel_Writer_Worksheet::fitToPages	(		$width,
			$height
	)

Set the vertical and horizontal number of pages that will define the maximum area printed.

It doesn't seem to work with OpenOffice.

public

Parameters

integer	$width	Maximun width of printed area in pages
integer	$height	Maximun heigth of printed area in pages

See also

setPrintScale()

Definition at line 1075 of file Worksheet.php.

    {
        $this->_fit_page      = 1;
        $this->_fit_width     = $width;
        $this->_fit_height    = $height;
    }

freezePanes()

Spreadsheet_Excel_Writer_Worksheet::freezePanes

(

$panes

)

Set panes and mark them as frozen.

public

Parameters

array

$panes

This is the only parameter received and is composed of the following: 0 => Vertical split position, 1 => Horizontal split position 2 => Top row visible 3 => Leftmost column visible 4 => Active pane

Definition at line 790 of file Worksheet.php.

    {
        $this->_frozen = 1;
        $this->_panes  = $panes;
    }

getData()

Spreadsheet_Excel_Writer_Worksheet::getData

(

)

Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.

Returns

string The data

Definition at line 648 of file Worksheet.php.

References Spreadsheet_Excel_Writer_BIFFwriter\$_data, and $_filehandle.

    {
        $buffer = 4096;

        // Return data stored in memory
        if (isset($this->_data)) {
            $tmp   = $this->_data;
            unset($this->_data);
            $fh    = $this->_filehandle;
            if ($this->_using_tmpfile) {
                fseek($fh, 0);
            }
            return $tmp;
        }
        // Return data stored on disk
        if ($this->_using_tmpfile) {
            if ($tmp = fread($this->_filehandle, $buffer)) {
                return $tmp;
            }
        }

        // No data to return
        return '';
    }

getName()

Spreadsheet_Excel_Writer_Worksheet::getName

(

)

Retrieve the worksheet name.

This is usefull when creating worksheets without a name.

public

Returns

string The worksheet's name

Definition at line 637 of file Worksheet.php.

References $name.

    {
        return $this->name;
    }

hideGridlines()

Spreadsheet_Excel_Writer_Worksheet::hideGridlines

(

)

Set the option to hide gridlines on the printed page.

public

Definition at line 1040 of file Worksheet.php.

    {
        $this->_print_gridlines = 0;
    }

hideScreenGridlines()

Spreadsheet_Excel_Writer_Worksheet::hideScreenGridlines

(

)

Set the option to hide gridlines on the worksheet (as seen on the screen).

public

Definition at line 1050 of file Worksheet.php.

    {
        $this->_screen_gridlines = 0;
    }

insertBitmap()

Spreadsheet_Excel_Writer_Worksheet::insertBitmap	(		$row,
			$col,
			$bitmap,
			$x = 0,
			$y = 0,
			$scale_x = 1,
			$scale_y = 1
	)

Insert a 24bit bitmap image in a worksheet.

public

Parameters

integer	$row	The row we are going to insert the bitmap into
integer	$col	The column we are going to insert the bitmap into
string	$bitmap	The bitmap filename
integer	$x	The horizontal position (offset) of the image inside the cell.
integer	$y	The vertical position (offset) of the image inside the cell.
integer	$scale_x	The horizontal scale
integer	$scale_y	The vertical scale

Definition at line 3114 of file Worksheet.php.

References $data, $header, $length, $record, $row, $size, $x, $y, _append(), _positionImage(), _processBitmap(), PEAR\isError(), and writeString().

    {
        $bitmap_array = $this->_processBitmap($bitmap);
        if ($this->isError($bitmap_array)) {
            $this->writeString($row, $col, $bitmap_array->getMessage());
            return;
        }
        list($width, $height, $size, $data) = $bitmap_array; //$this->_processBitmap($bitmap);

        // Scale the frame of the image.
        $width  *= $scale_x;
        $height *= $scale_y;

        // Calculate the vertices of the image and write the OBJ record
        $this->_positionImage($col, $row, $x, $y, $width, $height);

        // Write the IMDATA record to store the bitmap data
        $record      = 0x007f;
        $length      = 8 + $size;
        $cf          = 0x09;
        $env         = 0x01;
        $lcb         = $size;

        $header      = pack("vvvvV", $record, $length, $cf, $env, $lcb);
        $this->_append($header.$data);
    }

Here is the call graph for this function:

mergeCells()

Spreadsheet_Excel_Writer_Worksheet::mergeCells	(		$first_row,
			$first_col,
			$last_row,
			$last_col
	)

Merges the area given by its arguments.

This is an Excel97/2000 method. It is required to perform more complicated merging than the normal setAlign('merge').

public

Parameters

integer	$first_row	First row of the area to merge
integer	$first_col	First column of the area to merge
integer	$last_row	Last row of the area to merge
integer	$last_col	Last column of the area to merge

Definition at line 2802 of file Worksheet.php.

References $data, $header, $length, $record, and _append().

    {
        $record  = 0x00E5;                   // Record identifier
        $length  = 0x000A;                   // Bytes to follow
        $cref     = 1;                       // Number of refs

        // Swap last row/col for first row/col as necessary
        if ($first_row > $last_row) {
            list($first_row, $last_row) = array($last_row, $first_row);
        }

        if ($first_col > $last_col) {
            list($first_col, $last_col) = array($last_col, $first_col);
        }

        $header   = pack("vv",    $record, $length);
        $data     = pack("vvvvv", $cref, $first_row, $last_row,
                                  $first_col, $last_col);

        $this->_append($header.$data);
    }

Here is the call graph for this function:

printArea()

Spreadsheet_Excel_Writer_Worksheet::printArea	(		$first_row,
			$first_col,
			$last_row,
			$last_col
	)

Set the area of each worksheet that will be printed.

public

Parameters

integer	$first_row	First row of the area to print
integer	$first_col	First column of the area to print
integer	$last_row	Last row of the area to print
integer	$last_col	Last column of the area to print

Definition at line 1026 of file Worksheet.php.

    {
        $this->print_rowmin  = $first_row;
        $this->print_colmin  = $first_col;
        $this->print_rowmax  = $last_row;
        $this->print_colmax  = $last_col;
    }

printRowColHeaders()

Spreadsheet_Excel_Writer_Worksheet::printRowColHeaders

(

$print = 1

)

Set the option to print the row and column headers on the printed page.

public

Parameters

integer

$print

Whether to print the headers or not. Defaults to 1 (print).

Definition at line 1061 of file Worksheet.php.

    {
        $this->_print_headers = $print;
    }

protect()

Spreadsheet_Excel_Writer_Worksheet::protect

(

$password

)

Set the worksheet protection flag to prevent accidental modification and to hide formulas if the locked and hidden format properties have been set.

public

Parameters

string

$password

The password to use for protecting the sheet.

Definition at line 736 of file Worksheet.php.

References _encodePassword().

    {
        $this->_protect   = 1;
        $this->_password  = $this->_encodePassword($password);
    }

Here is the call graph for this function:

repeatColumns()

Spreadsheet_Excel_Writer_Worksheet::repeatColumns	(		$first_col,
			$last_col = null
	)

Set the columns to repeat at the left hand side of each printed page.

public

Parameters

integer	$first_col	First column to repeat
integer	$last_col	Last column to repeat. Optional.

Definition at line 1007 of file Worksheet.php.

    {
        $this->title_colmin  = $first_col;
        if (isset($last_col)) { // Second col is optional
            $this->title_colmax  = $last_col;
        } else {
            $this->title_colmax  = $first_col;
        }
    }

repeatRows()

Spreadsheet_Excel_Writer_Worksheet::repeatRows	(		$first_row,
			$last_row = null
	)

Set the rows to repeat at the top of each printed page.

public

Parameters

integer	$first_row	First row to repeat
integer	$last_row	Last row to repeat. Optional.

Definition at line 990 of file Worksheet.php.

    {
        $this->title_rowmin  = $first_row;
        if (isset($last_row)) { //Second row is optional
            $this->title_rowmax  = $last_row;
        } else {
            $this->title_rowmax  = $first_row;
        }
    }

select()

Spreadsheet_Excel_Writer_Worksheet::select

(

)

Set this worksheet as a selected worksheet, i.e.

the worksheet has its tab highlighted.

public

Definition at line 698 of file Worksheet.php.

    {
        $this->selected = 1;
    }

setColumn()

Spreadsheet_Excel_Writer_Worksheet::setColumn	(		$firstcol,
			$lastcol,
			$width,
			$format = null,
			$hidden = 0,
			$level = 0
	)

Set the width of a single column or a range of columns.

public

Parameters

integer	$firstcol	first column on the range
integer	$lastcol	last column on the range
integer	$width	width to set
mixed	$format	The optional XF format to apply to the columns
integer	$hidden	The optional hidden atribute
integer	$level	The optional outline level

Definition at line 753 of file Worksheet.php.

    {
        $this->_colinfo[] = array($firstcol, $lastcol, $width, &$format, $hidden, $level);

        // Set width to zero if column is hidden
        $width = ($hidden) ? 0 : $width;

        for ($col = $firstcol; $col <= $lastcol; $col++) {
            $this->col_sizes[$col] = $width;
        }
    }

setFirstSheet()

Spreadsheet_Excel_Writer_Worksheet::setFirstSheet

(

)

Set this worksheet as the first visible sheet.

This is necessary when there are a large number of worksheets and the activated worksheet is not visible on the screen.

public

Definition at line 723 of file Worksheet.php.

References $index.

    {
        $this->firstsheet = $this->index;
    }

setFooter()

Spreadsheet_Excel_Writer_Worksheet::setFooter	(		$string,
			$margin = 0.50
	)

Set the page footer caption and optional margin.

public

Parameters

string	$string	The footer text
float	$margin	optional foot margin in inches.

Definition at line 869 of file Worksheet.php.

    {
        if (strlen($string) >= 255) {
            //carp 'Footer string must be less than 255 characters';
            return;
        }
        $this->_footer      = $string;
        $this->_margin_foot = $margin;
    }

setHeader()

Spreadsheet_Excel_Writer_Worksheet::setHeader	(		$string,
			$margin = 0.50
	)

Set the page header caption and optional margin.

public

Parameters

string	$string	The header text
float	$margin	optional head margin in inches.

Definition at line 852 of file Worksheet.php.

    {
        if (strlen($string) >= 255) {
            //carp 'Header string must be less than 255 characters';
            return;
        }
        $this->_header      = $string;
        $this->_margin_head = $margin;
    }

setHPagebreaks()

Spreadsheet_Excel_Writer_Worksheet::setHPagebreaks

(

$breaks

)

Store the horizontal page breaks on a worksheet (for printing).

The breaks represent the row after which the break is inserted.

public

Parameters

array

$breaks

Array containing the horizontal page breaks

Definition at line 1089 of file Worksheet.php.

    {
        foreach ($breaks as $break) {
            array_push($this->_hbreaks, $break);
        }
    }

setInputEncoding()

Spreadsheet_Excel_Writer_Worksheet::setInputEncoding

(

$encoding

)

Sets Input Encoding for writing strings.

public

Parameters

string

$encoding

The encoding. Ex: 'UTF-16LE', 'utf-8', 'ISO-859-7'

Definition at line 1534 of file Worksheet.php.

References PEAR\raiseError().

    {
         if ($encoding != 'UTF-16LE' && !function_exists('iconv')) {
             $this->raiseError("Using an input encoding other than UTF-16LE requires PHP support for iconv");
         }
         $this->_input_encoding = $encoding;
    }

Here is the call graph for this function:

setLandscape()

Spreadsheet_Excel_Writer_Worksheet::setLandscape

(

)

Set the page orientation as landscape.

public

Definition at line 828 of file Worksheet.php.

    {
        $this->_orientation = 0;
    }

setMarginBottom()

Spreadsheet_Excel_Writer_Worksheet::setMarginBottom

(

$margin = 1.00

)

Set the bottom margin in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 978 of file Worksheet.php.

Referenced by setMargins(), and setMargins_TB().

    {
        $this->_margin_bottom = $margin;
    }

Here is the caller graph for this function:

setMarginLeft()

Spreadsheet_Excel_Writer_Worksheet::setMarginLeft

(

$margin = 0.75

)

Set the left margin in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 945 of file Worksheet.php.

Referenced by setMargins(), and setMargins_LR().

    {
        $this->_margin_left = $margin;
    }

Here is the caller graph for this function:

setMarginRight()

Spreadsheet_Excel_Writer_Worksheet::setMarginRight

(

$margin = 0.75

)

Set the right margin in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 956 of file Worksheet.php.

Referenced by setMargins(), and setMargins_LR().

    {
        $this->_margin_right = $margin;
    }

Here is the caller graph for this function:

setMargins()

Spreadsheet_Excel_Writer_Worksheet::setMargins

(

$margin

)

Set all the page margins to the same value in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 907 of file Worksheet.php.

References setMarginBottom(), setMarginLeft(), setMarginRight(), and setMarginTop().

    {
        $this->setMarginLeft($margin);
        $this->setMarginRight($margin);
        $this->setMarginTop($margin);
        $this->setMarginBottom($margin);
    }

Here is the call graph for this function:

setMargins_LR()

Spreadsheet_Excel_Writer_Worksheet::setMargins_LR

(

$margin

)

Set the left and right margins to the same value in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 921 of file Worksheet.php.

References setMarginLeft(), and setMarginRight().

    {
        $this->setMarginLeft($margin);
        $this->setMarginRight($margin);
    }

Here is the call graph for this function:

setMargins_TB()

Spreadsheet_Excel_Writer_Worksheet::setMargins_TB

(

$margin

)

Set the top and bottom margins to the same value in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 933 of file Worksheet.php.

References setMarginBottom(), and setMarginTop().

    {
        $this->setMarginTop($margin);
        $this->setMarginBottom($margin);
    }

Here is the call graph for this function:

setMarginTop()

Spreadsheet_Excel_Writer_Worksheet::setMarginTop

(

$margin = 1.00

)

Set the top margin in inches.

public

Parameters

float

$margin

The margin to set in inches

Definition at line 967 of file Worksheet.php.

Referenced by setMargins(), and setMargins_TB().

    {
        $this->_margin_top = $margin;
    }

Here is the caller graph for this function:

setMerge()

Spreadsheet_Excel_Writer_Worksheet::setMerge	(		$first_row,
			$first_col,
			$last_row,
			$last_col
	)

Sets a merged cell range.

public

Parameters

integer	$first_row	First row of the area to merge
integer	$first_col	First column of the area to merge
integer	$last_row	Last row of the area to merge
integer	$last_col	Last column of the area to merge

Definition at line 682 of file Worksheet.php.

    {
        if (($last_row < $first_row) || ($last_col < $first_col)) {
            return;
        }
        // don't check rowmin, rowmax, etc... because we don't know when this
        // is going to be called
        $this->_merged_ranges[] = array($first_row, $first_col, $last_row, $last_col);
    }

setOutline()

Spreadsheet_Excel_Writer_Worksheet::setOutline	(		$visible = true,
			$symbols_below = true,
			$symbols_right = true,
			$auto_style = false
	)

This method sets the properties for outlining and grouping.

The defaults correspond to Excel's defaults.

Parameters

bool	$visible
bool	$symbols_below
bool	$symbols_right
bool	$auto_style

Definition at line 1395 of file Worksheet.php.

    {
        $this->_outline_on    = $visible;
        $this->_outline_below = $symbols_below;
        $this->_outline_right = $symbols_right;
        $this->_outline_style = $auto_style;

        // Ensure this is a boolean vale for Window2
        if ($this->_outline_on) {
            $this->_outline_on = 1;
        }
     }

setPaper()

Spreadsheet_Excel_Writer_Worksheet::setPaper

(

$size = 0

)

Set the paper type.

Ex. 1 = US Letter, 9 = A4

public

Parameters

integer

$size

The type of paper size to use

Definition at line 839 of file Worksheet.php.

References $size.

    {
        $this->_paper_size = $size;
    }

setPortrait()

Spreadsheet_Excel_Writer_Worksheet::setPortrait

(

)

Set the page orientation as portrait.

public

Definition at line 818 of file Worksheet.php.

    {
        $this->_orientation = 1;
    }

setPrintScale()

Spreadsheet_Excel_Writer_Worksheet::setPrintScale

(

$scale = 100

)

Set the scale factor for the printed page.

It turns off the "fit to page" option

public

Parameters

integer

$scale

The optional scale factor. Defaults to 100

Definition at line 1135 of file Worksheet.php.

References PEAR\raiseError().

    {
        // Confine the scale to Excel's range
        if ($scale < 10 || $scale > 400) {
            $this->raiseError("Print scale $scale outside range: 10 <= zoom <= 400");
            $scale = 100;
        }

        // Turn off "fit to page" option
        $this->_fit_page = 0;

        $this->_print_scale = floor($scale);
    }

Here is the call graph for this function:

setRow()

Spreadsheet_Excel_Writer_Worksheet::setRow	(		$row,
			$height,
			$format = null,
			$hidden = false,
			$level = 0
	)

This method is used to set the height and format for a row.

public

Parameters

integer	$row	The row to set
integer	$height	Height we are giving to the row. Use null to set XF without setting height
mixed	$format	XF format we are giving to the row
bool	$hidden	The optional hidden attribute
integer	$level	The optional outline level for row, in range [0,7]

Definition at line 2143 of file Worksheet.php.

References $data, $header, $length, $record, $row, _append(), and _XF().

    {
        $record      = 0x0208;               // Record identifier
        $length      = 0x0010;               // Number of bytes to follow

        $colMic      = 0x0000;               // First defined column
        $colMac      = 0x0000;               // Last defined column
        $irwMac      = 0x0000;               // Used by Excel to optimise loading
        $reserved    = 0x0000;               // Reserved
        $grbit       = 0x0000;               // Option flags
        $ixfe        = $this->_XF($format);  // XF index

        // set _row_sizes so _sizeRow() can use it
        $this->_row_sizes[$row] = $height;

        // Use setRow($row, null, $XF) to set XF format without setting height
        if ($height != null) {
            $miyRw = $height * 20;  // row height
        } else {
            $miyRw = 0xff;          // default row height is 256
        }

        $level = max(0, min($level, 7));  // level should be between 0 and 7
        $this->_outline_row_level = max($level, $this->_outline_row_level);


        // Set the options flags. fUnsynced is used to show that the font and row
        // heights are not compatible. This is usually the case for WriteExcel.
        // The collapsed flag 0x10 doesn't seem to be used to indicate that a row
        // is collapsed. Instead it is used to indicate that the previous row is
        // collapsed. The zero height flag, 0x20, is used to collapse a row.

        $grbit |= $level;
        if ($hidden) {
            $grbit |= 0x0020;
        }
        $grbit |= 0x0040; // fUnsynced
        if ($format) {
            $grbit |= 0x0080;
        }
        $grbit |= 0x0100;

        $header   = pack("vv",       $record, $length);
        $data     = pack("vvvvvvvv", $row, $colMic, $colMac, $miyRw,
                                     $irwMac,$reserved, $grbit, $ixfe);
        $this->_append($header.$data);
    }

Here is the call graph for this function:

setSelection()

Spreadsheet_Excel_Writer_Worksheet::setSelection	(		$first_row,
			$first_column,
			$last_row,
			$last_column
	)

Set which cell or cells are selected in a worksheet.

public

Parameters

integer	$first_row	first row in the selected quadrant
integer	$first_column	first column in the selected quadrant
integer	$last_row	last row in the selected quadrant
integer	$last_column	last column in the selected quadrant

Definition at line 774 of file Worksheet.php.

    {
        $this->_selection = array($first_row,$first_column,$last_row,$last_column);
    }

setValidation()

Spreadsheet_Excel_Writer_Worksheet::setValidation	(		$row1,
			$col1,
			$row2,
			$col2,
		&	$validator
	)

FIXME: add comments.

Definition at line 3487 of file Worksheet.php.

    {
        $this->_dv[] = $validator->_getData() .
                       pack("vvvvv", 1, $row1, $row2, $col1, $col2);
    }

setVPagebreaks()

Spreadsheet_Excel_Writer_Worksheet::setVPagebreaks

(

$breaks

)

Store the vertical page breaks on a worksheet (for printing).

The breaks represent the column after which the break is inserted.

public

Parameters

array

$breaks

Array containing the vertical page breaks

Definition at line 1103 of file Worksheet.php.

    {
        foreach ($breaks as $break) {
            array_push($this->_vbreaks, $break);
        }
    }

setZoom()

Spreadsheet_Excel_Writer_Worksheet::setZoom

(

$scale = 100

)

Set the worksheet zoom factor.

public

Parameters

integer

$scale

The zoom factor

Definition at line 1117 of file Worksheet.php.

References PEAR\raiseError().

    {
        // Confine the scale to Excel's range
        if ($scale < 10 || $scale > 400) {
            $this->raiseError("Zoom factor $scale outside range: 10 <= zoom <= 400");
            $scale = 100;
        }

        $this->_zoom = floor($scale);
    }

Here is the call graph for this function:

Spreadsheet_Excel_Writer_Worksheet()

Spreadsheet_Excel_Writer_Worksheet::Spreadsheet_Excel_Writer_Worksheet	(		$BIFF_version,
			$name,
			$index,
		&	$activesheet,
		&	$firstsheet,
		&	$str_total,
		&	$str_unique,
		&	$str_table,
		&	$url_format,
		&	$parser,
			$tmp_dir
	)

Constructor.

Parameters

string	$name	The name of the new worksheet
integer	$index	The index of the new worksheet
mixed	&$activesheet	The current activesheet of the workbook we belong to
mixed	&$firstsheet	The first worksheet in the workbook we belong to
mixed	&$url_format	The default format for hyperlinks
mixed	&$parser	The formula parser created for the Workbook
string	$tmp_dir	The path to the directory for temporary files private

Definition at line 370 of file Worksheet.php.

References $index, $name, _initialize(), and Spreadsheet_Excel_Writer_BIFFwriter\Spreadsheet_Excel_Writer_BIFFwriter().

    {
        // It needs to call its parent's constructor explicitly
        $this->Spreadsheet_Excel_Writer_BIFFwriter();
        $this->_BIFF_version   = $BIFF_version;
        $rowmax                = 65536; // 16384 in Excel 5
        $colmax                = 256;

        $this->name            = $name;
        $this->index           = $index;
        $this->activesheet     = &$activesheet;
        $this->firstsheet      = &$firstsheet;
        $this->_str_total      = &$str_total;
        $this->_str_unique     = &$str_unique;
        $this->_str_table      = &$str_table;
        $this->_url_format     = &$url_format;
        $this->_parser         = &$parser;

        //$this->ext_sheets      = array();
        $this->_filehandle     = '';
        $this->_using_tmpfile  = true;
        //$this->fileclosed      = 0;
        //$this->offset          = 0;
        $this->_xls_rowmax     = $rowmax;
        $this->_xls_colmax     = $colmax;
        $this->_xls_strmax     = 255;
        $this->_dim_rowmin     = $rowmax + 1;
        $this->_dim_rowmax     = 0;
        $this->_dim_colmin     = $colmax + 1;
        $this->_dim_colmax     = 0;
        $this->_colinfo        = array();
        $this->_selection      = array(0,0,0,0);
        $this->_panes          = array();
        $this->_active_pane    = 3;
        $this->_frozen         = 0;
        $this->selected        = 0;

        $this->_paper_size      = 0x0;
        $this->_orientation     = 0x1;
        $this->_header          = '';
        $this->_footer          = '';
        $this->_hcenter         = 0;
        $this->_vcenter         = 0;
        $this->_margin_head     = 0.50;
        $this->_margin_foot     = 0.50;
        $this->_margin_left     = 0.75;
        $this->_margin_right    = 0.75;
        $this->_margin_top      = 1.00;
        $this->_margin_bottom   = 1.00;

        $this->title_rowmin     = null;
        $this->title_rowmax     = null;
        $this->title_colmin     = null;
        $this->title_colmax     = null;
        $this->print_rowmin     = null;
        $this->print_rowmax     = null;
        $this->print_colmin     = null;
        $this->print_colmax     = null;

        $this->_print_gridlines  = 1;
        $this->_screen_gridlines = 1;
        $this->_print_headers    = 0;

        $this->_fit_page        = 0;
        $this->_fit_width       = 0;
        $this->_fit_height      = 0;

        $this->_hbreaks         = array();
        $this->_vbreaks         = array();

        $this->_protect         = 0;
        $this->_password        = null;

        $this->col_sizes        = array();
        $this->_row_sizes        = array();

        $this->_zoom            = 100;
        $this->_print_scale     = 100;

        $this->_outline_row_level = 0;
        $this->_outline_style     = 0;
        $this->_outline_below     = 1;
        $this->_outline_right     = 1;
        $this->_outline_on        = 1;

        $this->_merged_ranges     = array();

        $this->_input_encoding    = '';

        $this->_dv                = array();
        
        $this->_tmp_dir = $tmp_dir;

        $this->_initialize();
    }

Here is the call graph for this function:

thawPanes()

Spreadsheet_Excel_Writer_Worksheet::thawPanes

(

$panes

)

Set panes and mark them as unfrozen.

public

Parameters

array

$panes

This is the only parameter received and is composed of the following: 0 => Vertical split position, 1 => Horizontal split position 2 => Top row visible 3 => Leftmost column visible 4 => Active pane

Definition at line 807 of file Worksheet.php.

    {
        $this->_frozen = 0;
        $this->_panes  = $panes;
    }

write()

Spreadsheet_Excel_Writer_Worksheet::write	(		$row,
			$col,
			$token,
			$format = null
	)

Map to the appropriate write method acording to the token recieved.

public

Parameters

integer	$row	The row of the cell we are writing to
integer	$col	The column of the cell we are writing to
mixed	$token	What we are writing
mixed	$format	The optional format to apply to the cell

Definition at line 1158 of file Worksheet.php.

References $row, writeBlank(), writeFormula(), writeNumber(), writeString(), and writeUrl().

Referenced by writeCol(), and writeRow().

    {
        // Check for a cell reference in A1 notation and substitute row and column
        /*if ($_[0] =~ /^\D/) {
            @_ = $this->_substituteCellref(@_);
    }*/

        if (preg_match("/^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/", $token)) {
            // Match number
            return $this->writeNumber($row, $col, $token, $format);
        } elseif (preg_match("/^[fh]tt?p:\/\//", $token)) {
            // Match http or ftp URL
            return $this->writeUrl($row, $col, $token, '', $format);
        } elseif (preg_match("/^mailto:/", $token)) {
            // Match mailto:
            return $this->writeUrl($row, $col, $token, '', $format);
        } elseif (preg_match("/^(?:in|ex)ternal:/", $token)) {
            // Match internal or external sheet link
            return $this->writeUrl($row, $col, $token, '', $format);
        } elseif (preg_match("/^=/", $token)) {
            // Match formula
            return $this->writeFormula($row, $col, $token, $format);
        } elseif ($token == '') {
            // Match blank
            return $this->writeBlank($row, $col, $format);
        } else {
            // Default: match string
            return $this->writeString($row, $col, $token, $format);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeBlank()

Spreadsheet_Excel_Writer_Worksheet::writeBlank	(		$row,
			$col,
			$format
	)

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.

Returns 0 : normal termination (including no format) -1 : insufficient number of arguments -2 : row or column out of range

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
mixed	$format	The XF format

Definition at line 1702 of file Worksheet.php.

References $data, $header, $length, $record, $row, _append(), and _XF().

Referenced by write().

    {
        // Don't write a blank cell unless it has a format
        if (!$format) {
            return(0);
        }

        $record    = 0x0201;                 // Record identifier
        $length    = 0x0006;                 // Number of bytes to follow
        $xf        = $this->_XF($format);    // The cell format

        // Check that row and col are valid and store max and min values
        if ($row >= $this->_xls_rowmax) {
            return(-2);
        }
        if ($col >= $this->_xls_colmax) {
            return(-2);
        }
        if ($row <  $this->_dim_rowmin) {
            $this->_dim_rowmin = $row;
        }
        if ($row >  $this->_dim_rowmax) {
            $this->_dim_rowmax = $row;
        }
        if ($col <  $this->_dim_colmin) {
            $this->_dim_colmin = $col;
        }
        if ($col >  $this->_dim_colmax) {
            $this->_dim_colmax = $col;
        }

        $header    = pack("vv",  $record, $length);
        $data      = pack("vvv", $row, $col, $xf);
        $this->_append($header . $data);
        return 0;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeCol()

Spreadsheet_Excel_Writer_Worksheet::writeCol	(		$row,
			$col,
			$val,
			$format = null
	)

Write an array of values as a column.

public

Parameters

integer	$row	The first row (uppermost row) we are writing to
integer	$col	The col we are writing to
array	$val	The array of values to write
mixed	$format	The optional format to apply to the cell

Returns

mixed PEAR_Error on failure

Definition at line 1229 of file Worksheet.php.

References $row, and write().

Referenced by writeRow().

    {
        $retval = '';
        if (is_array($val)) {
            foreach ($val as $v) {
                $this->write($row, $col, $v, $format);
                $row++;
            }
        } else {
            $retval = new PEAR_Error('$val needs to be an array');
        }
        return($retval);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeFormula()

Spreadsheet_Excel_Writer_Worksheet::writeFormula	(		$row,
			$col,
			$formula,
			$format = null
	)

Write a formula to the specified row and column (zero indexed).

The textual representation of the formula is passed to the parser in Parser.php which returns a packed binary string.

Returns 0 : normal termination -1 : formula errors (bad formula) -2 : row or column out of range

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$formula	The formula text string
mixed	$format	The optional XF format

Returns

integer

Definition at line 1755 of file Worksheet.php.

References $data, $header, $length, $record, $row, _append(), _checkRowCol(), _XF(), PEAR\isError(), and writeString().

Referenced by write().

    {
        $record    = 0x0006;     // Record identifier

        // Excel normally stores the last calculated value of the formula in $num.
        // Clearly we are not in a position to calculate this a priori. Instead
        // we set $num to zero and set the option flags in $grbit to ensure
        // automatic calculation of the formula when the file is opened.
        //
        $xf        = $this->_XF($format); // The cell format
        $num       = 0x00;                // Current value of formula
        $grbit     = 0x03;                // Option flags
        $unknown   = 0x0000;              // Must be zero


        // Check that row and col are valid and store max and min values
        if ($this->_checkRowCol($row, $col) == false) {
            return -2;
        }

        // Strip the '=' or '@' sign at the beginning of the formula string
        if (preg_match("/^=/", $formula)) {
            $formula = preg_replace("/(^=)/", "", $formula);
        } elseif (preg_match("/^@/", $formula)) {
            $formula = preg_replace("/(^@)/", "", $formula);
        } else {
            // Error handling
            $this->writeString($row, $col, 'Unrecognised character for formula');
            return -1;
        }

        // Parse the formula using the parser in Parser.php
        $error = $this->_parser->parse($formula);
        if ($this->isError($error)) {
            $this->writeString($row, $col, $error->getMessage());
            return -1;
        }

        $formula = $this->_parser->toReversePolish();
        if ($this->isError($formula)) {
            $this->writeString($row, $col, $formula->getMessage());
            return -1;
        }

        $formlen    = strlen($formula);    // Length of the binary string
        $length     = 0x16 + $formlen;     // Length of the record data

        $header    = pack("vv",      $record, $length);
        $data      = pack("vvvdvVv", $row, $col, $xf, $num,
                                     $grbit, $unknown, $formlen);

        $this->_append($header . $data . $formula);
        return 0;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeNote()

Spreadsheet_Excel_Writer_Worksheet::writeNote	(		$row,
			$col,
			$note
	)

Writes a note associated with the cell given by the row and column.

NOTE records don't have a length limit.

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$note	The note to write

Definition at line 1642 of file Worksheet.php.

References $data, $header, $length, $record, $row, and _append().

    {
        $note_length    = strlen($note);
        $record         = 0x001C;                // Record identifier
        $max_length     = 2048;                  // Maximun length for a NOTE record
        //$length      = 0x0006 + $note_length;    // Bytes to follow

        // Check that row and col are valid and store max and min values
        if ($row >= $this->_xls_rowmax) {
            return(-2);
        }
        if ($col >= $this->_xls_colmax) {
            return(-2);
        }
        if ($row <  $this->_dim_rowmin) {
            $this->_dim_rowmin = $row;
        }
        if ($row >  $this->_dim_rowmax) {
            $this->_dim_rowmax = $row;
        }
        if ($col <  $this->_dim_colmin) {
            $this->_dim_colmin = $col;
        }
        if ($col >  $this->_dim_colmax) {
            $this->_dim_colmax = $col;
        }

        // Length for this record is no more than 2048 + 6
        $length    = 0x0006 + min($note_length, 2048);
        $header    = pack("vv",   $record, $length);
        $data      = pack("vvv", $row, $col, $note_length);
        $this->_append($header . $data . substr($note, 0, 2048));

        for ($i = $max_length; $i < $note_length; $i += $max_length) {
            $chunk  = substr($note, $i, $max_length);
            $length = 0x0006 + strlen($chunk);
            $header = pack("vv",   $record, $length);
            $data   = pack("vvv", -1, 0, strlen($chunk));
            $this->_append($header.$data.$chunk);
        }
        return(0);
    }

Here is the call graph for this function:

writeNumber()

Spreadsheet_Excel_Writer_Worksheet::writeNumber	(		$row,
			$col,
			$num,
			$format = null
	)

Write a double to the specified row and column (zero indexed).

An integer can be written as a double. Excel will display an integer. $format is optional.

Returns 0 : normal termination -2 : row or column out of range

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
float	$num	The number to write
mixed	$format	The optional XF format

Returns

integer

Definition at line 1430 of file Worksheet.php.

References $data, $header, $length, $record, $row, _append(), and _XF().

Referenced by write().

    {
        $record    = 0x0203;                 // Record identifier
        $length    = 0x000E;                 // Number of bytes to follow

        $xf        = $this->_XF($format);    // The cell format

        // Check that row and col are valid and store max and min values
        if ($row >= $this->_xls_rowmax) {
            return(-2);
        }
        if ($col >= $this->_xls_colmax) {
            return(-2);
        }
        if ($row <  $this->_dim_rowmin)  {
            $this->_dim_rowmin = $row;
        }
        if ($row >  $this->_dim_rowmax)  {
            $this->_dim_rowmax = $row;
        }
        if ($col <  $this->_dim_colmin)  {
            $this->_dim_colmin = $col;
        }
        if ($col >  $this->_dim_colmax)  {
            $this->_dim_colmax = $col;
        }

        $header    = pack("vv",  $record, $length);
        $data      = pack("vvv", $row, $col, $xf);
        $xl_double = pack("d",   $num);
        if ($this->_byte_order) { // if it's Big Endian
            $xl_double = strrev($xl_double);
        }

        $this->_append($header.$data.$xl_double);
        return(0);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeRow()

Spreadsheet_Excel_Writer_Worksheet::writeRow	(		$row,
			$col,
			$val,
			$format = null
	)

Write an array of values as a row.

public

Parameters

integer	$row	The row we are writing to
integer	$col	The first col (leftmost col) we are writing to
array	$val	The array of values to write
mixed	$format	The optional format to apply to the cell

Returns

mixed PEAR_Error on failure

Definition at line 1200 of file Worksheet.php.

References $row, write(), and writeCol().

    {
        $retval = '';
        if (is_array($val)) {
            foreach ($val as $v) {
                if (is_array($v)) {
                    $this->writeCol($row, $col, $v, $format);
                } else {
                    $this->write($row, $col, $v, $format);
                }
                $col++;
            }
        } else {
            $retval = new PEAR_Error('$val needs to be an array');
        }
        return($retval);
    }

Here is the call graph for this function:

writeString()

Spreadsheet_Excel_Writer_Worksheet::writeString	(		$row,
			$col,
			$str,
			$format = null
	)

Write a string to the specified row and column (zero indexed).

NOTE: there is an Excel 5 defined limit of 255 characters. $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$str	The string to write
mixed	$format	The XF format for the cell

Returns

integer

Definition at line 1483 of file Worksheet.php.

References $_xls_strmax, $data, $header, $length, $record, $row, $str_error, _append(), _XF(), and writeStringBIFF8().

Referenced by _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), write(), and writeFormula().

    {
        if ($this->_BIFF_version == 0x0600) {
            return $this->writeStringBIFF8($row, $col, $str, $format);
        }
        $strlen    = strlen($str);
        $record    = 0x0204;                   // Record identifier
        $length    = 0x0008 + $strlen;         // Bytes to follow
        $xf        = $this->_XF($format);      // The cell format

        $str_error = 0;

        // Check that row and col are valid and store max and min values
        if ($row >= $this->_xls_rowmax) {
            return(-2);
        }
        if ($col >= $this->_xls_colmax) {
            return(-2);
        }
        if ($row <  $this->_dim_rowmin) {
            $this->_dim_rowmin = $row;
        }
        if ($row >  $this->_dim_rowmax) {
            $this->_dim_rowmax = $row;
        }
        if ($col <  $this->_dim_colmin) {
            $this->_dim_colmin = $col;
        }
        if ($col >  $this->_dim_colmax) {
            $this->_dim_colmax = $col;
        }

        if ($strlen > $this->_xls_strmax) { // LABEL must be < 255 chars
            $str       = substr($str, 0, $this->_xls_strmax);
            $length    = 0x0008 + $this->_xls_strmax;
            $strlen    = $this->_xls_strmax;
            $str_error = -3;
        }

        $header    = pack("vv",   $record, $length);
        $data      = pack("vvvv", $row, $col, $xf, $strlen);
        $this->_append($header . $data . $str);
        return($str_error);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeStringBIFF8()

Spreadsheet_Excel_Writer_Worksheet::writeStringBIFF8	(		$row,
			$col,
			$str,
			$format = null
	)

Write a string to the specified row and column (zero indexed).

This is the BIFF8 version (no 255 chars limit). $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars

public

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$str	The string to write
mixed	$format	The XF format for the cell

Returns

integer

Definition at line 1557 of file Worksheet.php.

References $data, $header, $length, $record, $row, $str_error, _append(), _checkRowCol(), and _XF().

Referenced by writeString().

    {
        if ($this->_input_encoding == 'UTF-16LE')
        {
            $strlen = function_exists('mb_strlen') ? mb_strlen($str, 'UTF-16LE') : (strlen($str) / 2);
            $encoding  = 0x1;
        }
        elseif ($this->_input_encoding != '')
        {
            $str = iconv($this->_input_encoding, 'UTF-16LE', $str);
            $strlen = function_exists('mb_strlen') ? mb_strlen($str, 'UTF-16LE') : (strlen($str) / 2);
            $encoding  = 0x1;
        }
        else
        {
            $strlen    = strlen($str);
            $encoding  = 0x0;
        }
        $record    = 0x00FD;                   // Record identifier
        $length    = 0x000A;                   // Bytes to follow
        $xf        = $this->_XF($format);      // The cell format

        $str_error = 0;

        // Check that row and col are valid and store max and min values
        if ($this->_checkRowCol($row, $col) == false) {
            return -2;
        }

        $str = pack('vC', $strlen, $encoding).$str;

        /* check if string is already present */
        if (!isset($this->_str_table[$str])) {
            $this->_str_table[$str] = $this->_str_unique++;
        }
        $this->_str_total++;

        $header    = pack('vv',   $record, $length);
        $data      = pack('vvvV', $row, $col, $xf, $this->_str_table[$str]);
        $this->_append($header.$data);
        return $str_error;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeUrl()

Spreadsheet_Excel_Writer_Worksheet::writeUrl	(		$row,
			$col,
			$url,
			$string = '',
			$format = null
	)

Write a hyperlink.

This is comprised of two elements: the visible label and the invisible link. The visible label is the same as the link unless an alternative string is specified. The label is written using the writeString() method. Therefore the 255 characters string limit applies. $string and $format are optional.

The hyperlink can be to a http, ftp, mail, internal sheet (not yet), or external directory url.

Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars

public

Parameters

integer	$row	Row
integer	$col	Column
string	$url	URL string
string	$string	Alternative label
mixed	$format	The cell format

Returns

integer

Definition at line 1833 of file Worksheet.php.

References $row, $url, and _writeUrlRange().

Referenced by write().

    {
        // Add start row and col to arg list
        return($this->_writeUrlRange($row, $col, $row, $col, $url, $string, $format));
    }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

$_active_pane

Spreadsheet_Excel_Writer_Worksheet::$_active_pane

Definition at line 152 of file Worksheet.php.

Referenced by _storeSelection().

$_colinfo

Spreadsheet_Excel_Writer_Worksheet::$_colinfo

Definition at line 134 of file Worksheet.php.

$_dim_colmax

Spreadsheet_Excel_Writer_Worksheet::$_dim_colmax

Definition at line 128 of file Worksheet.php.

$_dim_colmin

Spreadsheet_Excel_Writer_Worksheet::$_dim_colmin

Definition at line 121 of file Worksheet.php.

Referenced by _storeDimensions().

$_dim_rowmax

Spreadsheet_Excel_Writer_Worksheet::$_dim_rowmax

Definition at line 114 of file Worksheet.php.

$_dim_rowmin

Spreadsheet_Excel_Writer_Worksheet::$_dim_rowmin

Definition at line 107 of file Worksheet.php.

Referenced by _storeDimensions().

$_filehandle

Spreadsheet_Excel_Writer_Worksheet::$_filehandle

Definition at line 76 of file Worksheet.php.

Referenced by getData().

$_fit_height

Spreadsheet_Excel_Writer_Worksheet::$_fit_height

Definition at line 326 of file Worksheet.php.

Referenced by _storeSetup().

$_fit_page

Spreadsheet_Excel_Writer_Worksheet::$_fit_page

Definition at line 314 of file Worksheet.php.

$_fit_width

Spreadsheet_Excel_Writer_Worksheet::$_fit_width

Definition at line 320 of file Worksheet.php.

Referenced by _storeSetup().

$_footer

Spreadsheet_Excel_Writer_Worksheet::$_footer

Definition at line 188 of file Worksheet.php.

Referenced by _storeFooter().

$_frozen

Spreadsheet_Excel_Writer_Worksheet::$_frozen

Definition at line 158 of file Worksheet.php.

Referenced by _storeWindow2().

$_hcenter

Spreadsheet_Excel_Writer_Worksheet::$_hcenter

Definition at line 194 of file Worksheet.php.

Referenced by _storeHcenter().

$_header

Spreadsheet_Excel_Writer_Worksheet::$_header

Definition at line 182 of file Worksheet.php.

Referenced by _storeHeader().

$_input_encoding

Spreadsheet_Excel_Writer_Worksheet::$_input_encoding

Definition at line 356 of file Worksheet.php.

$_margin_bottom

Spreadsheet_Excel_Writer_Worksheet::$_margin_bottom

Definition at line 236 of file Worksheet.php.

Referenced by _storeMarginBottom().

$_margin_foot

Spreadsheet_Excel_Writer_Worksheet::$_margin_foot

Definition at line 212 of file Worksheet.php.

Referenced by _storeSetup().

$_margin_head

Spreadsheet_Excel_Writer_Worksheet::$_margin_head

Definition at line 206 of file Worksheet.php.

Referenced by _storeSetup().

$_margin_left

Spreadsheet_Excel_Writer_Worksheet::$_margin_left

Definition at line 218 of file Worksheet.php.

Referenced by _storeMarginLeft().

$_margin_right

Spreadsheet_Excel_Writer_Worksheet::$_margin_right

Definition at line 224 of file Worksheet.php.

Referenced by _storeMarginRight().

$_margin_top

Spreadsheet_Excel_Writer_Worksheet::$_margin_top

Definition at line 230 of file Worksheet.php.

Referenced by _storeMarginTop().

$_merged_ranges

Spreadsheet_Excel_Writer_Worksheet::$_merged_ranges

Definition at line 350 of file Worksheet.php.

$_orientation

Spreadsheet_Excel_Writer_Worksheet::$_orientation

Definition at line 176 of file Worksheet.php.

Referenced by _storeSetup().

$_outline_below

Spreadsheet_Excel_Writer_Worksheet::$_outline_below

Definition at line 296 of file Worksheet.php.

$_outline_on

Spreadsheet_Excel_Writer_Worksheet::$_outline_on

Definition at line 284 of file Worksheet.php.

Referenced by _storeWindow2().

$_outline_right

Spreadsheet_Excel_Writer_Worksheet::$_outline_right

Definition at line 302 of file Worksheet.php.

$_outline_row_level

Spreadsheet_Excel_Writer_Worksheet::$_outline_row_level

Definition at line 308 of file Worksheet.php.

Referenced by _storeGuts().

$_outline_style

Spreadsheet_Excel_Writer_Worksheet::$_outline_style

Definition at line 290 of file Worksheet.php.

$_panes

Spreadsheet_Excel_Writer_Worksheet::$_panes

Definition at line 146 of file Worksheet.php.

$_paper_size

Spreadsheet_Excel_Writer_Worksheet::$_paper_size

Definition at line 170 of file Worksheet.php.

Referenced by _storeSetup().

$_parser

Spreadsheet_Excel_Writer_Worksheet::$_parser

Definition at line 70 of file Worksheet.php.

$_selection

Spreadsheet_Excel_Writer_Worksheet::$_selection

Definition at line 140 of file Worksheet.php.

$_str_table

Spreadsheet_Excel_Writer_Worksheet::$_str_table

Definition at line 344 of file Worksheet.php.

$_str_total

Spreadsheet_Excel_Writer_Worksheet::$_str_total

Definition at line 332 of file Worksheet.php.

$_str_unique

Spreadsheet_Excel_Writer_Worksheet::$_str_unique

Definition at line 338 of file Worksheet.php.

$_url_format

Spreadsheet_Excel_Writer_Worksheet::$_url_format

Definition at line 64 of file Worksheet.php.

Referenced by _writeUrlInternal(), and _writeUrlWeb().

$_using_tmpfile

Spreadsheet_Excel_Writer_Worksheet::$_using_tmpfile

Definition at line 82 of file Worksheet.php.

$_vcenter

Spreadsheet_Excel_Writer_Worksheet::$_vcenter

Definition at line 200 of file Worksheet.php.

Referenced by _storeVcenter().

$_xls_colmax

Spreadsheet_Excel_Writer_Worksheet::$_xls_colmax

Definition at line 94 of file Worksheet.php.

$_xls_rowmax

Spreadsheet_Excel_Writer_Worksheet::$_xls_rowmax

Definition at line 88 of file Worksheet.php.

$_xls_strmax

Spreadsheet_Excel_Writer_Worksheet::$_xls_strmax

Definition at line 100 of file Worksheet.php.

Referenced by writeString().

$absolute

if (( $str_error==-2) or( $str_error==-3)) Spreadsheet_Excel_Writer_Worksheet::$absolute = 0x02

Definition at line 2047 of file Worksheet.php.

$data

Spreadsheet_Excel_Writer_Worksheet::$data

Initial value:

= pack("vvvv", $row1, $row2, $col1, $col2) .
                          $unknown1     .
                          $link_type    .
                          $unknown2     .
                          $up_count     .
                          $dir_short_len.
                          $dir_short    .
                          $unknown3     .
                          $stream_len

Definition at line 2107 of file Worksheet.php.

Referenced by _append(), _processBitmap(), _storeColinfo(), _storeDataValidity(), _storeDefcol(), _storeDimensions(), _storeExterncount(), _storeExternsheet(), _storeFooter(), _storeGridset(), _storeGuts(), _storeHbreak(), _storeHcenter(), _storeHeader(), _storeMarginBottom(), _storeMarginLeft(), _storeMarginRight(), _storeMarginTop(), _storeMergedCells(), _storeObjPicture(), _storePanes(), _storePassword(), _storePrintGridlines(), _storePrintHeaders(), _storeProtect(), _storeSelection(), _storeVbreak(), _storeVcenter(), _storeWindow2(), _storeWsbool(), _storeZoom(), _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), mergeCells(), setRow(), writeBlank(), writeFormula(), writeNote(), writeNumber(), writeString(), and writeStringBIFF8().

$dir_long

Spreadsheet_Excel_Writer_Worksheet::$dir_long = $url

Definition at line 2074 of file Worksheet.php.

$dir_long_len

Spreadsheet_Excel_Writer_Worksheet::$dir_long_len = pack("V", strlen($dir_long) )

Definition at line 2097 of file Worksheet.php.

$dir_short

Spreadsheet_Excel_Writer_Worksheet::$dir_short = preg_replace("/\.\.\\\/", '', $dir_long) . "\0"

Definition at line 2089 of file Worksheet.php.

$dir_short_len

Spreadsheet_Excel_Writer_Worksheet::$dir_short_len = pack("V", strlen($dir_short) )

Definition at line 2096 of file Worksheet.php.

$header

Spreadsheet_Excel_Writer_Worksheet::$header = pack("vv", $record, $length)

Definition at line 2124 of file Worksheet.php.

Referenced by _processBitmap(), _storeColinfo(), _storeDataValidity(), _storeDefcol(), _storeDimensions(), _storeExterncount(), _storeExternsheet(), _storeFooter(), _storeGridset(), _storeGuts(), _storeHbreak(), _storeHcenter(), _storeHeader(), _storeMarginBottom(), _storeMarginLeft(), _storeMarginRight(), _storeMarginTop(), _storeMergedCells(), _storeObjPicture(), _storePanes(), _storePassword(), _storePrintGridlines(), _storePrintHeaders(), _storeProtect(), _storeSelection(), _storeSetup(), _storeVbreak(), _storeVcenter(), _storeWindow2(), _storeWsbool(), _storeZoom(), _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), mergeCells(), setRow(), writeBlank(), writeFormula(), writeNote(), writeNumber(), writeString(), and writeStringBIFF8().

$index

Spreadsheet_Excel_Writer_Worksheet::$index

Definition at line 58 of file Worksheet.php.

Referenced by activate(), setFirstSheet(), and Spreadsheet_Excel_Writer_Worksheet().

$length

Spreadsheet_Excel_Writer_Worksheet::$length = 0x00000

Definition at line 2022 of file Worksheet.php.

Referenced by _storeColinfo(), _storeDataValidity(), _storeDefcol(), _storeDimensions(), _storeExterncount(), _storeExternsheet(), _storeFooter(), _storeGridset(), _storeGuts(), _storeHbreak(), _storeHcenter(), _storeHeader(), _storeMarginBottom(), _storeMarginLeft(), _storeMarginRight(), _storeMarginTop(), _storeMergedCells(), _storeObjPicture(), _storePanes(), _storePassword(), _storePrintGridlines(), _storePrintHeaders(), _storeProtect(), _storeSelection(), _storeSetup(), _storeVbreak(), _storeVcenter(), _storeWindow2(), _storeWsbool(), _storeZoom(), _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), mergeCells(), setRow(), writeBlank(), writeFormula(), writeNote(), writeNumber(), writeString(), and writeStringBIFF8().

$link_type [1/2]

if (!preg_match("/\\", $url)) if (preg_match("/^\\\\", $url) Spreadsheet_Excel_Writer_Worksheet::$link_type) = 0x01 | $absolute

Definition at line 2054 of file Worksheet.php.

$link_type [2/2]

if (preg_match("/\/", $url)) Spreadsheet_Excel_Writer_Worksheet::$link_type = pack("V", $link_type)

Definition at line 2082 of file Worksheet.php.

$name

Spreadsheet_Excel_Writer_Worksheet::$name

Definition at line 52 of file Worksheet.php.

Referenced by getName(), and Spreadsheet_Excel_Writer_Worksheet().

$print_colmax

Spreadsheet_Excel_Writer_Worksheet::$print_colmax

Definition at line 278 of file Worksheet.php.

$print_colmin

Spreadsheet_Excel_Writer_Worksheet::$print_colmin

Definition at line 272 of file Worksheet.php.

$print_rowmax

Spreadsheet_Excel_Writer_Worksheet::$print_rowmax

Definition at line 266 of file Worksheet.php.

$print_rowmin

Spreadsheet_Excel_Writer_Worksheet::$print_rowmin

Definition at line 260 of file Worksheet.php.

$record

Spreadsheet_Excel_Writer_Worksheet::$record = 0x01B8

Definition at line 2021 of file Worksheet.php.

Referenced by _storeColinfo(), _storeDataValidity(), _storeDefcol(), _storeDimensions(), _storeExterncount(), _storeExternsheet(), _storeFooter(), _storeGridset(), _storeGuts(), _storeHbreak(), _storeHcenter(), _storeHeader(), _storeMarginBottom(), _storeMarginLeft(), _storeMarginRight(), _storeMarginTop(), _storeMergedCells(), _storeObjPicture(), _storePanes(), _storePassword(), _storePrintGridlines(), _storePrintHeaders(), _storeProtect(), _storeSelection(), _storeSetup(), _storeVbreak(), _storeVcenter(), _storeWindow2(), _storeWsbool(), _storeZoom(), _writeUrlInternal(), _writeUrlWeb(), insertBitmap(), mergeCells(), setRow(), writeBlank(), writeFormula(), writeNote(), writeNumber(), writeString(), and writeStringBIFF8().

$selected

Spreadsheet_Excel_Writer_Worksheet::$selected

Definition at line 164 of file Worksheet.php.

Referenced by _storeWindow2().

$str_error

if ( $str=='') Spreadsheet_Excel_Writer_Worksheet::$str_error = $this->writeString($row1, $col1, $str, $format)

Definition at line 2037 of file Worksheet.php.

Referenced by _writeUrlInternal(), _writeUrlWeb(), writeString(), and writeStringBIFF8().

$stream_len

Spreadsheet_Excel_Writer_Worksheet::$stream_len = pack("V", 0)

Definition at line 2098 of file Worksheet.php.

$title_colmin

Spreadsheet_Excel_Writer_Worksheet::$title_colmin

Definition at line 254 of file Worksheet.php.

$title_rowmax

Spreadsheet_Excel_Writer_Worksheet::$title_rowmax

Definition at line 248 of file Worksheet.php.

$title_rowmin

Spreadsheet_Excel_Writer_Worksheet::$title_rowmin

Definition at line 242 of file Worksheet.php.

$unknown1

Spreadsheet_Excel_Writer_Worksheet::$unknown1 = pack("H*",'D0C9EA79F9BACE118C8200AA004BA90B02000000' )

Definition at line 2101 of file Worksheet.php.

Referenced by _writeUrlInternal(), and _writeUrlWeb().

$unknown2

Spreadsheet_Excel_Writer_Worksheet::$unknown2 = pack("H*",'0303000000000000C000000000000046' )

Definition at line 2102 of file Worksheet.php.

Referenced by _writeUrlWeb().

$unknown3

Spreadsheet_Excel_Writer_Worksheet::$unknown3 = pack("H*",'FFFFADDE000000000000000000000000000000000000000')

Definition at line 2103 of file Worksheet.php.

$unknown4

Spreadsheet_Excel_Writer_Worksheet::$unknown4 = pack("v", 0x03 )

Definition at line 2104 of file Worksheet.php.

$up_count

Spreadsheet_Excel_Writer_Worksheet::$up_count = preg_match_all("/\.\.\\\/", $dir_long, $useless)

Definition at line 2085 of file Worksheet.php.

$url [1/2]

if (! $format) Spreadsheet_Excel_Writer_Worksheet::$url = preg_replace('/^external:/', '', $url)

Definition at line 2030 of file Worksheet.php.

Referenced by _writeUrlInternal(), _writeUrlRange(), _writeUrlWeb(), and writeUrl().

$url [2/2]

Spreadsheet_Excel_Writer_Worksheet::$url = preg_replace('/\//', "\\", $url)

Definition at line 2031 of file Worksheet.php.

---

The documentation for this class was generated from the following file:

• Services/PEAR/lib/Spreadsheet/Excel/Writer/Worksheet.php