Re: writing Excel files through PHP

Hi Marek, Thanks for replying ..I have got few questions based on ur suggestions.. plz find it embedded in your reply. Thanks Binay ----- Original Message ----- From: "Marek Kilimajer" <kilimajer@webglobe.sk> To: "Binay" <binay@oliveinternet.com> Cc: <php-general@lists.php.net> Sent: Saturday, January 10, 2004 6:52 PM 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. +++++++++++++++++++++++++++++ How to create web archvie which will be mime encoded file and then saving as excel file .. plz direct me to the resources where i can find more information about it .. or tell me how can i proceed to it. Thanks +++++++++++++++++++++++++++++ > > 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 > > > > > >