Jquery export to excel

hi,

This is my jquery export to excel script. it is working in chrome but not working in IE 9,10,11 .

In IE it is showing like this in URL bar.

data:application/vnd.ms-excel,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

neel k11y ago
Its working in both browsers, but in the Chrome it export the excel but excel is missing the rows and columns, it showing like this

UAE - AbuDhabi UAE - AbuDhabi UAE - AbuDhabi UAE - AbuDhabi UAE - AbuDhabi
Anguilla Anguilla Anguilla Anguilla Anguilla
UAE - Ajman UAE - Ajman UAE - Ajman UAE - Ajman UAE - Ajman
Albania Albania Albania Albania Albania
Armenia Armenia Armenia Armenia Armenia
Netherlands Antilles Netherlands Antilles Netherlands Antilles Netherlands Antilles Netherlands Antilles
Angola Angola Angola Angola Angola

I am using paging. using this code it export only one page record only. I need to export all the pages

when I run 30, 000 records, I got an error .
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
0
Manas Mohapatra11y ago
Hi Neel,

There are some functionality which doesn't work in both the browser with same code. So you need to write work around for that like below:

0
neel k11y ago
Thanks for reply, its working in IE but not working in Chrome. I need the code which is works in IE and Chrome.
0
Manas Mohapatra11y ago
Hi,

It will work in FF, Chrome and it will not work IE. For IE please find below code:

// Call this javascript function on button click
function TableToExcel()
{
   alert('called');
   var id = $('[id$="tblExcel"]');
   var strCopy = $('
').html(id.clone()).html(); window.clipboardData.setData("Text",    strCopy);
   var objExcel = new ActiveXObject("Excel.Application");
   objExcel.visible = false; var objWorkbook = objExcel.Workbooks.Add; var objWorksheet =    objWorkbook.Worksheets(1); objWorksheet.Paste; objExcel.visible = true;
}

0

country_ab	country	region_ab	world_area_ab	last_updated	notes_country_ab	parent_country_ab	restriction	LC_id	has_states