Spreadsheet_Excel_Writer
[ class tree: Spreadsheet_Excel_Writer ] [ index: Spreadsheet_Excel_Writer ] [ all elements ]
Packages:
Spreadsheet_Excel_Writer
apidoc


Classes:
Spreadsheet_Excel_Writer
Spreadsheet_Excel_Writer_BIFFwriter
Spreadsheet_Excel_Writer_Format
Spreadsheet_Excel_Writer_Parser
Spreadsheet_Excel_Writer_Validator
Spreadsheet_Excel_Writer_Workbook
Spreadsheet_Excel_Writer_Worksheet
Files:
BIFFwriter.php
Format.php
Validator.php
Workbook.php
Worksheet.php
Writer.php

Class: Spreadsheet_Excel_Writer_Worksheet

Source Location: /Spreadsheet_Excel_Writer-0.9.1/Writer/Worksheet.php

Class Overview

PEAR
   |
   --Spreadsheet_Excel_Writer_BIFFwriter
      |
      --Spreadsheet_Excel_Writer_Worksheet

Class for generating Excel Spreadsheets


Author(s):

Variables

Methods

Inherited Variables

Inherited Methods

Class: Spreadsheet_Excel_Writer_BIFFwriter

Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
Constructor

Class Details

[line 46]
Class for generating Excel Spreadsheets


[ Top ]

Class Variables

$index =

[line 58]

Index for the Worksheet

Type:   integer


[ Top ]

$name =

[line 52]

Name of the Worksheet

Type:   string


[ Top ]

$print_colmax =

[line 278]

Last column of the area to print

Type:   integer


[ Top ]

$print_colmin =

[line 272]

First column of the area to print

Type:   integer


[ Top ]

$print_rowmax =

[line 266]

Last row to of the area to print

Type:   integer


[ Top ]

$print_rowmin =

[line 260]

First row of the area to print

Type:   integer


[ Top ]

$selected =

[line 164]

Bit specifying if the worksheet is selected

Type:   integer


[ Top ]

$title_colmin =

[line 254]

First column to reapeat on each printed page

Type:   integer


[ Top ]

$title_rowmax =

[line 248]

Last row to reapeat on each printed page

Type:   integer


[ Top ]

$title_rowmin =

[line 242]

First row to reapeat on each printed page

Type:   integer


[ Top ]


Method Detail

activate   [line 688]

void 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.

  • Access: public

[ Top ]

centerHorizontally   [line 863]

void centerHorizontally( [integer $center = 1])

Center the page horinzontally.
  • Access: public

Parameters:

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

[ Top ]

centerVertically   [line 874]

void centerVertically( [integer $center = 1])

Center the page vertically.
  • Access: public

Parameters:

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

[ Top ]

close   [line 496]

void close( array $sheetnames)

Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.
  • See: Spreadsheet_Excel_Writer_Workbook::storeWorkbook()
  • Access: public

Parameters:

array   $sheetnames   —   The array of sheetnames from the Workbook this worksheet belongs to

[ Top ]

fitToPages   [line 1053]

void fitToPages( integer $width, integer $height)

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

It doesn't seem to work with OpenOffice.


Parameters:

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

[ Top ]

freezePanes   [line 768]

void freezePanes( array $panes)

Set panes and mark them as frozen.
  • Access: public

Parameters:

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

[ Top ]

getData   [line 626]

string getData( )

Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.
  • Return: The data

[ Top ]

getName   [line 615]

string getName( )

Retrieve the worksheet name.

This is usefull when creating worksheets without a name.

  • Return: The worksheet's name
  • Access: public

[ Top ]

hideGridlines   [line 1018]

void hideGridlines( )

Set the option to hide gridlines on the printed page.
  • Access: public

[ Top ]

hideScreenGridlines   [line 1028]

void hideScreenGridlines( )

Set the option to hide gridlines on the worksheet (as seen on the screen).
  • Access: public

[ Top ]

insertBitmap   [line 3095]

void insertBitmap( integer $row, integer $col, string $bitmap, [integer $x = 0], [integer $y = 0], [integer $scale_x = 1], [integer $scale_y = 1])

Insert a 24bit bitmap image in a worksheet.
  • Access: 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

[ Top ]

mergeCells   [line 2783]

