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,
		$	col
	)			[static]

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

public

Parameters:

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

Returns:

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);
        $row++;
        
        return $chr1.$chr2.$row;
    }

Spreadsheet_Excel_Writer::send

(

$

filename

)

Send HTTP headers for the Excel file.

Parameters:

string

$filename The filename to use for HTTP headers public

Definition at line 65 of file Writer.php.

    {
        header("Content-type: application/vnd.ms-excel");
        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

Parameters:

string

$filename The optional filename for the Workbook.

Returns:

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;
        $this->Spreadsheet_Excel_Writer_Workbook($filename);
    }

Here is the call graph for this function:

---

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

• classes/Spreadsheet/Excel/Writer.php