Question

161

Create simple xlsx (excel file ) from javascript or Jquery

rated 0 times [ 162] [ 1] / answers: 1 / hits: 38314 / 7 Years ago, wed, june 7, 2017, 12:00:00

This is the fiddle https://jsfiddle.net/ym4egje0/

I have two things to ask

this is creating a xls , how to create a xlsx file and it does not work in IE , only works in google chrome , how to make it work in IE ?

I want to put ColumnHead column header text and message1 and message2 should be consecutive rows .

Have to take as the index of (.) to cut into rows .

HTML

<input id=btnExport type=button value = Generate File />

JS/Jquery

$(#btnExport).click(function (e) { 



var ColumnHead = Column Header Text;

var Messages = n message1.n message2.;

   window.open('data:application/vnd.ms-excel,' + Messages);

    e.preventDefault();



});

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

eliezerc

Add To Favorites

Follow

Total Points: 286

Total Questions: 102

Total Answers: 102

Location: Federated States of Micronesia

Member since Sun, May 16, 2021

3 Years ago

eliezerc questions

1 Carousel slideshow with infinite loop

Mon, Jun 20, 22, 00:00, 2 Years ago

1 How to populate select options from an Api call in React js on page load

Thu, May 19, 22, 00:00, 2 Years ago

1 Typescript and Mongoose: Property 'x' does not exist on type 'Document'

Fri, Oct 30, 20, 00:00, 4 Years ago

1 MUI - How to open Dialog imperatively/programmatically

Fri, Sep 4, 20, 00:00, 4 Years ago

1 Cannot read property 'includes' of null

Fri, Jul 3, 20, 00:00, 4 Years ago

View All

answered 7 Years ago carolynt · Accepted Answer

Check out this fiddle to solve your problem . it will create file for both Google chrome and IE

https://jsfiddle.net/shaswatatripathy/fo4ugmLp/1/

HTML

<input type=button id=test onClick=fnExcelReport(); value=download />



<div id='MessageHolder'></div>



<a href=# id=testAnchor></a>

JS

var tab_text;

var data_type = 'data:application/vnd.ms-excel';





function CreateHiddenTable(ListOfMessages)

{

var ColumnHead = Column Header Text;

var TableMarkUp='<table id=myModifiedTable class=visibilityHide><thead><tr><td><b>'+ColumnHead+'</b></td>  </tr></thead><tbody>';



for(i=0; i<ListOfMessages.length; i++){

    TableMarkUp += '<tr><td>' + ListOfMessages[i] +'</td></tr>';

}

TableMarkUp += </tbody></table>;

$('#MessageHolder').append(TableMarkUp);

}



function fnExcelReport() {

var Messages = n message1.n message2.;

var ListOfMessages = Messages.split(.);



CreateHiddenTable(ListOfMessages);



    tab_text = '<html xmlns:x=urn:schemas-microsoft-com:office:excel>';

    tab_text = tab_text + '<head><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>';



    tab_text = tab_text + '<x:Name>Error Messages</x:Name>';



    tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';

    tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';



    tab_text = tab_text + <table border='1px'>;

    tab_text = tab_text + $('#myModifiedTable').html();;

    tab_text = tab_text + '</table></body></html>';



    data_type = 'data:application/vnd.ms-excel';



    var ua = window.navigator.userAgent;

    var msie = ua.indexOf(MSIE );



    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv:11./)) {

        if (window.navigator.msSaveBlob) {

            var blob = new Blob([tab_text], {

                type: application/csv;charset=utf-8;

            });

            navigator.msSaveBlob(blob, 'Test file.xls');

        }

    } else {

    console.log(data_type);

console.log(tab_text);

      $('#testAnchor')[0].click()

    }

$('#MessageHolder').html();

}

$($(#testAnchor)[0]).click(function(){

console.log(data_type);

console.log(tab_text);

  $('#testAnchor').attr('href', data_type + ', ' + encodeURIComponent(tab_text));

        $('#testAnchor').attr('download', 'Test file.xls');

});

CSS

.visibilityHide

{

  visibility:hidden;

}