TableTools - Excel export extension name

TableTools - Excel export extension name

mylokmylok Posts: 8Questions: 0Answers: 0
edited June 2010 in TableTools
The TableTools work great for me, the only problem is when I hit save for excel it show Save as type : All Files(*.*), how can I save as .xls file? Thanks.

Replies

  • Dave177Dave177 Posts: 7Questions: 0Answers: 0
    I have the same problem, with IE only. I'm using Tabletools 2.0 and I'm using sFileName to define a filename with an extension, but no extension shows up in IE. I know to add '.csv' or '.xls' to the filename, but my users don't. Has anyone else had this problem or know of a workaround?

    [code]
    $(document).ready(function() {
    $('#example').dataTable( {
    "sScrollX": "100%",
    "sDom": 'CT<"clear">lfrtip',
    "oTableTools": {
    "sSwfPath": "/swf/copy_cvs_xls_pdf.swf",
    "aButtons": [ "copy",
    {
    "sExtends": "xls",
    "sFileName": "TableTools.csv",
    "bFooter": false
    },
    {
    "sExtends": "pdf",
    "sFileName": "TableTools.csv"
    }
    ]
    },
    "aaSorting": [[1,'asc']],
    "sPaginationType": "full_numbers",
    "bStateSave": true
    } );
    } );

    [/code]
  • max4evermax4ever Posts: 45Questions: 0Answers: 0
    instead of
    [code]
    ...
    "sFileName": "TableTools.csv",
    ...
    [/code]

    use
    [code]
    ...
    "sFileName": "*.xls"
    ...
    [/code]
This discussion has been closed.