SunshineDataGrid动态title和具有excel导出(无需jsp支持)

   近日要做flex的DataGride遇到很多郁闷的事情，title是静态的，每次都要写一次title，用起来感觉不方便，重要的数据希望可以导出到excel，但是里面又没现成的方法，我搜索了一下，发现很多人都是用jsp辅助导出，我觉得不实际，常出现乱码。我就修改了一下，用了flex内置的方法实现了相关功能。

 

源代码:

<?xml version="1.0" encoding="utf-8"?> <!-- viruscodecn@gmail.com --> <mx:DataGrid xmlns:mx="http://www.adobe.com/2006/mxml" creationComplete="initDataGrid()"> <mx:Script> <!--[CDATA[ import mx.controls.dataGridClasses.DataGridColumn; import mx.controls.Alert; /* *<value><data><ename></ename><cname></cname></data></value> */ [Bindable] public var titleXml:XML; public var downloadPolicy:String="off"; private function initDataGrid():void { var titleArray:Array=new Array; for each (var xml:XML in titleXml.data) { var dataGridColumn:DataGridColumn=new DataGridColumn; dataGridColumn.dataField=XML(xml.ename).toString(); dataGridColumn.headerText=XML(xml.cname).toString(); titleArray.push(dataGridColumn); } this.columns=titleArray; initRightContext(); } //空白处右键 private function initRightContext():void { var contextMenu:ContextMenu=new ContextMenu(); contextMenu.hideBuiltInItems(); if (downloadPolicy == "on") { var saveExcelContextMenuItem:ContextMenuItem=new ContextMenuItem("导出为Excel"); saveExcelContextMenuItem.addEventListener(ContextMenuEvent.MENU_ITEM_SELECT, saveExcel); contextMenu.customItems.push(saveExcelContextMenuItem); } this.contextMenu=contextMenu; } private function saveExcel(event:ContextMenuEvent):void { //loadDGInExcel(this, 'http://127.0.0.1:8080/SaleSystem/services/ExcelExport.jsp'); loadDGInExcelBySave(this); } ]]> </mx:Script> <mx:Script> <![CDATA[ /** * Simple script to convert a Datagrid to a HTML table and then * pass it on to an external excel exporter * */ //Libs that are mostly used //(only a number are necessary for the datagrid conversion and export) import flash.errors.*; import flash.events.*; import flash.external.*; import flash.net.URLRequest; import flash.net.URLVariables; /** * Convert the datagrid to a html table * Styling etc. can be done externally * * @param: dg Datagrid Contains the datagrid that needs to be converted * @returns: String */ private function convertDGToHTMLTable(dg:DataGrid):String { var font:String=dg.getStyle('fontFamily'); var size:String=dg.getStyle('fontSize'); var str:String=''; var colors:String=''; var style:String='style="font-family:' + font + ';font-size:' + size + 'pt;"'; var hcolor:Array; if (dg.getStyle("headerColor") != undefined) { hcolor=[dg.getStyle("headerColor")]; } else { hcolor=dg.getStyle("headerColors"); } str+='<table width="' + dg.width + '" border="1"><thead><tr width="' + dg.width + '" style="background-color:#' + Number((hcolor[0])).toString(16) + '" mce_style="background-color:#' + Number((hcolor[0])).toString(16) + '">'; for (var i:int=0; i < dg.columns.length; i++) { colors=dg.getStyle("themeColor"); if (dg.columns[i].headerText != undefined) { str+="<th " + style + ">" + dg.columns[i].headerText + "</th>"; } else { str+="<th " + style + ">" + dg.columns[i].dataField + "</th>"; } } str+="</tr></thead><tbody>"; colors=dg.getStyle("alternatingRowColors"); for (var j:int=0; j < dg.dataProvider.length; j++) { str+="<tr width=/"" + Math.ceil(dg.width) + "/">"; for (var k:int=0; k < dg.columns.length; k++) { if (dg.dataProvider.getItemAt(j) != undefined && dg.dataProvider.getItemAt(j) != null) { if (dg.columns[k].labelFunction != undefined) { str+="<td width=/"" + Math.ceil(dg.columns[k].width) + "/" " + style + ">" + dg.columns[k].labelFunction(dg.dataProvider.getItemAt(j), dg.columns[k].dataField) + "</td>"; } else { str+="<td width=/"" + Math.ceil(dg.columns[k].width) + "/" " + style + ">" + dg.dataProvider.getItemAt(j)[dg.columns[k].dataField] + "</td>"; } } } str+="</tr>"; } str+="</tbody></table>"; return str; } private function loadDGInExcelBySave(dg:DataGrid):void { var ba:ByteArray=new ByteArray; ba.writeUTF(convertDGToHTMLTable(dg)); var _fileRef:FileReference=new FileReference(); _fileRef.save(ba, "data.xls"); //保存到磁盘，会出现个系统保存对话框。 ba.clear(); } ]]--> </mx:Script> </mx:DataGrid>

 

应该使用比较简单，如果大家使用有什么问题可以在线联系我