In the code, $datatype is globally defined:

$datatype = {
    Table: 1
    , Json: 2
    , Xml: 3
    , JqGrid: 4
}

It would be better to reference it in the settings using the $datatype key:

$("#tblExport").btechco_excelexport({
    containerid: "tblExport"
    , datatype: 'Table'
});

Then in the plugin change the switch:

    var $datatype = {
        table: 1
        , json: 2
        , xml: 3
        , jqgrid: 4
    };

    // .....
    function Initialize() {
        BuildDataStructure();

        var type = $datatype[ $settings.datatype.toLowerCase() ] || 'table';
        switch (type) {
            // ...
        }
    // ...
    }

Hi Tarun,

Greetings from my side. Hope you are doing well.
Actually in previous version we just call the excelexportjs function with containerd ID and other attributes and it works perfectly but here i am not getting why you define column and row data in readme file so can you please help me how can i use this javascript file to export my table with some id.
Please revert me back as this is on higher priority for me.

Thanks Tarun.
I look forward to hear form you.

Kapil
([email protected])

It seems Excel Viewer 2007 doesn't handle file generated with this script. Is it just a fault of Excel Viewer, or is this the fault of badly formatted XLS file?

Please , i want know, can i add any column in run time

while exporting to excel,if td contains number like '050123' then the number is changing to '50123'.
Its neglecting left side zero, even though we set datatype: "string".
Please help me out.

Hi there,

it works just great but there's one problem when I open it in Excel the data is in bold.

Do you know any workaround for that?

thank you.

ie still widely used. why not supported?

Hello

I`ve been trying to use your tool to map an excel file using AngularJs

the problem is the same as i saw in one of the closed issues: i have a field with 004 .. (i`m sending 004 from back-end) and the excel displays 4 if the column is formated as stardard. somehow i have to make the whole column format as text.

here is the code from the report.controller.js:

$('#releaseAddBtn').on('click', function () {
    $('#dvjson').excelexportjs({
                containerid: 'dvjson',
                datatype: 'json',
                dataset: vm.data,
                dataformat: 'string',
                columns: vm.getColumns() 
            });
});    

vm.getColumns = function(){
    var completeColumns = [];
    var values = vm.allReporttyp[vm.selectedReport].fields ;
    var headers = vm.allReporttyp[vm.selectedReport].headers;
    
    for(var q = 0; q < headers.length; q++) {
        var obj = {};
        obj['headertext'] = headers[q];
        obj['datatype'] = 'string';
        obj['datafield'] = values[q];
        completeColumns.push(obj);
    }

    return completeColumns;
};

}

i saw the C# code but unfortunately id does not help me, as my app is made with js and angularjs. Maybe you could give me a hand.
Thank you

has any one try this for rtl direction of grdiview i add the style=direction:rtl on js but can't get the result any one ?

Large data(50000 row) issue on chrome. Working fine on firefox and ie.

A new window opens after clicking on EXPORT button, but with blank screen.

When exporting JSON the column headers param is required. In my opinion it should be optional. There is no error, file opens up empty after downloaded when columns are missing.

The excel displays columns with style='display:none'. Please help.

I see that in the examples that you have provided, the json, xml version have used the 'isHidden' property. How can i achieve the same for normal tables?

Hi Tarun,
I'm trying to export json data in excel sheet, one of my column contains html code for each row, when I download this data then excel does not show me html code but instead it shows formatted html data and data get splitted in multiple rows.

Can you pleaese let me know is there any way we can download the html code which can be confined to single cell instead of many.

Regards,
Praveen Agarwal

When the table data's are larger the chrome browser shows Aw Snap !! error.But it works fine in firefox. whether it is a browser problem or code..Whether i need to change any code to support unlimted data...

Hello,

This plugin does not support multiple worksheets. I does have a requirement in which I have 3 table and needs to export them into three different worksheets within single excel file.

Please let me know if you are able to do it or not.

Thanks in advance.

I need set dinamic name to the file,
don't exist a prop like 'fileName'

Exported data does not handle Special characters (utf-8)

examplejson.html works but thows an error when I try to open the downloaded file:
"The file you are trying to open, 'ihNTD5Wv.xls.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

Using jQuery 1.11.0
Using Windows 7 w/ MS Excel 2010:
Confirmed issue on browsers Firefox 28 & Chrome 34

Include an extra option to allow the developer to have the UIR Base64 encoded string return back to them, which will stop the default behaviour of opening a window (window.open).

This is a workaround a solution to be able to set the file name of the Excel document. The file name would be using the new HTML5 attribute "download" for a elements.

