Export to Excel issue

kartheek

hi, I am new to table tools. I need to have the "export to excel" functionality and found table tools ans awesome utility for this. However when tried use it, it works fine in Chrome and I am facing some issues in IE.

In IE,
1. Header row is displayed at the bottom instead of showing at the to.
2. All the other ata is populated but it shows "Showing 0 to 0 of 0 entries" below the header is displayed.
3. The table is loosing all the formatting (colours etc).

Thanks in advance for your help.

Regards,
Kartheek.

kartheek

THis is my html code.



















$(document).ready( function () {
$('#records').dataTable( {
"sDom": 'T<"clear">lfrtip',
"bJQueryUI": true,
"bPaginate": false,
"oTableTools": {
"sSwfPath": "/media/swf/copy_csv_xls.swf"
}
} );

});



Executed at 9-4-2013 17:54:57
Please enter the as of date (yyyyMMdd)

AS OF DATE:


Export as Excel







Options Expiration Report as of 20130405



TYPE
SECURITY
EXPIRY
QUANTITY
GROUP
UNDERLYING
STRIKE
LAST SPOT
C/P
STYLE
STRIKE %
IN/OUT
FIRST OBSERVATION DATE




AVPO
20486.HK
20130418
108000000.0
D_AI-HK-W-SSO_DW-3988
3988.HK
3.0
3.51
Call
Euro
17.00
IN
20130411



AVPO
20810.HK
20130425
-128000000.0
D_AI-HK-W-SSO_DW-0005
0005.HK
83.88
80.9
Call
Euro
-3.55
OUT
20130418


AVPO
20810.HK-DCM-OTC-CALL
20130425
316000.0
D_AI-HK-W-SSO_DW-W-0005
0005.HK
83.88
80.9
Call
Euro
-3.55
OUT
20130418