Login   Register  
PHP Classes
elePHPant
Icontem

File: example_export.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ignatius Teo  >  MS-Excel Stream Handler  >  example_export.php  >  Download  
File: example_export.php
Role: Example script
Content type: text/plain
Description: Example export script
Class: MS-Excel Stream Handler
Stream wrapper to read and write MS Excel files
Author: By
Last change: Description change
Date: 9 years ago
Size: 854 bytes
 

Contents

Class file image Download
<?php
/**
 * MS-Excel stream handler
 * Excel export example
 * @author      Ignatius Teo            <ignatius@act28.com>
 * @copyright   (C)2004 act28.com       <http://act28.com>
 * @date        21 Oct 2004
 */
require_once "excel.php";
$export_file "xlsfile://tmp/example.xls";
$fp fopen($export_file"wb");
if (!
is_resource($fp))
{
    die(
"Cannot open $export_file");
}

// typically this will be generated/read from a database table
$assoc = array(
    array(
"Sales Person" => "Sam Jackson""Q1" => "$3255""Q2" => "$3167""Q3" => 3245"Q4" => 3943),
    array(
"Sales Person" => "Jim Brown""Q1" => "$2580""Q2" => "$2677""Q3" => 3225"Q4" => 3410),
    array(
"Sales Person" => "John Hancock""Q1" => "$9367""Q2" => "$9875""Q3" => 9544"Q4" => 10255),
);

fwrite($fpserialize($assoc));
fclose($fp);
?>