The download attribute is not compatible to Safari, yet. Nor will it work for IE but who cares about IE :).

If you did this:

   var $defaults = {
        containerid: null
        , datatype: $datatype.Table
        , dataset: null
        , columns: null
    , returnuri: false
    };

and this:

        if ($settings.returnuri){
                return uri + base64(format(excelFile, ctx));
            }
            else
            {
                window.open(uri + base64(format(excelFile, ctx)));
            };

Add the following HTML:

<!-- As to be link and not a button--->
<a href="#" download="" id="exportToExcel">Export to Excel</a>

Javascript:

    $("#exportToExcel").on('click', function () {
       var uri =  $("#FinancialYearActualvsKPISummary").btechco_excelexport({containerid: "FinancialYearActualvsKPISummary", 
                                                                             datatype: $datatype.Table,
                                                                             returnuri: true});

       $(this).attr('download','ExportToExcel.xls').attr('href', uri).attr('target','_blank');
    });

There is possibly a better more elegant way of doing this.

Naming the file to download is very difficult. Chrome saves the file as download.xls everytime whereas Firefox gives it a random name. Firefox also doubles up the file extension .xls.xls

You have features that are quite advanced like:
, datatype: $datatype.Json
, dataset: dataobj
, returnUri: true
, columns:....

I suggest a new param called 'filename'.

I have implemented Jquery datatable and I want to use our Export to Excel facility with my datatable gerenrated.
It has works with 1st page of datatable, but not working with formatting and all pages.It is not working properly when I used paging for datatable.Can you please help me into the same.
Thanks

This works perfectly in FF but not in Chrome, Safari, or IE. Any fix for that?

I don´t know if this is the right place, but i want to share a modification that i´ve made to the plugin.

Sometimes, we need to "hide" some columns, from a html table, in exported excel file, ex. A column action buttons from a datagrid. So i´ve made this modification in line 94:

function ConvertFromTable() { var tbl = $('#' + $settings.containerid).clone(); $(tbl).find("td").each(function(){ if($(this).attr("ishidden") == "true" ){ $(this).remove(); } }); var result = $('<div>').append(tbl).html(); return result; }

and add this: ' ishidden="true"' on the column(s) tag that you need to hide.

This will loop all the 'td' tags, and remove those with ishidden="true" property.

Any improvements are aprecciated!

This api does not works on 10000 Json records for export in excell

Dear Developers,
Is there any chance to change download file name to file.xml ?

Best regards,
V7

When exporting, a new tab opens, flashes then closes in Chrome & FF.

Take a look at this alternative library that exports to CSV without the window.open.

No new window or new tab:
http://jsfiddle.net/hybrid13i/JXrwM/

Hi

I tried to use the plugin in IE but it does not work.

is there any work around for that ?

Regards,
Bhavin

Hi, tarunbatta!
Generating excel-file from html-table I get excel-table with rows like if I used style "rowspan='2'" but I do not use it. How to fix this? Thanks beforehand!

I've been trying to make this work on my browser for the past 2 hours but with no success at all... I only have today to test this solution... Can any good soul please help me understand the steps to make this work using regular js with require.js?

i have an account number fields which 18 digits. when i export the report it comes as 1.04006E+16 for actual value of "010400592144000101"

When using a instead of an to trigger.

Maybe this is because returnUri relies on the href attribute?
No error is thrown when using

jsFiddle Test Case:
http://jsfiddle.net/cphill02/cEAh6/

is it possible to output it as landscape?

karl

How do I set the file name?

Tarun,

I used your earlier version and it was quite good and simple to use but today I came here to find out an issue but it seems like you updated it a lot and now it's looking quite complex so can you please provide me a basic example containing How to export from HTML to excel with complete processes because earlier version was quite easy to configure rather the this.
Please help me on high priority for this.
My Email ID-> [email protected]

I look forward to hearing from you.

Kapil

Hi All,

Can anyone please suggest "How to make this "Excel Export" workable in IE and Microsoft Edge Browser ? Because i tried multiple way even by allowing JS and JQuery in Browser but still not working.

Regards,
Kapil

Hi Tarun,
I appreciate what you did and i tried your excel export it's working fine but need your help in some issue..
1.) In Excel default vertical alignment set to bottom but i need center so can you please tell me how to do this ?
2.) Between some rows excel is taking some line gap and that is not in HTML table so how can i get as it is table from HTML.

I look forward to hear from you very soon.

Thanks,
Kapil ([email protected])

there is an error when I try to open your documentation. could you please fix that?

Error export JSON data in Unicode font (Vietnamese).
Please help!
Tks!