Exporting DataGrid As Excel

[batista]

Hi,

I have a web datagrid and i want to give user option
to export it as excel file.

How is it implemented?

Bye.

 

[Tasos Vogiatzoglou]

exportToExcel = function() {
var i;
var j;
var mycell;
var objXL;
try {
objXL = new ActiveXObject("Excel.Application");
if (objXL==null) {
alert("Excel must be installed");
return;
}
}
catch(e){
alert("Error creating Excel ActiveX ");
return;
}
var objWB = objXL.Workbooks.Add();
var objWS = objWB.ActiveSheet;

var tbl = actualTable; // here goes your table object

for (i=0; i < tbl.rows.length; i++) {
for (j=0; j < tbl.rows(i).cells.length; j++) {
mycell = tbl.rows(i).cells(j);
objWS.Cells(i+1,j+1).Value = mycell.innerText;

if ((mycell.innerText.indexOf("/") >= 0) && (mycell.innerText.length
<= 10))
{
objWS.Cells(i+1,j+1).NumberFormat = "dd/mm/yyyy";
objWS.Cells(i+1,j+1).HorizontalAlignment = -4108;
objWS.Cells(i+1,j+1).Font.color = mycell.style.color;
}
}
}

objWS.Range("A1", "L1").Font.Bold = true;
objWS.Range("A1", "Z1").EntireColumn.AutoFit();

objXL.Visible = true;
};

Something like this ...

 

[batista]

thnks for reply,

I have an aspnet datagrid. now at this line

var tbl = actualTable; // here goes your table object

i can get the object of aspdtagrid but how do i access
the rows length, cells length etc in the remaining lines.
I mean js is giving error.

And wat if i want to open a save file dialog when the user
clicks on the excel link.How do i implemet this?

Bye.

 

[Guest]

Hi,
Check this out
http://www.wwwcoder.com/main/parentid/254/site/5334/68/default.aspx

 

[Tasos Vogiatzoglou]

actualTable = the DOM object representing the table ...
document.getElementById('tableId');