Writing excel 2003 xml files - Printable Version

Code:
&lt;?php

class ExcelTest extends Controller {

    function ExcelTest() {

        parent::Controller();

        

        // Load the library.  This will automatically load the dom helper.

        $this->load->library('excel');

    }

    

    function index() {

        // Create a new style that can be applied to cells.  This particular style will be in the form of $x.xx or ($x.xx) for positive and negative numbers.

        $currency_opts = array('NumberFormat' => array('ss:Format' => '_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)'));

        $currency = $this->excel->create_style($currency_opts);

        

        // Create a new worksheet named WSName as the first worksheet.  Set it to be the active worksheet.

        $this->excel->worksheet("WSName", 1, TRUE);

        

        // Set cell A1 to be equal to B2 + C3

        $this->excel->formula('A1', 'R[1]C[1]+R[2]C[2]');

        

        // Make A1 a currency using our style

        $this->excel->style('A1', $currency);

        

        // Set B2 to 2 and make Excel display it as a number

        $this->excel->cell('B2', 2);

        $this->excel->type('B2', 'Number');

        

        // From now own, don't make us call the type function, just pick the appropriate type for us

        $this->excel->smart_typing(true);

        

        // Set C3 to 3

        $this->excel->cell('C3', 3);

        

        // Force the workbook to be downloaded.  Alternatly, pass 'S' to get the workbook back as an xml string.

        $this->excel->output();

    }

}