Public Member Functions | Static Public Member Functions

Spreadsheet_Excel_Writer Class Reference

Inheritance diagram for Spreadsheet_Excel_Writer:
Collaboration diagram for Spreadsheet_Excel_Writer:

Public Member Functions

 Spreadsheet_Excel_Writer ($filename= '')
 The constructor.
 send ($filename)
 Send HTTP headers for the Excel file.

Static Public Member Functions

 rowcolToCell ($row, $col)
 Utility function for writing formulas Converts a cell's coordinates to the A1 format.

Detailed Description

Definition at line 45 of file Writer.php.

Member Function Documentation

Spreadsheet_Excel_Writer::rowcolToCell ( row,
) [static]

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


integer $row Row for the cell to convert (0-indexed).
integer $col Column for the cell to convert (0-indexed).
string The cell identifier in A1 format

Definition at line 84 of file Writer.php.

References $row.

        if ($col > 255) { //maximum column value exceeded
            return new PEAR_Error("Maximum column value exceeded: $col");
        $int = (int)($col / 26);
        $frac = $col % 26;
        $chr1 = '';
        if ($int > 0) {
            $chr1 = chr(ord('A') + $int - 1);
        $chr2 = chr(ord('A') + $frac);
        return $chr1.$chr2.$row;

Spreadsheet_Excel_Writer::send ( filename  ) 

Send HTTP headers for the Excel file.

string $filename The filename to use for HTTP headers public

Definition at line 65 of file Writer.php.

        header("Content-type: application/");
        header("Content-Disposition: attachment; filename=$filename");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
        header("Pragma: public");

Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer ( filename = ''  ) 

The constructor.

It just creates a Workbook

string $filename The optional filename for the Workbook.
Spreadsheet_Excel_Writer_Workbook The Workbook created

Definition at line 53 of file Writer.php.

References Spreadsheet_Excel_Writer_Workbook::Spreadsheet_Excel_Writer_Workbook().

        $this->_filename = $filename;

Here is the call graph for this function:

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