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  
Name: Prithwiraj Bose <contact>
Classes: 1 package by
Country: United Kingdom
Age: 38
All time rank: 149668 in United Kingdom
Week rank: 195 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 (2)  
File Role Description
Files folder imagexls.class (2 files)

  Files folder image Files (2)  /  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

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