Login   Register  
PHP Classes
elePHPant
Icontem

File: excelgen_example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Erh-Wen,Kuo  >  sql2excel  >  excelgen_example.php  >  Download  
File: excelgen_example.php
Role: ???
Content type: text/plain
Description: This is a simple demo showing how to use 'excelgen' class.
Class: sql2excel
Easy way to stream Mysql sql content to Excel.
Author: By
Last change:
Date: 12 years ago
Size: 1,018 bytes
 

Contents

Class file image Download
<?php
	
	/* 
	 * @version V1.0 2002/July/18 (c) Erh-Wen,Kuo (erhwenkuo@yahoo.com). All rights reserved.
	 * Released under both BSD license and Lesser GPL library license. 
	 * Whenever there is any discrepancy between the two licenses, 
	 * the BSD license will take precedence. 
	 *
	 * purpose: This is a example how to use "ExcelGen" class to write number or text
	 *          to excel file format and stream the output to user's browser directly.
	 */
	
	//include "excelgen" class
	include( "excelgen.class.php" );
	
	//initiate a instance of "excelgen" class
	$excel = new ExcelGen("ExcelGen");
	
	//initiate $row,$col variables
	$row=0;
	$col=0;
	
	//write text in cell(0,0)
	$excel->WriteText($row,$col,"This is a ExcelGen Clas Example");
	$row++;
	
	//write number in cell($row,$col)	
	for($row;$row<9;$row++){
		for($col=0;$col<9;$col++){
			$excel->WriteNumber($row,$col,$row*$col);
		}
	}
	
	//stream Excel for user to download or show on browser
	$excel->SendFile();
?>