export datatable data to multiple worksheet in single excel on chrome
export datatable data to multiple worksheet in single excel on chrome
manujain16
Posts: 3Questions: 0Answers: 0
Currently I am using below code to export my datatable data to excel in chrome
var table_html = document.getElementsByClassName("dataTables_scroll")[0].innerHTML.replace(/ /g,'%20');
var data_type = 'data:application/vnd.ms-excel';
a.href = data_type + ', ' + table_html; //setting the file name
a.download = 'exported_table_' + postfix + '.xls'; //triggering the function
a.click();
Now my requirement is to export different datatable data(present in different tabs) to different worksheet of a single excel on single click , can any1 help me on it?I don't mind gettign such feature through tooltable also but it should work on ie and chrome both.
var table_html = document.getElementsByClassName("dataTables_scroll")[0].innerHTML.replace(/ /g,'%20');
var data_type = 'data:application/vnd.ms-excel';
a.href = data_type + ', ' + table_html; //setting the file name
a.download = 'exported_table_' + postfix + '.xls'; //triggering the function
a.click();
Now my requirement is to export different datatable data(present in different tabs) to different worksheet of a single excel on single click , can any1 help me on it?I don't mind gettign such feature through tooltable also but it should work on ie and chrome both.
This discussion has been closed.