Datatables needs to export tabular data to an excel tabular file containing multiple worksheet

using datatables to display the data as a table has been OK.
also uses excel buttons to export tables to excel files.
but the default exported excel has only one sheet

now you need to export the table data to an excel table file. How to implement including multiple sheet,?

Mar.15,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdda16-30bd9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bdda16-30bd9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?