Skip to main content

Export html table to excel directly by using javascript

Export html table to excel directly by using javascript


I trying to export the html table  to excel by using javascript and I managed to get the sample  ( source code as below).The sample below will automatically export all the records in html table into excel directly.


function write_to_excel()
{
str="";
var mytable = document.getElementsByTagName("table")[0];
var rowCount = mytable.rows.length;
var colCount = mytable.getElementsByTagName("tr")[0].getElementsByTagName("td").length;
var ExcelApp = new ActiveXObject("Excel.Application");
var ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = false;
 for(var i=0; i<rowCount; i++)
 {
  for(var j=0; j<colCount; j++)
  { 
   str= mytable.getElementsByTagName("tr")[i].getElementsByTagName("td")[j].innerHTML;
   ExcelSheet.ActiveSheet.Cells(i+1,j+1).Value = str;
  }
 }

ExcelSheet.SaveAs("C:\\TEST.XLS");
// Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit();
}


function write_to_csv()
{
str="";
var mytable = document.getElementsByTagName("table")[0];
var rowCount = mytable.rows.length;
var colCount = mytable.getElementsByTagName("tr")[0].getElementsByTagName("td").length;
var ExcelApp = new ActiveXObject("Excel.Application");
var ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
var mytable = document.getElementsByTagName("table")[0];
var rowCount = mytable.rows.length;
var colCount = mytable.getElementsByTagName("tr")[0].getElementsByTagName("td").length;
 for(var i=0; i<rowCount; i++)
 {
  for(var j=0; j<colCount; j++)
  {
   str= str + mytable.getElementsByTagName("tr")[i].getElementsByTagName("td")[j].innerHTML + ","; 
  }
  ExcelSheet.ActiveSheet.Cells(i+1,1).Value = str;
  str="";
 }
}

</script>

</head>
<body>
<input type="submit" value="Export to EXCEL" onclick="write_to_excel();"/>
<input type="submit" value="Export to CSV" onclick="write_to_csv();"/>

<br />
<div id="Book1_10219" align=center x:publishsource="Excel">
<table>
<tr><td>123</td><td>test 2</td></tr>
<tr><td>test5</td><td>test 2</td></tr>
</table>
</div>
<body>
</html>

Comments

Popular posts from this blog

Asp.Net Web API

What is ASP.NET Web API? ASP.NET Web API is a framework provided by the Microsoft with which we can easily build HTTP services that can reach a broad of clients, including browsers, mobile, IoT devices, etc. ASP.NET Web API provides an ideal platform for building RESTful applications on the .NET Framework.   Difference between ASP.NET Web API and WCF Web AP I is a Framework to build HTTP Services that can reach a board of clients, including browsers, mobile, IoT Devices, etc. and provided an ideal platform for building RESTful applications. It is limited to HTTP based services. ASP.NET framework ships out with the .NET framework and is Open Source. WCF i.e. Windows Communication Foundation is a framework used for building Service Oriented applications (SOA) and supports multiple transport protocol like HTTP, TCP, MSMQ, etc. It supports multiple protocols like HTTP, TCP, Named Pipes, MSMQ, etc. WCF ships out with the .NET Framework. Both Web API and WCF can be self-hosted or can be...

Creating package in Oracle Database using Toad For Oracle

What are Packages in Oracle Database A package is  a group   of procedures, functions,  variables   and  SQL statements   created as a single unit. It is used to store together related objects. A package has two parts, Package  Specification  and Package Body.