PHP Classes

XLS Class: Compose and generate Excel XLS spreadsheet files

Recommend this page to a friend!
     
  Info   View files Example   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 2,016 All time: 1,945 This week: 263Up
Version License PHP version Categories
xls-class 1.0GNU General Publi...5PHP 5, Files and Folders
Description 

Author

Prithwiraj Bose

This class can be used to compose and generate Excel XLS spreadsheet files.

It can add cells to the definition of a spreadsheet by specifying the position of the cell and its contents. The contents may be regular text or even formulas.

The composed spreadsheet can be served for download or saved to a given file in Excel XLS format.

Picture of Prithwiraj Bose
  Performance   Level  
Name: Prithwiraj Bose <contact>
Classes: 1 package by
Country: United Kingdom
Age: 36
All time rank: 149468 in United Kingdom
Week rank: 398 Up9 in United Kingdom Up

Level 2 StarStar

Example

<?php
include("xls.class.php");
$xl = new xls();

//adding new cells to the spreadsheet
//syntax: object_of_xls_class->add_cell("column_number:row_number","cell_content");
$xl->add_cell("1:1","Name");
$xl->add_cell("1:2","Rahul");
$xl->add_cell("1:3","Tina");
$xl->add_cell("2:1","Amount");
$xl->add_cell("2:2","36");
$xl->add_cell("2:3","24");
$xl->add_cell("1:4","Total");

//you can apply formula to a cell
$xl->add_cell("2:4","=sum(B2:B3)");

//force download the file with specified name
$xl->execute("myfile.xls");
?>

  Files folder image Files  
File Role Description
Files folder imagexls.class (2 files)

  Files folder image Files  /  xls.class  
File Role Description
  Plain text file index.php Example Example File
  Plain text file xls.class.php Class The XLS PHP Class File

Downloadxls-class-2010-10-27.zip 2KB
Downloadxls-class-2010-10-27.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,016
This week:0
All time:1,945
This week:263Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Related pages  
PHP Website developers