Re: writing Excel files through PHP

Use full uri. But the user needs to be online while viewing the xls file. Other option is to create web archive. It's a mime encoded file, save an excel file with an embeded image and you will see what it is. Binay wrote:

Hi all, I m generating an Excel file though PHP by sending the appropriate header and then using HTML <TD> tags to write data in different cells. Below is my code snippet. It has got 1 problems: 1. Image doesn't come/showup in Excel sheet. <?php header("Content-type: application/vnd.ms-excel"); header("Content-disposition: attachment; filename=pareto_combined.xls"); ?> <tr colspan=8> <td height=50> <img src='../../../extra/images/log.jpg'></td> <td align=right><img src='../../../extra/images/mickey_sup.jpg'></td> </tr> <?php $dateF=$_REQUEST['dateF']; $dateT=$_REQUEST['dateT']; $agentID=$_REQUEST['agentID']; <tr> <td class='graybg'><?php echo $agentID</td> <td class='graybg'><?php echo $dateF</td> <td class='graybg'><?php echo $dateT</td> </tr> ?> now after saving the Excel file it displays all alphanumeric data correctly but images do not show up. i think Img tag is not supported by Excel application. So my question is how can i display the images in Excel using PHP? plz help me out Thanks in advance Binay