Class Spreadsheet_Excel_Writer

Description

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

Located in /libraries/pear/Spreadsheet/Excel/Writer.php (line 45)

PEAR
   |
   --Spreadsheet_Excel_Writer_BIFFwriter
      |
      --Spreadsheet_Excel_Writer_Workbook
         |
         --Spreadsheet_Excel_Writer
Method Summary
 Spreadsheet_Excel_Writer_Workbook Spreadsheet_Excel_Writer ([string $filename = ''])
 string rowcolToCell (integer $row, integer $col)
 void send (string $filename)
Variables
Methods
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.
rowcolToCell (line 84)

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

  • return: The cell identifier in A1 format
  • static:
  • access: public
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).
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::setTempDir()
 Spreadsheet_Excel_Writer_Workbook::setVersion()
 Spreadsheet_Excel_Writer_Workbook::sheets()
 Spreadsheet_Excel_Writer_Workbook::worksheets()
 Spreadsheet_Excel_Writer_Workbook::_calcSheetOffsets()
 Spreadsheet_Excel_Writer_Workbook::_calculateSharedStringsSizes()
 Spreadsheet_Excel_Writer_Workbook::_setPaletteXl97()
 Spreadsheet_Excel_Writer_Workbook::_storeAllFonts()
 Spreadsheet_Excel_Writer_Workbook::_storeAllNumFormats()
 Spreadsheet_Excel_Writer_Workbook::_storeAllStyles()
 Spreadsheet_Excel_Writer_Workbook::_storeAllXfs()
 Spreadsheet_Excel_Writer_Workbook::_storeBoundsheet()
 Spreadsheet_Excel_Writer_Workbook::_storeCodepage()
 Spreadsheet_Excel_Writer_Workbook::_storeCountry()
 Spreadsheet_Excel_Writer_Workbook::_storeDatemode()
 Spreadsheet_Excel_Writer_Workbook::_storeExterncount()
 Spreadsheet_Excel_Writer_Workbook::_storeExterns()
 Spreadsheet_Excel_Writer_Workbook::_storeExternsheet()
 Spreadsheet_Excel_Writer_Workbook::_storeExternsheetBiff8()
 Spreadsheet_Excel_Writer_Workbook::_storeNameLong()
 Spreadsheet_Excel_Writer_Workbook::_storeNames()
 Spreadsheet_Excel_Writer_Workbook::_storeNameShort()
 Spreadsheet_Excel_Writer_Workbook::_storeNumFormat()
 Spreadsheet_Excel_Writer_Workbook::_storeOLEFile()
 Spreadsheet_Excel_Writer_Workbook::_storePalette()
 Spreadsheet_Excel_Writer_Workbook::_storeSharedStringsTable()
 Spreadsheet_Excel_Writer_Workbook::_storeStyle()
 Spreadsheet_Excel_Writer_Workbook::_storeSupbookInternal()
 Spreadsheet_Excel_Writer_Workbook::_storeWindow1()
 Spreadsheet_Excel_Writer_Workbook::_storeWorkbook()

Inherited From Spreadsheet_Excel_Writer_BIFFwriter

 Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
 Spreadsheet_Excel_Writer_BIFFwriter::_addContinue()
 Spreadsheet_Excel_Writer_BIFFwriter::_append()
 Spreadsheet_Excel_Writer_BIFFwriter::_prepend()
 Spreadsheet_Excel_Writer_BIFFwriter::_setByteOrder()
 Spreadsheet_Excel_Writer_BIFFwriter::_storeBof()
 Spreadsheet_Excel_Writer_BIFFwriter::_storeEof()

Documentation generated on Fri, 11 Feb 2005 18:14:41 +0000 by phpDocumentor 1.3.0RC3