How to make excel from different tables on the page and download by button?

Question

PHP

Good afternoon.
I have several tables on the page, tell me how can I click on the button to download all these tables into one excel file?

Here, most likely, JS will be needed (some kind of bible can)?
The bottom line is that there is PHPExcel, I know how to use it, but I want to understand whether it is possible to make such a scheme: I make a

button and bind it to JS, then a request is made to the php file in which this bible works and generates a file, and then the download occurs ( But I need the file not to be saved on the server ).

What is the best way to approach the problem?

Answer 1

For PhpExcel, you need to send the output of the file to the stream

$objPHPExcel->outputHeader("Excel");

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

Answer 2

Find my article on Habré
There is a code for generating excel and look at the comments there is a lot of indignation, but there are also links to solutions.