PHP Classes

XLS Class: Compose and generate Excel XLS spreadsheet files

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 55%Total: 2,018 All time: 1,947 This week: 42Up
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  

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 (2)  
File Role Description
Files folder imagexls.class (2 files)

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
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,018
This week:0
All time:1,947
This week:42Up
 User Ratings  
 
 All time
Utility:83%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:-
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:55%StarStarStar
Rank:1918
  

  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