JavaScript - Export Excel Javascript

Hi All,

Is it possible to export html table contents to excel file using javascript

Advice me.

Thanks

Lokesh

<table id="tblExample" border="1">
<tr> <b><td>Name </td> <td>Age</td></b></tr>
<tr> <td>Shivani </td> <td>25</td> </tr>
<tr> <td>Naren </td> <td>28</td> </tr>
<tr> <td>Logs</td> <td>57</td> </tr>
<tr> <td>Kas</td> <td>54</td> </tr>
<tr> <td>Sent </td> <td>26</td> </tr>
<tr> <td>Bruce </td> <td>7</td> </tr>
</table>

function CreateExcelSheet()
{


var x=tblExample.rows

var xls = new ActiveXObject("Excel.Application")
xls.visible = true
xls.Workbooks.Add
for (i = 0; i < x.length; i++)
{
var y = x[i].cells

for (j = 0; j < y.length; j++)
{
xls.Cells( i+1, j+1).Value = y[j].innerText
}
}




}
</script>

u can try the following code, 

DataSet ds=objAdmin.getErrorsInDetail();
    Response.AppendHeader("Content-Disposition", "attachment; filename=Error.xls") ;
    Response.ContentType="application/ms-excel";

    Response.Write("<table>");
    Response.Write("<tr>");
    for(int i=0;i<ds.Tables[0].Columns.Count;i++)
    {
     Response.Write("<td>"+ ds.Tables[0].Columns[i].ColumnName  +"</td>"); 
    }
    Response.Write("</tr>");
    for(int i=0;i<ds.Tables[0].Rows.Count;i++)
    {
     Response.Write("<tr>");
     DataRow row=ds.Tables[0].Rows[i];
     for(int j=0;j<ds.Tables[0].Columns.Count;j++)
     {
      
      Response.Write("<td>"+ row[j]+"</td>"); 
     }
     Response.Write("</tr>");
    }
    Response.Write("</table>");
    Response.End();

Code:

function CreateExcelSheet()
{
var x=myTable.rows
var xls = new ActiveXObject("Excel.Application")
xls.visible = true
xls.Workbooks.Add
for (i = 0; i < x.length; i++)
{
var y = x[i].cells
for (j = 0; j < y.length; j++)
{
xls.Cells( i+1, j+1).Value = y[j].innerText
}
}

I tried the above code and i'm getting the following js error:

Automation Server Can't create an object..  at the line

var xls = new ActiveXObject("Excel.Application")

to solve your error;

This error comes because of IE's security mechanism, which allows for different security settings for Local intranet, internet, trusted sites etc. So when you are running the script from an HTML on your local disk, the browser considers this to be secure and allows it to run.

When you run it from wwwroot, I guess it would come under local intranet and would have a different set of permissions.

However, it should be quite easy to do.

Open IE -> Tools ->Internet Options -> Security -> Custom Level -> ActiveX controls and plug-ins ->Enable "Initialize and script ActiveX controls not marked as safe for scripting"

Best Luck!!!!!!!!!!!!!!!!!!
Sujit.

Hi Sujit,

I had set the mentioned internet options in IE6.0 and IE7.0, but i'm still getting the same error. Where i'm wrong.

Thanks for the reply

Lokesh

Hi Sujit,

I'm sorry, Under the security tab - there are 4 zones, Internet, Local Internet, Trusted sites, Restricted Sites. I was doing mentioned option in Internet Zone but not in Local Internet. Now it is working fine...

Thanks

Lokesh

I like this code, however what if i have multiple <table>'s I want to export to excel.

I'm trying the following but it's not working:

var x=myTable.rows + myTable2.rows;

Of course i added a second id="myTable2" in the below the firs myTable. They have the same number of columns.

Any idea?