Try inserting a simple image into a blank excel sheet and then save it and open the excel sheet in a text editor. See what the actual code looks like and how they "embed" an image in there.
John -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:15 PM To: CF-Talk Subject: Embedding Images in Excel We have a series of reports which include graphs (via cfchart in .jpg format). We provide the ability to export those reports to Excel. However, if a user saves that excel spreadsheet and opens it later (after CF has cleared the cache), the image has "expired". Primarily, this is because, instead of embedding the actual images in the file, it treats it like an <img> tag and pulls the image from the server each time. But, because CF no longer has that image connection, the chart no longer shows up. In the livedocs, I've seen one work-around that would fix this, where you bascially copy the chart to a new location, so it's not part of the charting cache. But, that would require storing those images, which can quickly eat up space. What I'd like to do, if possible, is actually embed the image inside the Excel file (rather than there just being a link to the image). Is there a way to do that with CF? Some details on our system: 1) 2 load-balanced servers with automatic replication [yes, sticky sessions are on, so it shouldn't be an issue of it looking at the wrong server -- actually, it can be an issue, because when they re-open the file, they may be sent to the other server. But, it's essentially the same as CF clearing its charting cache] 2) CFMX 6.1 on Win2k3. Thanks in advance! Scott -- ----------------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
