Login   Register  
PHP Classes
elePHPant
Icontem

File: test.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Xavier Noguer  >  Spreadsheet_WriteExcel  >  test.php  >  Download  
File: test.php
Role: Example script
Content type: text/plain
Description: A small test
Class: Spreadsheet_WriteExcel
Classes for generating Excel files
Author: By
Last change: new Version
Date: 12 years ago
Size: 3,296 bytes
 

Contents

Class file image Download
<?php
  
//require_once('OLEwriter.php');
  //require_once('BIFFwriter.php');
  
require_once('Worksheet.php');
  require_once(
'Workbook.php');

  function 
HeaderingExcel($filename) {
      
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");
      }

  
// HTTP headers
  
HeaderingExcel('test.xls');

  
// Creating a workbook
  
$workbook = new Workbook("-");
  
// Creating the first worksheet
  
$worksheet1 =& $workbook->add_worksheet('First One');
  
$worksheet1->set_column(1140);
  
$worksheet1->set_row(120);
  
$worksheet1->write_string(11"This worksheet's name is ".$worksheet1->get_name());
  
$worksheet1->write(2,1,"http://www.phpclasses.org/browse.html/package/767.html");
  
$worksheet1->write_number(3011);
  
$worksheet1->write_number(311);
  
$worksheet1->write_string(32"by four is");
  
$worksheet1->write_formula(33"=A4 * (2 + 2)");
  
//$worksheet1->write_formula(3, 3, "= SUM(A4:B4)");
  
$worksheet1->write(54"= POWER(2,3)");
  
$worksheet1->write(44"= SUM(5, 5, 5)");
  
//$worksheet1->write_formula(4, 4, "= LN(2.71428)");
  //$worksheet1->write_formula(5, 4, "= SIN(PI()/2)");

  // Creating the second worksheet
  
$worksheet2 =& $workbook->add_worksheet();

  
// Format for the headings
  
$formatot =& $workbook->add_format();
  
$formatot->set_size(10);
  
$formatot->set_align('center');
  
$formatot->set_color('white');
  
$formatot->set_pattern();
  
$formatot->set_fg_color('magenta');

  
$worksheet2->set_column(0,0,15);
  
$worksheet2->set_column(1,2,30);
  
$worksheet2->set_column(3,3,15);
  
$worksheet2->set_column(4,4,10);

  
$worksheet2->write_string(1,0,"Id",$formatot);
  
$worksheet2->write_string(1,1,"Name",$formatot);
  
$worksheet2->write_string(1,2,"Adress",$formatot);
  
$worksheet2->write_string(1,3,"Phone Number",$formatot);
  
$worksheet2->write_string(1,4,"Salary",$formatot);

  
$worksheet2->write(3,0,"22222222-2");
  
$worksheet2->write(3,1,"John Smith");
  
$worksheet2->write(3,2,"Main Street 100");
  
$worksheet2->write(3,3,"02-5551234");
  
$worksheet2->write(3,4,100);
  
$worksheet2->write(4,0,"11111111-1");
  
$worksheet2->write(4,1,"Juan Perez");
  
$worksheet2->write(4,2,"Los Paltos 200");
  
$worksheet2->write(4,3,"03-5552345");
  
$worksheet2->write(4,4,110);
  
// if you are writing a very long worksheet, you may want to use
  // write_xxx() functions, instead of write() for performance reasons.
  
$worksheet2->write_string(5,0,"11111111-1");
  
$worksheet2->write_string(5,1,"Another Guy");
  
$worksheet2->write_string(5,2,"Somewhere 300");
  
$worksheet2->write_string(5,3,"03-5553456");
  
$worksheet2->write(5,4,108);


  
// Calculate some statistics
  
$worksheet2->write(70"Average Salary:");
  
$worksheet2->write_formula(74"= AVERAGE(E4:E6)");
  
$worksheet2->write(80"Minimum Salary:");
  
$worksheet2->write_formula(84"= MIN(E4:E6)");
  
$worksheet2->write(90"Maximum Salary:");
  
$worksheet2->write_formula(94"= MAX(E4:E6)");

  
//$worksheet2->insert_bitmap(0, 0, "some.bmp",10,10);

  
$workbook->close();
?>