void mergeCells( integer $first_row, integer $first_col, integer $last_row, integer $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').

  • Access: 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

[ Top ]

printArea   [line 1004]

void printArea( integer $first_row, integer $first_col, integer $last_row, integer $last_col)

Set the area of each worksheet that will be printed.
  • Access: 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

[ Top ]

printRowColHeaders   [line 1039]

void printRowColHeaders( [integer $print = 1])

Set the option to print the row and column headers on the printed page.
  • Access: public

Parameters:

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

[ Top ]

protect   [line 714]

void protect( string $password)

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

Parameters:

string   $password   —   The password to use for protecting the sheet.

[ Top ]

repeatColumns   [line 985]

void repeatColumns( integer $first_col, [integer $last_col = null])

Set the columns to repeat at the left hand side of each printed page.
  • Access: public

Parameters:

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

[ Top ]

repeatRows   [line 968]

void repeatRows( integer $first_row, [integer $last_row = null])

Set the rows to repeat at the top of each printed page.
  • Access: public

Parameters:

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

[ Top ]

select   [line 676]

void select( )

Set this worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted.
  • Access: public

[ Top ]

setColumn   [line 731]

void setColumn( integer $firstcol, integer $lastcol, integer $width, [mixed $format = null], [integer $hidden = 0], [integer $level = 0])

Set the width of a single column or a range of columns.
  • Access: 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

[ Top ]

setFirstSheet   [line 701]

void 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.

  • Access: public

[ Top ]

setFooter   [line 847]

void setFooter( string $string, [float $margin = 0.50])

Set the page footer caption and optional margin.
  • Access: public

Parameters:

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

[ Top ]

setHeader   [line 830]

void setHeader( string $string, [float $margin = 0.50])

Set the page header caption and optional margin.
  • Access: public

Parameters:

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

[ Top ]

setHPagebreaks   [line 1067]

void setHPagebreaks( array $breaks)

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

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

  • Access: public

Parameters:

array   $breaks   —   Array containing the horizontal page breaks

[ Top ]

setInputEncoding   [line 1515]

void setInputEncoding( string $encoding)

Sets Input Encoding for writing strings
  • Access: public

Parameters:

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

[ Top ]

setLandscape   [line 806]

void setLandscape( )

Set the page orientation as landscape.
  • Access: public

[ Top ]

setMarginBottom   [line 956]

void setMarginBottom( [float $margin = 1.00])

Set the bottom margin in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMarginLeft   [line 923]

void setMarginLeft( [float $margin = 0.75])

Set the left margin in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMarginRight   [line 934]

void setMarginRight( [float $margin = 0.75])

Set the right margin in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMargins   [line 885]

void setMargins( float $margin)

Set all the page margins to the same value in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMargins_LR   [line 899]

void setMargins_LR( float $margin)

Set the left and right margins to the same value in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMargins_TB   [line 911]

void setMargins_TB( float $margin)

Set the top and bottom margins to the same value in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMarginTop   [line 945]

void setMarginTop( [float $margin = 1.00])

Set the top margin in inches.
  • Access: public

Parameters:

float   $margin   —   The margin to set in inches

[ Top ]

setMerge   [line 660]

void setMerge( integer $first_row, integer $first_col, integer $last_row, integer $last_col)

Sets a merged cell range
  • Access: 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

[ Top ]

setOutline   [line 1376]

void setOutline( [bool $visible = true], [bool $symbols_below = true], [bool $symbols_right = true], [bool $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   —   

[ Top ]

setPaper   [line 817]

void setPaper( [integer $size = 0])

Set the paper type. Ex. 1 = US Letter, 9 = A4
  • Access: public

Parameters:

integer   $size   —   The type of paper size to use

[ Top ]

setPortrait   [line 796]

void setPortrait( )

Set the page orientation as portrait.
  • Access: public

[ Top ]

setPrintScale   [line 1113]

void setPrintScale( [integer $scale = 100])

Set the scale factor for the printed page.

It turns off the "fit to page" option

  • Access: public

Parameters:

integer   $scale   —   The optional scale factor. Defaults to 100

[ Top ]

setRow   [line 2124]

void setRow( integer $row, integer $height, [mixed $format = null], [bool $hidden = false], [integer $level = 0])

This method is used to set the height and format for a row.
  • Access: 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]

[ Top ]

setSelection   [line 752]

void setSelection( integer $first_row, integer $first_column, integer $last_row, integer $last_column)

Set which cell or cells are selected in a worksheet
  • Access: 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

[ Top ]

setValidation   [line 3468]

void setValidation( mixed $row1, mixed $col1, mixed $row2, mixed $col2, mixed &$validator)

FIXME: add comments

[ Top ]

setVPagebreaks   [line 1081]

void setVPagebreaks( array $breaks)

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

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

  • Access: public

Parameters:

array   $breaks   —   Array containing the vertical page breaks

[ Top ]

setZoom   [line 1095]

void setZoom( [integer $scale = 100])

Set the worksheet zoom factor.
  • Access: public

Parameters:

integer   $scale   —   The zoom factor

[ Top ]

thawPanes   [line 785]

void thawPanes( array $panes)

Set panes and mark them as unfrozen.
  • Access: public

Parameters:

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

[ Top ]

write   [line 1136]

void write( integer $row, integer $col, mixed $token, [mixed $format = null])

Map to the appropriate write method acording to the token recieved.
  • Access: 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

[ Top ]

writeBlank   [line 1683]

void writeBlank( integer $row, integer $col, mixed $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

  • Access: public

Parameters:

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

[ Top ]

writeCol   [line 1210]

mixed writeCol( integer $row, integer $col, array $val, [mixed $format = null])

Write an array of values as a column
  • Return: PEAR_Error on failure
  • Access: 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

[ Top ]

writeFormula   [line 1736]

integer writeFormula( integer $row, integer $col, string $formula, [mixed $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

  • Access: public

Parameters:

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

[ Top ]

writeNote   [line 1623]

void writeNote( integer $row, integer $col, string $note)

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

NOTE records don't have a length limit.

  • Access: public

Parameters:

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

[ Top ]

writeNumber   [line 1411]

integer writeNumber( integer $row, integer $col, float $num, [mixed $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

  • Access: public

Parameters:

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

[ Top ]

writeRow   [line 1181]

mixed writeRow( integer $row, integer $col, array $val, [mixed $format = null])

Write an array of values as a row
  • Return: PEAR_Error on failure
  • Access: 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

[ Top ]

writeString   [line 1464]

integer writeString( integer $row, integer $col, string $str, [mixed $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

  • Access: 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

[ Top ]

writeStringBIFF8   [line 1538]

integer writeStringBIFF8( integer $row, integer $col, string $str, [mixed $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

  • Access: 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

[ Top ]

writeUrl   [line 1814]

integer writeUrl( integer $row, integer $col, string $url, [string $string = ''], [mixed $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

  • Access: public

Parameters:

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

[ Top ]
Documentation generated on Tue, 26 Sep 2006 14:33:17 -0400 by phpDocumentor 1.2.3. PEAR Logo Copyright © PHP Group 2004.