Flex导出Excel方法与乱码解决.docVIP

原理是把DataGrid中的数据发送到Server端，然后通过Jsp中的 attachment; filename=VD.xls 和 contentType=application/msexcel; charset=UTF-8 使其返回EXCEL 代码有一个问题，因为我在DataGrid中有过滤的，当DataGrid为全量数据的时候，导出的Excel没有问题，但是当过滤一部分数据的时候，导出的Excel就是乱码了的。解决办法是把设置response.setCharacterEncoding(GBK); 大概是Excel不懂UTF-8吧 先把Flex端的代码如下： Flex代码： var excelURL:String = http://localhost:8080/FlexApp/toExcel.jsp; mx:Button label=导出EXCEL id=loadExcel click=loadDGInExcel(dg,excelURL)/ ActionScript代码： import mx.controls.DataGrid; private function convertDGToHTMLTable(dg:DataGrid):String { //Set default values var str:String = ; //Set the htmltabel based upon knowlegde from the datagrid str+= table border=1theadtr; //Set the tableheader data (retrieves information from the datagrid header for(var i:int = 0;idg.columns.length;i++) { if(dg.columns[i].headerText != undefined) { str+=th+dg.columns[i].headerText+/th; } else { str+= th+dg.columns[i].dataField+/th; } } str += /tr/theadtbody; //Loop through the records in the dataprovider and //insert the column information into the table for(var j:int =0;jdg.dataProvider.length;j++) { str+=tr; for(var k:int=0; k dg.columns.length; k++) { //Do we still have a valid item? if(dg.dataProvider.getItemAt(j) != undefined dg.dataProvider.getItemAt(j) != null) { if(dg.columns[k].labelFunction != undefined) { str += td+dg.columns[k].labelFunction(dg.dataProvider.getItemAt(j),dg.columns[k].dataField)+/td; } else { str += td+dg.dataProvider.getItemAt(j)[dg.columns[k].dataField]+/td; } } } str += /tr; } str+=/tbody/table; return str; } private function loadDGInExcel(dg:DataGrid,url:String):void { //Pass the htmltable in a variable so that it can be delivered //to the backend script var variables:URLVariables = new URLVariables(); variables.htmltable = convertDGToHTMLTable(dg); //Setup a new request and make sure that we are //sending the data through a post var u:URLRequest = new URLRequest(url);