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:336606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
