Breaking News: Grepper is joining You.com. Read the official announcement!

export table data to excel using javascript or jquery

Add Answer

Clean Cat answered on January 14, 2021 Popularity 9/10 Helpfulness 3/10

answer export table data to excel using javascript or jquery

related jquery export data of table to excel

related Export html table data to Excel using JavaScript

related export table data to excel in jquery

related export table to excel jquery

related export table to excel javascript

export table data to excel using javascript or jquery

Comment

function exportTableToExcel(tableID, filename = ''){
    var downloadLink;
    var dataType = 'application/vnd.ms-excel';
    var tableSelect = document.getElementById(tableID);
    var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');
    
    // Specify file name
    filename = filename?filename+'.xls':'excel_data.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();
    }
}

Popularity 9/10 Helpfulness 3/10 Language javascript

Source: www.codexworld.com

Tags: excel export javascript jquery using

Link to this answer
Share Copy Link

Contributed on May 29 2022

Clean Cat

0 Answers Avg Quality 2/10

Closely Related Answers

jquery export data of table to excel

Comment

//import this lib in your html 
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js"></script>
//the use this function 
function exportTableToExcelXlsx(tableID = 'data-table-responsive', filename = '') {
    var tableSelect = document.getElementById(tableID);
    var ws = XLSX.utils.table_to_sheet(tableSelect);
    var wb = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
    XLSX.writeFile(wb, filename || 'excel_data.xlsx');
}

Popularity 8/10 Helpfulness 5/10 Language javascript

Source: Grepper

Tags: excel export e

Link to this answer
Share Copy Link

Contributed on Oct 25 2023

MohammadMark

0 Answers Avg Quality 2/10

Export html table data to Excel using JavaScript

Comment

function fnExcelReport()
{
    var tab_text="<table border='2px'><tr bgcolor='#87AFC6'>";
    var textRange; var j=0;
    tab = document.getElementById('headerTable'); // id of table

    for(j = 0 ; j < tab.rows.length ; j++) 
    {     
        tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
        //tab_text=tab_text+"</tr>";
    }

    tab_text=tab_text+"</table>";
    tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
    tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
    tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params

    var ua = window.navigator.userAgent;
    var msie = ua.indexOf("MSIE "); 

    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
    {
        txtArea1.document.open("txt/html","replace");
        txtArea1.document.write(tab_text);
        txtArea1.document.close();
        txtArea1.focus(); 
        sa=txtArea1.document.execCommand("SaveAs",true,"Say Thanks to Sumit.xls");
    }  
    else                 //other browser not tested on IE 11
        sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));  

    return (sa);
}

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Feb 01 2022

Tender Tamarin

0 Answers Avg Quality 2/10

export table data to excel in jquery

Comment

$( document ).ready(function() {
	$(".export").click(function() {
		var export_type = $(this).data('export-type');		
		$('#data_table').tableExport({
			type : export_type,			
			escape : 'false',
			ignoreColumn: []
		});		
	});
});

Popularity 10/10 Helpfulness 4/10 Language javascript

Source: www.phpzag.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Jan 14 2021

Uninterested Unicorn

0 Answers Avg Quality 2/10

export table to excel jquery

Comment

view source
1
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
2
<script src="src/jquery.table2excel.js"></script>

Popularity 8/10 Helpfulness 4/10 Language javascript

Source: www.jqueryscript.net

Tags: excel export expo

Link to this answer
Share Copy Link

Contributed on Nov 30 2022

Birame Moussa DIOUF

0 Answers Avg Quality 2/10

export table to excel javascript

Comment

function exportTableToExcel(tableId, filename = 'table') {
  let downloadLink;
  const dataType = 'application/vnd.ms-excel';
  const table = document.getElementById(tableId);
  const tableHTML = table.outerHTML.replace(/ /g, '%20');

  // Create download link element
  downloadLink = document.createElement('a');
  document.body.appendChild(downloadLink);

  if (navigator.msSaveOrOpenBlob) {
    const blob = new Blob(['\ufeff', tableHTML], {
      type: dataType
    });
    navigator.msSaveOrOpenBlob(blob, `${filename}.xls`);
  } else {
    // Create a link to the file
    downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

    // Setting the file name
    downloadLink.download = `${filename}.xls`;

    // Simulating click to trigger the download
    downloadLink.click();
  }
  
  document.body.removeChild(downloadLink);
}

// Usage: Call the exportTableToExcel function with the table id as the first argument
exportTableToExcel('myTable', 'table_filename');

Popularity 7/10 Helpfulness 2/10 Language javascript

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

export table data to excel using javascript or jquery

Contents

More Related Answers

export table data to excel using javascript or jquery

Closely Related Answers

jquery export data of table to excel

Export html table data to Excel using JavaScript

export table data to excel in jquery

export table to excel jquery

export table to excel javascript

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.