PHP Classes

Excel Writer: Generate spreadsheet files Excel .xls XML format

Recommend this page to a friend!
  Info   View files Example   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (36)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 36,652 This week: 1All time: 11 This week: 560Down
Version License PHP version Categories
excelwriter 1.0.0Freeware3XML, Files and Folders
Description 

Author

This class can generate spreadsheet files in the .xls XML format used by the latest versions of Microsoft Excel.

The class can generate spreadsheet files writing a whole rows at once, or individual row cells one at a time.

Picture of Harish Chauhan
Name: Harish Chauhan is available for providing paid consulting. Contact Harish Chauhan .
Classes: 28 packages by
Country: India India
Age: ???
All time rank: 32 in India India
Week rank: 106 Down8 in India India Down
Innovation award
Innovation award
Nominee: 1x

Recommendations

db.inc.php file needed
Excel export files

Example

<?php

   
include("excelwriter.inc.php");
   
   
$excel=new ExcelWriter("myXls.xls");
   
    if(
$excel==false)
        echo
$excel->error;
       
   
$myArr=array("Name","Last Name","Address","Age");
   
$excel->writeLine($myArr);

   
$myArr=array("Sriram","Pandit","23 mayur vihar",24);
   
$excel->writeLine($myArr);
   
   
$excel->writeRow();
   
$excel->writeCol("Manoj");
   
$excel->writeCol("Tiwari");
   
$excel->writeCol("80 Preet Vihar");
   
$excel->writeCol(24);
   
   
$excel->writeRow();
   
$excel->writeCol("Harish");
   
$excel->writeCol("Chauhan");
   
$excel->writeCol("115 Shyam Park Main");
   
$excel->writeCol(22);

   
$myArr=array("Tapan","Chauhan","1st Floor Vasundhra",25);
   
$excel->writeLine($myArr);
   
   
$excel->close();
    echo
"data is write into myXls.xls Successfully.";
?>


  Files folder image Files  
File Role Description
Plain text file excelwriter.inc.php Class Excel Class
Accessible without login Plain text file excel_example.php Example Example File

 Version Control Unique User Downloads Download Rankings  
 0%
Total:36,652
This week:1
All time:11
This week:560Down
User Ratings User Comments (16)
 All time
Utility:87%StarStarStarStarStar
Consistency:84%StarStarStarStarStar
Documentation:-
Examples:86%StarStarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:1094
 
This library creates HTML format document instead of native E...
7 years ago (hans gulo)
10%Star
It doesn't create an XLS file that other, compliant apps can ...
7 years ago (Maarten Wolzak)
20%StarStar
We should get the latest MS Excel format with formatting of-c...
10 years ago (John Case)
62%StarStarStarStar
Simple and useful.
13 years ago (kenman yung)
67%StarStarStarStar
the best !!!
13 years ago (bulger)
70%StarStarStarStar
Very intuitive and easy to use - excellent work.
14 years ago (Dennis Granger)
70%StarStarStarStar
Very useful class! Thanks so much.
14 years ago (Andrea Puddu)
67%StarStarStarStar
Excellent
14 years ago (kishore kumar)
70%StarStarStarStar
This class does everything it promises to do, and allows you ...
15 years ago (Nosferatu)
70%StarStarStarStar
Good basic example for building Excel spearsheets in PHP
15 years ago (Ron Evans)
52%StarStarStar
This class is the biz - i've been banging my head against a w...
15 years ago (Hugo Scott)
70%StarStarStarStar
Simlpe lightweight does what it says on the tin! brilliant
15 years ago (gb)
70%StarStarStarStar
good job
15 years ago (shemeer)
52%StarStarStar
if you change "<meta http-equiv=Content-Type content="text/ht...
16 years ago (Brend)
52%StarStarStar
thanks alot.
16 years ago (nhat truong bui)
35%StarStar
Loved it KISS Keep It Short and Simple.
16 years ago (Abdul-Aziz Al-Oraij)
70%StarStarStarStar