How to pass link to CSV using PHP?

Question

PHP

Creating a CSV file using PHP

$File = fopen('php://output', 'w');
ob_start();
fputs($File, chr(0xEF) . chr(0xBB) . chr(0xBF)); // BOM
fputcsv($File, ['Ссылка 1', 'Сылка2'],";");
fclose($File);
$sCsv = ob_get_contents();
ob_end_clean();
header("Content-type: text/csv");
        header('Content-Disposition: attachment; filename="file.xls"');
        header("Pragma: no-cache");
        header("Expires: 0");
echo $sCsv;

I can not send the link as in the screenshot below

Answer 1

CSV is a simple text format, it doesn't do that.
Look in the direction of XLSX and PhpOffice: https://phpspreadsheet.readthedocs.io/en/latest/
PS instead of php://output , it's better to use php://temp , then you won't have to mess with the buffer

Answer 2

fputcsv($File, ['=HYPERLINK("https://qna.habr.com/q/848207","Сылка1")', 'Сылка2'],";");

Answer 3

CSV is a simple text format, it doesn't do that.

including it all depends on the program in which the csv file is opened + links must be absolute, i.e.http://host.name/path/