Client side Grid Export To Excel

function ToExcel(){





if (window.ActiveXObject){



var  xlApp = new ActiveXObject("Excel.Application"); 

var xlBook = xlApp.Workbooks.Add();





xlBook.worksheets("Sheet1").activate;

var XlSheet = xlBook.activeSheet;

xlApp.visible = true; 



for(var P = 1; P<= obj.getRowProperty("count"); P++){



      for(var Q = 1; Q <= obj.getColumnProperty("count"); Q++){

      if (P==1){

      XlSheet.cells(P ,Q).value = obj.getColumnProperty("text",Q-1)

      }

      

             XlSheet.cells(P +1,Q).value = obj.getDataText(P-1,Q-1);

}

}

XlSheet.columns.autofit; 

}

}//end function

Hi Leon Van Zyl,
I am using the script above "ToExcel()" function to export to excel. Its working fine when i use it locally (WITHOUT PUTTING IN MY TOMCAT SERVER). But when I upload the file on Tomcat server and use it there. It doesn't allow me. It says "Automation server cannot create object". I know that the active x object is not being created. but i dont know how to enable it.

Please contact me immediately as I am in need.

Reply to m4manoj@gmail.com

Thanks,
- Manoj.

Hi Leon Van Zyl,
thanks for the code, It works wonderful with IE. How this code can be modified to work in firefox under windows?

Thanks in Advance,
Kumar S

it can't work in firefox

I am facing the same problem detailed above e.g. "Automation server cannot create object". I know that the active x object is not being created. but i dont know how to enable it
Is there anyone who know how to enable it

Love to see response very soon

This is Client side automation, should thus be run within client side script..
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757

Hi Ali,

To enable it .. use the below procedure:

Go to
Tools -> Internet Options -> Security -> Custom Level

Select Prompt in Download signed ActiveX controls.

When prompted select Yes and you will be able to create the ActiveX object.

Hello -

Has anyone tried this script in v2.?

When doing so it seems to be bombong out at:

XlSheet.cells(P ,Q).value = obj.getColumnProperty("text",Q-1)

Any thoughts??

This solution requires Automation Objects in client side, that FORCES the client side to have Automation Object (by meas of M$ Office setup) and completelly disscard a general solution.

Consider XML and excel file generation by XSL transformations. This is a little bit complicated but pretty flexible.

Regards...

How do i get this to work with Version 2?

HI raciel, please tell me more about the solution u propose about the XLS transformation.. where can i find a code example ??

Hi,

I am Kapil Gupta and presently working on exporting data to Microsoft Excel. Basically I am creating ActivXObject for it.

<html>

<head>

<script type="text/javascript">

function writeme()

{

var excel = new ActiveXObject ("Excel.Application");

excel.visible = true;

var book = excel.Workbooks.Add ();

var sheet = excel.Worksheets(1);

sheet.Range ("A1") = "Checking";

sheet.Pictures.Add(5,6,"C:\\me.gif");

}

</script>

</head>

<body onload="writeme()">

</body>

</html>

On loading it is giving Error:Argument not Optional.

I have searched a lot for it on net but coud not find any fruitful results in javascript.

Can u please help me with this

can u give me the same fix which can work with both mozilla and IE.

please, It's immediate requirement

The code posted by Leon Van Zyl worked great. However, quotes "" get encoded in Excel and appear as " How can that be avoided?

Update for v2, still doesn't work in FF:

function ToExcel(){ 

    if (window.ActiveXObject){ 

      var xlApp = new ActiveXObject("Excel.Application");  

      var xlBook = xlApp.Workbooks.Add(); 



      xlBook.worksheets("Sheet1").activate; 

      var XlSheet = xlBook.activeSheet; 

      xlApp.visible = true;  



      var xlRow = 1;

      var xlCol = 1;



      for (var C = 0; C < table.getColumnCount(); C++){ 

        XlSheet.cells(xlRow, xlCol).value = table.getHeaderText(table.getColumnIndices()[C]);

        xlCol++;

      }



      for (var R = 0; R < table.getRowCount(); R++) { 

        xlRow++;

        xlCol = 1;

        for (var C = 0; C < table.getColumnCount(); C++) { 

          XlSheet.cells(xlRow, xlCol).value = table.getCellText(table.getColumnIndices()[C], R); 

          xlCol++;

        } 

      }                                                                                      

      XlSheet.columns.autofit;                                                               

    }                                                                                        

  }

Hi Leon Van Zyl, Manoj

I have script, which is used to export the table information to the excel file.
The code is working fine in client machine (I am using Windows XP & IE 6.0). I have uploaded the same file in free hosting server, and tested the same html page using IE 6.0, but its not downloading(not open the excel file with data).

What's the issue in that? Could please help me to resolve this?

My code is given below:
<html>
<head>
<title>Testing</title>
</head>
<body>
<script language="vbscript">
Sub exporttoexcel
Dim sHTML
Dim oExcel
Dim oBook
sHTML = document.all.item("inner_table").outerhtml
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument
oExcel.Visible = true
oExcel.UserControl = true
End Sub
</script>
<table border = 0 cell padding = 0>
<tr>
<td><font size = -1><a href='javascript:exporttoexcel()'>Export To Excel</a></td>
</tr>
</table>

<table id ="inner_table">
<tr><td> Hello</td></tr>
</table>
</body>
</html>

Thanks

Forum search