datagrid 导出到Excel

 

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
                           xmlns:s="library://ns.adobe.com/flex/spark"
                           xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600">
        <s:layout>
                <s:BasicLayout/>
        </s:layout>
        <fx:Script>
                <![CDATA[
                        import mx.collections.ArrayCollection;
                        [Bindable]
                        private var dpADG:ArrayCollection = new ArrayCollection([
                                {Artist:'成龙', Album:'Slanted and Enchanted', Price:12.99},
                                {Artist:'Pavement', Album:'Brighten the Corners', Price:13.99},
                                {Artist:'Saner', Album:'A Child Once', Price:14.99},
                                {Artist:'Saner', Album:'Helium Wings', Price:12.99},
                                {Artist:'The Doors', Album:'The Doors', Price:10.99},
                                {Artist:'The Doors', Album:'Morrison Hotel', Price:12.99},
                                {Artist:'Grateful Dead', Album:'American Beauty', Price:11.99},
                                {Artist:'Grateful Dead', Album:'In the Dark', Price:17.99},
                                {Artist:'Grateful Dead', Album:'Shakedown Street', Price:13.99},
                                {Artist:'The Doors', Album:'Strange Days', Price:12.99},
                                {Artist:'The Doors', Album:'The Best of the Doors', Price:10.99}
                        ]);

                        // 先搞 1 个 FileReference
                        private var file:FileReference = new FileReference();
                        protected function Excel_clickHandler(event:MouseEvent):void
                        {
                                var testStr:String;
                                var ExcelStr:Array = [];
                                if(dpADG!=null){
                                        for each(var obj:Object in dpADG){
                                                testStr = obj.Artist+","+obj.Album+","+obj.Price;
                                                ExcelStr.push(testStr);
                                        }
                                       
                                }
                               
                                file.save(ExcelStr.join("\r\n"),"hahaha.csv");
                        }

                ]]>
        </fx:Script>
        <fx:Declarations>
                <!-- 将非可视元素（例如服务、值对象）放在此处 -->
        </fx:Declarations>
        <mx:DataGrid dataProvider="{dpADG}" x="75" y="80" height="183">
                <mx:columns>
                        <mx:DataGridColumn dataField="Artist"/>
                        <mx:DataGridColumn width="150"  dataField="Album"/>
                        <mx:DataGridColumn  dataField="Price"/>
                </mx:columns>
        </mx:DataGrid>
        <s:Button x="307" y="51" label="Excel..." click="Excel_clickHandler(event)" id="Excel"/>
       
</s:Application>