flex导出excel

需要插件 ?as3xls-1.0.1.swc

<?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">
	<fx:Script>  
		<![CDATA[  
			import com.as3xls.xls.ExcelFile;
			import com.as3xls.xls.Sheet;
			
			import mx.collections.ArrayCollection;
			import mx.controls.Alert;
			import mx.controls.CheckBox;  		
			
			[Bindable]  
			private var dp:Array = [  
				{studentID:1,name:"2ssdl",gender:"为001",birthday:"4区",className:"5清道夫却无法"},{studentID:2,name:"2士大",gender:"1色调",birthday:"4却",className:"5为去去"},{studentID:3,name:"2访问",birthday:"飞4",className:"访问5"},{studentID:4,name:"访问2",gender:"0色调",className:"为5"},{studentID:5,name:"2各位",birthday:"4飞",className:"5为"}];  
   
			private function onCreate(dg:DataGrid):void 
			{  
				var rowCount:int = dg.dataProvider.length;
				var colCount:int = dg.columnCount;
				var sheet:Sheet = new Sheet();  
				sheet.resize(rowCount+1,colCount); //设置表格的范围
				var fields:Array = new Array();//用来保存字段 
				for(var i:int=0; i< colCount;i++)
				{      
					sheet.setCell(0,i,dg.columns[i].headerText.toString());//表格第0行设置字段名
					fields.push(dg.columns[i].dataField.toString());
				}
				for(var i:int=0; i< rowCount;i++)
				{  
					var record:Object =dg.dataProvider[i];//获取某行  
					insertRecordInSheet(i+1,sheet,record);  
				}  
				var excelFile:ExcelFile = new ExcelFile();//新建excel文件
				excelFile.sheets.addItem(sheet);//把表格添加入excel文件中
				var mbytes:ByteArray = excelFile.saveToByteArray();     
				var file:FileReference = new FileReference();  
				file.save(mbytes,"测试文件.xls"); // 定死文件名 
				file.addEventListener(Event.COMPLETE,function (){
					Alert.show("保存成功");
				}); 
				/**回调函数**/  
				function insertRecordInSheet(row:int,sheet:Sheet,record:Object):void  
				{   
					for(var c:int; c < colCount; c++)   
					{   
						var i:int = 0;   
						for each(var field:String in fields)  
						{   
							for each (var value:String in record)  
							{   
								/**循环判断myDg列名域值record[field]与value是否相等**/  
								if (record[field].toString() == value)   
									/**写入表格中**/  
									sheet.setCell(row,value);   
							}   
							i++;   
						}   
					}  
				} 
			}   
		]]>  
	</fx:Script>  
	<fx:Declarations>  
		<!-- 将非可视元素（例如服务、值对象）放在此处 -->  
	</fx:Declarations>  	
	<mx:Panel>  
		<mx:Button   label="导出" click="onCreate(myDG)"/>  
		<mx:DataGrid id="myDG" width="100%" rowCount="20" dataProvider="{dp}">  
			<mx:columns>  
				<mx:DataGridColumn headerText="学号" dataField="studentID"/>  
				<mx:DataGridColumn headerText="姓名" dataField="name"/>  
				<mx:DataGridColumn headerText="性别" dataField="gender" width="50"/>  
				<mx:DataGridColumn headerText="生日" dataField="birthday" />  
				<mx:DataGridColumn headerText="班级" dataField="className"/>  
			</mx:columns>  
		</mx:DataGrid>  
	</mx:Panel>
</s:Application>