JavaScript HTML Table Excel Export: Export HTML table data to Excel format

Recommend this page to a friend!
     
  Info   Example   View files Files   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 65%Total: 341 All time: 122 This week: 4Up
Version License JavaScript version Categories
table2excel 2BSD License1.0HTML, Files and Folders
Description 

Author

Gianluca Zanferrari

This object can export HTML table data to Excel format.

It takes a given HTML table on the current page and extract their contents to put on a template in the Excel XML format. A data URL is returned with the whole table data in the Excel format.

If the browser is Internet Explorer it creates an ActiveX Excel.Application object to open the Excel program. Then it traverses the HTML table to add cells to a spreadsheet opened in Excel.

Innovation Award
JavaScript Programming Innovation award winner
April 2015
Winner		 Excel is a very popular spreadsheet application for editing tabular data.

This package can take a given HTML table on a Web page and export it in such way that makes the browser open the table data on Excel or on a compatible application running on the user machine.

Manuel Lemos
Picture of Gianluca Zanferrari
  Performance   Level  
Name: Gianluca Zanferrari <contact>
Classes: 6 packages by
Country: The Netherlands The Netherlands
Age: 58
All time rank: 81 in The Netherlands The Netherlands
Week rank: 6 Up2 in The Netherlands The Netherlands Down

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Example

<!DOCTYPE html>
<html>
<script language="javascript" type="text/javascript" src="table2Excel.js"></script>
<table id="result-table">
	<thead>
		<tr style="background-color: #ccc">
			<th>Number</th>
			<th>First Name</th>
			<th>Last Name</th>		
			<th>Points</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>1</td>
			<td>Eve</td>
			<td>Jackson</td>		
			<td>94</td>
		</tr>
		<tr>
			<td>2</td>
			<td>John</td>
			<td>Doe</td>		
			<td>80</td>
		</tr>
		<tr>
			<td>3</td>
			<td>Adam</td>
			<td>Johnson</td>		
			<td>67</td>
		</tr>
		<tr>
			<td>4</td>
			<td>Jill</td>
			<td>Smith</td>		
			<td>50</td>
		</tr>
	</tbody>
</table>
<a href="javascript: void(0)" onclick="var obj = new table2Excel(); obj.CreateExcelSheet('result-table','export');">to Excel</a>
</html>

  Files folder image Files (2)  
File Role Description
Accessible without login Plain text file example.html Example example
Plain text file table2Excel.js Class class itself

Downloadtable2excel-2015-04-21.zip 1KB
Downloadtable2excel-2015-04-21.tar.gz 1KB
 Version Control Unique User Downloads Download Rankings  
 0%
Total:341
This week:0
All time:122
This week:4Up
User Ratings User Comments (1)
 All time
Utility:95%StarStarStarStarStar
Consistency:85%StarStarStarStarStar
Documentation:-
Examples:95%StarStarStarStarStar
Tests:-
Videos:-
Overall:65%StarStarStarStar
Rank:29
  

  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.