PHP HTML Excel: Convert HTML to Excel spreadsheets

Recommend this page to a friend!
  Info   Documentation   View files (3)   Download .zip   Reputation   Support forum (5)   Blog    
Ratings Unique User Downloads Download Rankings
65%Total: 1,631 This week: 6All time: 2,384 This week: 38
Version License PHP version Categories
htmlexcel 1.0.0Custom (specified...5Utilities and Tools
Description Author

This class can convert HTML to Excel spreadsheets.

It can take the HTML of a table rows and headers, as well optional CSS, and generates a file that can be opened as a spreadsheet in Microsoft Excel.

The class can serve the Excel file for download using the appropriate headers for making it open in Excel or equivalent server in the user machine.

This class is able to create Excel spreadsheets directly from HTML tables. It is possible to use CSS for styling.

Recommendations

What is the best PHP export excel class?
Trying to export query to an Excel file

Picture of Gustavo Alves
  Performance   Level  
Name: Gustavo Alves <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: 32
All time rank: 1726120 in Brazil Brazil
Week rank: 38 1 in Brazil Brazil

Details

HtmlExcel

Turn HTML tables into multi-sheet Excel files.

Example

require_once('HtmlExcel.php');

$css = "
.red {
	color: red;
}";

$numbers = '<table>
<tr>
	<td class="red">1</td>
	<td>2</td>
	<td>3</td>
</tr>
<tr>
	<td>4</td>
	<td class="red">5</td>
	<td>6</td>
</tr>
<tr>
	<td>7</td>
	<td>8</td>
	<td class="red">9</td>
</tr>
</table>';

$names = '<table>
  <tr>
    <th>First name</th>
    <th>Last name</th>
  </tr>
  <tr>
    <td>John</td>
    <td>Doe</td>
  </tr>
  <tr>
    <td>Jane</td>
    <td>Doe</td>
  </tr>
</table>';

$xls = new HtmlExcel();
$xls->setCss($css);
$xls->addSheet("Numbers", $numbers);
$xls->addSheet("Names", $names);
$xls->headers();
echo $xls->buildFile();
  Files  
File Role Description
HtmlExcel.php Class Class source
LICENSE Lic. License text
README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:1,631
This week:6
All time:2,384
This week:38
User Ratings User Comments (1)
 All time
Utility:93%
Consistency:93%
Documentation:93%
Examples:-
Tests:-
Videos:-
Overall:65%
Rank:782
  

For more information send a message to info at phpclasses dot org.