Excel(.xlsx) Export

[Raghuram0106]

Hi Team,

I have a query regarding handsontable. Does it support excel(.xlsx) file export?

Thanks
Raghu

[AMBudnik]

Currently you are able to export the Handsontable as a .csv (it's read from Excel but it's not .xlxs).
This feature is already on our Roadmap https://trello.com/c/kdRiEcVp/16-export-to-xls-pdf-xml-html
You can vote for this feature if you would like it to be our next task.

[lucashtc]

Unfortunately it has not been added yet, but anyone viewing this issue helps by voting for a new feature.

[alisham3]

handsontable roadmap hasn't been updated in 3 months - do we know if it's even accurate?

[AMBudnik]

Hi @alisham3

we are working on Zenhub now. The correct path to the project is https://app.zenhub.com/workspace/o/handsontable/handsontable/boards?repos=1790564,85198294

[alisham3]

can you then please close the trello board OR post that it's outdated as the first card? you're confusing customers with differing roadmaps

…

On Mon, Aug 13, 2018 at 4:51 PM Aleksandra Budnik ***@***.***> wrote: Hi @alisham3 <https://github.com/alisham3> we are working on Zenhub now. The correct path to the project is https://app.zenhub.com/workspace/o/handsontable/handsontable/boards?repos=1790564,85198294 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#3685 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AH-u0GfQ3wNhzBeGK63_6ZYL_Ncy3-9Yks5uQT4cgaJpZM4JZTnU> .

-- Alisha Manandhar University of California, Berkeley - 2013 Bachelor of Science: Bioengineering | Minor: South and Southeast Asian Studies Certificate in Management of Engineering & Innovation

[AMBudnik]

We still use Trello to gather votes for features on the Backlog but I will ask our CTO to change the Info part.

[michelebarzan]

Here's what i did to export to .xls
`function xlsExport(hot,filename)
{
var colHeader=hot.getColHeader();
var data=hot.getData();

    var exportDiv=document.createElement("div");
    exportDiv.setAttribute("style","display:none");

    var exportTable=document.createElement("table");
    exportTable.setAttribute("id","hotExportTable");

    var tr=document.createElement("tr");
    colHeader.forEach(function(column)
    {
        var th=document.createElement("th");
        th.innerHTML=column;
        tr.appendChild(th);
    });
    exportTable.appendChild(tr);

    data.forEach(function(row)
    {
        var tr=document.createElement("tr");
        row.forEach(function(cell)
        {
            var td=document.createElement("td");
            td.innerHTML=cell;
            tr.appendChild(td);
        });
        exportTable.appendChild(tr);
    });

    exportDiv.appendChild(exportTable);
    document.body.appendChild(exportDiv);

    $("#hotExportTable").table2excel
    ({
        exclude: ".noExl",
        filename
    });

    document.getElementById("hotExportTable").remove();
}`