PHP Classes

Excel Writer: Generate spreadsheet files Excel .xls XML format

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
StarStarStarStar 60%Total: 36,657 This week: 1All time: 11 This week: 42Down
Version License PHP version Categories
excelwriter 1.0.0Freeware3XML, Files and Folders
Description 

Author

Harish Chauhan

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

  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.


  Pages that reference this package  
It is necessary to create Excel-files from PHP...
I dont believe there is an easy way to do it, I found this code over at phpclasses.org that seems to do what you want...
Sometimes a PHP programmer is faced with a situation where a customer requests to export data...
Harish suggested I use the PEAR class, get it working and then extract the class code to my other class libs when it works...
With this utility will manage to create a spreadsheet with PHP...
...
If you need to read files Excel (.xls) in PHP, the library PHP-ExcelReader was created specifically for you...
Aveti un site scris in PHP cu o baza de date in spate... Datele sunt organizate in tabele si vreti sa le exportati in excel, gata formatate? Nimic mai simplu...
...
On this theme, a lot has been written, I simply show how it is done...
does anybody have a sample code for writing to an Excel file, using Oracle as database?...
also wenn es wie excel aussehen soll dann bietet sich die Excel Writer (xls, excel writer, excelwriter, excelwriter.inc.php) - PHP Classes exelwriter class an, mysql ist aber nicht excel und das ist ein ganz schöner aufwand, leider wird von Controlleren Excel immer noch als das beste aller tools angesehen...

Latest pages that reference packages Latest pages that reference packages