You know, I've been struggling with this probelm fr ages, and wouldn't you 
know it, I really over complicated things..
using this simple header method, I've done it...

Cheers for the heads up...
It pays to read eh? ;-)

Tris..





Marek Kilimajer <[EMAIL PROTECTED]> 
10/01/2004 13:22

To
Binay <[EMAIL PROTECTED]>
cc
[EMAIL PROTECTED]
Subject
Re: [PHP] 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 
> 
> 
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




*********************************************************************
The information contained in this e-mail message is intended only for 
the personal and confidential use of the recipient(s) named above.  
If the reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby 
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is 
strictly prohibited. If you have received this communication in error, 
please notify us immediately by e-mail, and delete the original message.
***********************************************************************

Reply via email to