Search code examples
phpphp4

PHP: How to embed image in an excel column generated from PHP?

I am echoing TSV data and turning it into an excel file via header()

This works fine, but 1 of the columns needs to be an image. How can I embed the image as one of the columns?

Thanks!

Solution

  • Well, put simply, you can't. A TSV is a plain text (text/plain) file, not an 'Excel file'. An excel file is a binary representation of a spreadsheet, and although Excel can read a TSV and present it as tabular data, it's not this advanced binary form which can contain images.

    You would have to create a 'proper' Excel xls file using one of the available libraries. I've used PHPExcel in the past and I think it supports adding images.