include/php_writeexcel/example-simple.php

   1 <?php
   2
   3 set_time_limit(10);
   4
   5 require_once "class.writeexcel_workbook.inc.php";
   6 require_once "class.writeexcel_worksheet.inc.php";
   7
   8 $fname = tempnam("/tmp", "merge2.xls");
   9 $workbook = &new writeexcel_workbook($fname);
  10 $worksheet = &$workbook->addworksheet();
  11
  12 # The general syntax is write($row, $column, $token). Note that row and
  13 # column are zero indexed
  14 #
  15
  16 # Write some text
  17 $worksheet->write(0, 0,  "Hi Excel!");
  18
  19 # Write some numbers
  20 $worksheet->write(2, 0,  3);          # Writes 3
  21 $worksheet->write(3, 0,  3.00000);    # Writes 3
  22 $worksheet->write(4, 0,  3.00001);    # Writes 3.00001
  23 $worksheet->write(5, 0,  3.14159);    # TeX revision no.?
  24
  25 # Formulas are not yet supported
  26 //$worksheet->write(7, 0,  '=A3 + A6');
  27 //$worksheet->write(8, 0,  '=IF(A5>3,"Yes", "No")');
  28
  29 # Write a hyperlink
  30 $worksheet->write(7, 0, 'http://www.php.net/');
  31
  32 $workbook->close();
  33
  34 header("Content-Type: application/x-msexcel");
  35 $fh=fopen($fname, "rb");
  36 fpassthru($fh);
  37 unlink($fname);
  38
  39 ?>