Export to Excel issue

Export to Excel issue

kartheekkartheek Posts: 2Questions: 0Answers: 0
edited April 2013 in TableTools
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.

Replies

  • kartheekkartheek Posts: 2Questions: 0Answers: 0
    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
This discussion has been closed.