How to export html table to excel?

Question

Bitrix24

$file="demo.xls";
        $test="<table  ><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
        header("Content-type: application/vnd.ms-excel");
        header("Content-Disposition: attachment; filename=$file");
        echo $test;

I use this code, but it exports the whole page, how can I make it export what I sent to the file variable?

Answer 1

I suspect that at the end you just need to put exit();

Answer 2

If we are talking about Bitrix24, then for a start it would not be bad not to display the contents of the buffer before calling your code.
This can be done with code:

global $APPLICATION;
$APPLICATION->RestartBuffer();

Then, in order for all this to be read correctly, it is also necessary to prevent the output after this code.
A simplified version of how you can do this:
\CMain::FinalActions();
Thus, your code can be extended to the following result:

global $APPLICATION;
$APPLICATION->RestartBuffer();

$file="demo.xls";
$test="<table  ><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
echo $test;

\CMain::FinalActions();