Export Handsontable to Excel (no csv)

Tags: #<Tag:0x00007f8b28e67390>
#1

I made this code for export handsontable directly to Excel (not a CSV) .
You have just to call function fnExcelReport() on click.
The result is very simple but I think you are able to do better than me.
May be the handsontable team can do something for improve aspect of generated Excel.
Add comment to this thread for propose improvements.

<script>

    // This code export htCore class of Handsontable to Excel.
    // It works with Chrome, Firefox and Edge. Please don't ask about IE ;-P
    // Feel free to use this code and if you like it consider to offer me a coffe
    // Paypal : filippobesana(at)gmail.com


    function toDay() {
        var today = new Date();
        var dd = today.getDate();
        var mm = today.getMonth() + 1; //January is 0!

        var yyyy = today.getFullYear();
        if (dd < 10) {
            dd = '0' + dd;
        }
        if (mm < 10) {
            mm = '0' + mm;
        }
        return dd + '.' + mm + '.' + yyyy;
    }


    function fnExcelReport() {
        var tableClass = 'htCore';
        exportTableToExcel('' + tableClass + '');
    }


    function exportTableToExcel(tableClass) {
        var downloadLink;
        var dataType = 'application/vnd.ms-excel';
        //var tableSelect = document.getElementById(tableID);
        var tableSelect = document.getElementsByClassName(tableClass)[0];
        var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');

        // Specify file name
        var filename = 'Export_' + toDay() +'.xls';

        // Create download link element
        downloadLink = document.createElement("a");

        document.body.appendChild(downloadLink);

        if (navigator.msSaveOrOpenBlob) {
            var blob = new Blob(['\ufeff', tableHTML], {
                type: dataType
            });
            navigator.msSaveOrOpenBlob(blob, filename);
        } else {
            // Create a link to the file
            downloadLink.href = 'data:' + dataType + ', ' + tableHTML;
            // Setting the file name
            downloadLink.download = filename;
            //triggering the function
            downloadLink.click();
        }
    }
</script>
1 Like
#2

Hi @filippobesana

Thank you very much for the suggestion.

#3

When I open the file in excel it says: “The file format and extension of ‘report.xls’ don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?”
is there any work around to avoid this message please ?

#4

Hi @dante.soto

Within the exportToFile plugin there’s a setting called fileExtention https://handsontable.com/docs/javascript-data-grid/export-to-csv/#fileextension-string with the default setup for csv.

#5

Hi Aleksandra.
I have done with an open 3rd party, and it went completely good. super fast and clean PDF files generated with the html ‘htCore’ element. Maybe you can use also in the future.

#6

Generally we try to avoid adding dependencies. But surely other users who are looking for export to PDF can benefit from this knowledge. Thank you very much for sharing.

#7