Marc, This seems like the worst possible way of attempting this. The POI library included with CF8 allows you to manipulate native excel documents using java calls from within CF
Check out Ben Nadel's POIUtility.cfc http://www.bennadel.com/projects/poi-utility.htm Rick On Thu, Aug 26, 2010 at 4:56 PM, marc -- <m...@marcbakker.com> wrote: > > Hi, > > recently I wanted to stream an Excel file from the server to a client > browser. Before streaming it to the user, I wanted to replace some > placeholders in the file (like <name>,<place>) with their actual values > (#user.name#,#user.place#). So this was the setup: > > 1 read binary (.xls) template file > 2 read binary data and replace every occurence of the placeholder with it's > actual value > 3 stream the binary data to the client using <cfcontent variable=...> > > This cannot be done without converting the binary Excel data to a text format. > > So I tried BinaryEncode(binaryData,"Hex"). > This gave me the binary data in Hexadecimal format. > Then I translated the placeholder (e.g. "<name>") to it's hex representation. > Then translated the actual value (e.g. "marc") to it's hex representation. > Then I did a ReplaceNoCase(a,b,c) where > a=the binarydata in HEX format, > b=the place holder in hex format, > c=the actual value in hex format > Then I translated a back to binary using ToBinary() > > This didn't work since, as I found out, the hexadecimal value for the place > holder was never found in the converted binary data (in ReplaceNoCase(a,b,c) > ). > > Why is this approach not working? > > Is it possible at all to find and replace text values in an excel file this > way - so without using things like POI utility? > > Btw Translating the file to xml is not an option since it contains graphics > which are not supported in this format. > > I do this in CF 8 on WinXP > > Thanks, > > Marc > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
