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

Class: Spreadsheet_Excel_Writer

Source Location: /Spreadsheet_Excel_Writer-0.9.3/Spreadsheet/Excel/Writer.php

Class Overview

PEAR
   |
   --Spreadsheet_Excel_Writer_BIFFwriter
      |
      --Spreadsheet_Excel_Writer_Workbook
         |
         --Spreadsheet_Excel_Writer

Class for writing Excel Spreadsheets. This class should change COMPLETELY.


Author(s):

Methods


Inherited Variables

Inherited Methods

Class: Spreadsheet_Excel_Writer_Workbook

Spreadsheet_Excel_Writer_Workbook::Spreadsheet_Excel_Writer_Workbook()
Class constructor
Spreadsheet_Excel_Writer_Workbook::addFormat()
Add a new format to the Excel workbook.
Spreadsheet_Excel_Writer_Workbook::addValidator()
Create new validator.
Spreadsheet_Excel_Writer_Workbook::addWorksheet()
Add a new worksheet to the Excel workbook.
Spreadsheet_Excel_Writer_Workbook::close()
Calls finalization methods.
Spreadsheet_Excel_Writer_Workbook::setCountry()
Set the country identifier for the workbook
Spreadsheet_Excel_Writer_Workbook::setCustomColor()
Change the RGB components of the elements in the colour palette.
Spreadsheet_Excel_Writer_Workbook::setVersion()
Sets the BIFF version.
Spreadsheet_Excel_Writer_Workbook::sheets()
An accessor for the _worksheets[] array Returns an array of the worksheet objects in a workbook It actually calls to worksheets()
Spreadsheet_Excel_Writer_Workbook::worksheets()
An accessor for the _worksheets[] array.

Class: Spreadsheet_Excel_Writer_BIFFwriter

Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
Constructor
Spreadsheet_Excel_Writer_BIFFwriter::setTempDir()
Sets the temp dir used for storing the OLE file

Class Details

[line 45]
Class for writing Excel Spreadsheets. This class should change COMPLETELY.


[ Top ]


Method Detail

Spreadsheet_Excel_Writer (Constructor)   [line 53]

Spreadsheet_Excel_Writer_Workbook Spreadsheet_Excel_Writer( [string $filename = ''])

The constructor. It just creates a Workbook
  • Return: The Workbook created

Parameters:

string   $filename   —  The optional filename for the Workbook.

[ Top ]

rowcolToCell   [line 84]

string rowcolToCell( integer $row, integer $col)

Utility function for writing formulas Converts a cell's coordinates to the A1 format.
  • Return: The cell identifier in A1 format
  • Access: public

Parameters:

integer   $row   —  Row for the cell to convert (0-indexed).
integer   $col   —  Column for the cell to convert (0-indexed).

[ Top ]

send   [line 65]

void send( string $filename)

Send HTTP headers for the Excel file.
  • Access: public

Parameters:

string   $filename   —  The filename to use for HTTP headers

[ Top ]


Documentation generated on Mon, 11 Mar 2019 15:47:17 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.