I tried tweaking the buttons.html5.js successfully to export multiple datatables in to multiple worksheets in single Excel workbook on single click using Datatable export buttons. Before posting the code here, I would like to have it reviewed by Allan to see if it is correct and if yes, can it be included in the future releases for the benefit of the community

/*I've tested exporting 6 datatables to 6 separate worksheets in a single workbook.My Buttons config has an extra option 'multitables' specified for the solution to work which basically has TableId:Sheetname and looks like this:
extend: 'excelHtml5',
multitables:{PL:'Profit',CL:'Liabilities',BS:'Assets',FF:'FundFlow',WC:'WkCap',FP:'FinPos'},
Since there seems to be a limitation on the characters allowed in this message unable to paste the entire contents of file buttons.html5.js, I am pasting the entire class DataTable.ext.buttons.excelHtml5 where the changes have been made. Also changed Relationship Id="rId0" instead of rId2 in excelStrings array which is not pasted here due to limitation on pasting max chars here
*/
//====Start of code pasted from buttons.html5.js===
DataTable.ext.buttons.excelHtml5 = {
className: 'buttons-excel buttons-html5',

@mukeshp Howdy. Before I begin, I'd like to state that I am a beginner JS programmer. Only recently am I becoming aware of the more advanced programming aspects of Datatables. Please bare with me.
I found this piece of code recently and had a couple of questions. I have implemented the DataTable.ext...into buttons.html5.js but I get an error. JS says Datatable is undefined. My first thought was to define Datatable the same way 'p' is defined. In buttons.html5.js, p = e.fn.datatables. However, this also produces an error, stating that jsZip is not defined. I wondered how this error could be corrected?

Second question deals with the setup on the button. Below is the code I currently have and would like to make sure that I set it up correctly per your instructions:

This is how I got this working, in case anyone is having difficulties:

Include the version of buttons.html5.js given by vladslav in the above post in your site (following the main datatables.js file)

Initialise the table extending excelHtml5 to include the multitables option. The multitables option should include an array of the tables you want to export, with the table ID as the key and the value the sheet name as you want it to appear in the Excel export file. eg. here I am exporting tables with ID journalTable, bookTable and databaseTable, which will be exported into worksheets named 'Journals', 'Books' and 'Databases' respectively: