Docs For Class Spreadsheet_Excel

Description

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

author: Xavier Noguer <xnoguer@rezebra.com>
version: Release: 1.9.0
copyright: 1997-2006 The PHP Group

Located in /web/plugin/feature/sms_excel/lib/external/Spreadsheet/Excel/Writer.php (line 45)

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

Method Summary

static string rowcolToCell (integer $row, integer $col)

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

void send (string $filename)

Variables

Inherited Variables

Inherited from Spreadsheet_Excel_Writer_Workbook

Spreadsheet_Excel_Writer_Workbook::$_1904
Spreadsheet_Excel_Writer_Workbook::$_activesheet
Spreadsheet_Excel_Writer_Workbook::$_biffsize
Spreadsheet_Excel_Writer_Workbook::$_codepage
Spreadsheet_Excel_Writer_Workbook::$_country_code
Spreadsheet_Excel_Writer_Workbook::$_fileclosed
Spreadsheet_Excel_Writer_Workbook::$_filename
Spreadsheet_Excel_Writer_Workbook::$_firstsheet
Spreadsheet_Excel_Writer_Workbook::$_formats
Spreadsheet_Excel_Writer_Workbook::$_palette
Spreadsheet_Excel_Writer_Workbook::$_parser
Spreadsheet_Excel_Writer_Workbook::$_selected
Spreadsheet_Excel_Writer_Workbook::$_sheetname
Spreadsheet_Excel_Writer_Workbook::$_sheetnames
Spreadsheet_Excel_Writer_Workbook::$_string_sizeinfo_size
Spreadsheet_Excel_Writer_Workbook::$_tmp_format
Spreadsheet_Excel_Writer_Workbook::$_url_format
Spreadsheet_Excel_Writer_Workbook::$_worksheets
Spreadsheet_Excel_Writer_Workbook::$_xf_index

Inherited from Spreadsheet_Excel_Writer_BIFFwriter

Spreadsheet_Excel_Writer_BIFFwriter::$_BIFF_version
Spreadsheet_Excel_Writer_BIFFwriter::$_byte_order
Spreadsheet_Excel_Writer_BIFFwriter::$_data
Spreadsheet_Excel_Writer_BIFFwriter::$_datasize
Spreadsheet_Excel_Writer_BIFFwriter::$_limit
Spreadsheet_Excel_Writer_BIFFwriter::$_tmp_dir

Methods

static rowcolToCell (line 84)

Utility function for writing formulas Converts a cell's coordinates to the A1 format.

return: The cell identifier in A1 format
access: public

static string rowcolToCell (integer $row, integer $col)

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

Constructor Spreadsheet_Excel_Writer (line 53)

The constructor. It just creates a Workbook

return: The Workbook created

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

string $filename: The optional filename for the Workbook.

send (line 65)

Send HTTP headers for the Excel file.

access: public

void send (string $filename)

string $filename: The filename to use for HTTP headers

Inherited Methods

Inherited From Spreadsheet_Excel_Writer_Workbook

Spreadsheet_Excel_Writer_Workbook::Spreadsheet_Excel_Writer_Workbook()
Spreadsheet_Excel_Writer_Workbook::addFormat()
Spreadsheet_Excel_Writer_Workbook::addValidator()
Spreadsheet_Excel_Writer_Workbook::addWorksheet()
Spreadsheet_Excel_Writer_Workbook::close()
Spreadsheet_Excel_Writer_Workbook::setCountry()
Spreadsheet_Excel_Writer_Workbook::setCustomColor()
Spreadsheet_Excel_Writer_Workbook::setVersion()
Spreadsheet_Excel_Writer_Workbook::sheets()
Spreadsheet_Excel_Writer_Workbook::worksheets()

Inherited From Spreadsheet_Excel_Writer_BIFFwriter

Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
Spreadsheet_Excel_Writer_BIFFwriter::setTempDir()

Inherited From PEAR

PEAR::PEAR()
PEAR::delExpect()
PEAR::expectError()
PEAR::getStaticProperty()
PEAR::isError()
PEAR::loadExtension()
PEAR::popErrorHandling()
PEAR::popExpect()
PEAR::pushErrorHandling()
PEAR::raiseError()
PEAR::registerShutdownFunc()
PEAR::setErrorHandling()
PEAR::staticPopErrorHandling()
PEAR::staticPushErrorHandling()
PEAR::throwError()
PEAR::_PEAR()