sure, wish I could here more on my question though...oh, I'm stuck on Office97 too...hey, we got like 25,000 employees!  LOL!


OK, generally folks just dump plain jane HTML tables and tweak teh content header of the doc like this
<CFHEADER NAME="Content-Disposition" VALUE='Inlinefilename="foo.xls"'>
<cfcontent type="application/vnd.ms-excel">


<table border="1">
  <tr bgcolor="#00FFFF">
    <th>POSNBR</th>
    <th>NAME</th>
    <th>EMPLID</th>
    <th>DESCR</th>
    <th>DISPLAYNAME</th>
<th>img</th>
  </tr>
</table>


alternatively you can dump tab delimed data to...this is somewhat dynamic example...please forgive th euse of evaluate!
FHEADER NAME="Content-Disposition" VALUE='Inlinefilename="execcomplaints.xls"'>
<cfcontent type="application/vnd.ms-excel"><cfoutput>#Replace('#test.columnlist#',',',chr(0009), 'ALL')#</cfoutput>
<cfoutput query="test"><cfloop index="item" list="#test.columnlist#">#evaluate(item)##chr(0009)#</cfloop>
</cfoutput>


Doug

-----Original Message-----
From: Morgan Senkal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:59 AM
To: CF-Talk
Subject: Re: insert image into generated excel excel

Doug, can you post the code that creates the report?  I'll be needing to do something similar soon...I can jump ahead a bit on my project to that point and see if I can help out.  Thanks!

> Ok, I'm creating an excel report via cfcontent/cfheader and HTML
> tables.  The report works fine.  I want to insert a graph produced via
> cfchart.  any ideas?  I'm stumped  No, I'm not going to use COM at all,
> can't.
>
> thanks!
>
> --
> Douglas Knudsen
> Alltel ACI IT Rapid Response Team
> (o) 678-351-6063
> (c) 678-773-5852
>

> <<ole0.bmp>>
>
*********************> *********************************************************************
> The information contained in this message, including attachments, may
> contain
> privileged or confidential information that is intended to be
> delivered only to the
> person identified above. If you are not the intended recipient, or the
> person
> responsible for delivering this message to the intended recipient,
> ALLTEL requests
> that you immediately notify the sender and asks that you do not read
> the message or its
> attachments, and that you delete them without copying or sending them
> to anyone else.
>
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to