Converting Flex 3 Datagrid to Excel Sheet
Filed under CFC , ColdFusion , Flex
I was posed with the problem of converting flex 3 datagrids from a dashboard to an excel sheet. I came across some really good blog posts that explain how to accomplish this task. The best one can be found here.
The person has it set up in actionscript calling a .php page but I wanted to supply the simple ColdFusion code for us ColdFusion nerds. All you need to do is direct the actionscript to a coldfusion page containing the code below and it should work.
<cfcontent type=”application/msexcel”>
<cfheader name=”Content-Disposition” value=”filename=export.xls”>
<cfoutput>
#form.htmltable#
</cfoutput>
This little flex 3 script makes lots of managers very happy! My next adventure will be printing flex 3 datagrids and graphs into a nice looking report which seems to be posing a little challenge for me, the nice looking part that is ;)
Sep19