PHP excel output with graphic(.jpg, etc)?

[perhapscwk]

I use below to output data to a excel file using PHP,
however, how to include some photo(.jpg) in my excel output?

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=excel.xls");

[Atli]

Hey.

How do you create the Excel file?

[perhapscwk]

html output......the basic method

[Atli]

If you want me to be able to help you modify the output your are sending as your Excel file, I need to actually see the way you are currently creating the output. The code that needs to be modified.

Simply naming the method used to create pretty much every webpage in existence is not exactly helpful.

[perhapscwk]

    header("Content-Type: application/vnd.ms-excel; charset=utf-8");
    header("Content-Disposition: attachment; filename=zzzzz.xls");
    header("Pragme: no-cache");
    header("Expires: 0");    
 
print "<table border='0' cellspacing='5'>";
print "<tr><th>Col A</th><th>Col B</th></tr>";
print "<tr><td><img src="/images/aaaa.jpg"></td><td>Pictures</td></tr>";
print "</table>";

However, when we open the xls, it is not open in same folder of the jpg file,
we can;t see the image.

[Atli]

Ok. Try embedding the image in the HTML tag.

$data = base64_encode(file_get_contents('image.png'));
$imgTag = '<img src="data:image/png;base64,'. $data . '">';
 

[perhapscwk]

not works...i read from online ppl said img not the correct method to embed images in excel..any others suggestion?

[Atli]

I'm not sure exactly how Excel works, but you could try something like PHPExcel. That should allow you to build Excel sheets with embed images.