mysql - Export Each Table into Separate Sheet in Excel Workbook in PHP

Question

I need to create a download page where the user can select the month and year to download all defined tables into one workbook, where each table is in a separate sheet.

Tables

Act
Up
chargebacks
services

Table Structure

Agent ID    Agent Name  Tran Year   Tran Period Original Mobile ID  Mobile ID   Device ID   Account Number  Customer Name   Device Change Date  New Device Contract Begin Date  New Device Contract End Date    Access Charge   Contract Term   Model   Alt Mobile ID   Previously Activated Equip  Installment Contract     Purchased Receivable    Agent SS   Previous Price Plan  Previous Access Charge      Kicker Eligible     DPA Service Fee2    Commission Amount2      Additional Commission Amount2   SPIFF Amount2 

I am currently using datatables to display the results to the user and they can download each page easily and that is working. I have a request from all users to be able to click a button to download all the data at once based on the month and year, or Tran Year and Tran Period. This will also be based off of the Agent ID. So if agent 100 is logged in it will only download their data.

Where and what am I looking for to accomplish this? Not asking for the work to be done, just a guide or a jumping off point.

question from:https://stackoverflow.com/questions/66049382/export-each-table-into-separate-sheet-in-excel-workbook-in-php

Answer 1

Waitting for answers