Flex_DataGrid导出excel 两种方式 poi和as3xls.doc

Flex_DataGrid导出excel1. 使用as3xls-1.0.1.SWC包做的Flex界面DateGrid数据导出Excel表格。注意：1.生成的Excel为旧版本，需要微软office才能打开，金山WPS版本不兼容。2.as3xls-1.0.1.SWC解决as3xls-1.0.swc的中文乱码问题，附件提供。附件：支持中文版的as3xls下载地址：as3xls.swc3.现在flex项目上面添加as3xls-1.0.1.SWC库文件，添加步骤如下：第一步：创建as工具类，Util.as,如下：package cy.util import com.as3xls.xls.Cell; import mx.collections.ArrayCollection; import flash.events.*; import .FileReference; import com.as3xls.xls.Sheet; import com.as3xls.xls.ExcelFile; import mx.controls.Alert; import mx.controls.DataGrid; import mx.controls.dataGridClasses.DataGridColumn; import flash.utils.ByteArray; import mx.controls.Alert;public class Utilpublic function Util() /*导出Excel表格函数，参数为DataGrid*/ public static function exportToExcel(myDg:DataGrid):void var fields:Array = new Array(); /*生成表对象sheet*/ var sheet:Sheet= new Sheet(); var dataProviderCollection:ArrayCollection =myDg.dataProvider as ArrayCollection; /*获得表格的行数*/ var rowCount:int = dataProviderCollection.length; /*设置表格的行数(rowCount+1)，列数（myDg.columnCount）*/ sheet.resize(rowCount+1,myDg.columnCount); /*获得DateGrid列的内容*/ var columns:Array = myDg.columns; /*循环设置列名的值*/ var i:int = 0; for each (var field:DataGridColumn in columns) fields.push(field.dataField.toString(); /*第一行的值,取值为myDg的headerText*/ sheet.setCell(0,i,field.headerText.toString(); i+; /*循环设置行的值*/ for(var r:int=0;rrowCount;r+) /*获得dataProviderCollection的每行Item的对象*/ var record:Object =dataProviderCollection.getItemAt(r); /*调用回调函数写入sheet*/ insertRecordInSheet(r+1,sheet,record); /*生成Excel文件*/ var xls:ExcelFile = new ExcelFile(); /*将sheet写入Excel文件中*/ xls.sheets.addItem(sheet); /*将xls对象转换为ByteArray流对象*/ var bytes: ByteArray = xls.saveToByteArray(); /*生成新文件域*/ var fr:FileReference = new FileReference(); /*将bytes流对象保存到文件域*/ fr.save(bytes,SampleExport.xls); /*回调函数*/ function insertRecordInSheet(row:int,sheet:Sheet,record:Object):void var colCount:int = myDg.columnCount; 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列名域值recordfield与value是否相等*/ if (recordfield.toString() = value) /*写入表格中*/ sheet.setCell(row,i,value); i+; 第二步：编写mxml界面 Test.mxml !CDATA Bindable private var dg:Array; Bindable private var fields:Array = new Array(); private function init():void dg=new Array(); for(var i:int=0;i 到此即可完成。2.Flex用poi导出excel，server端struts2，利用poi生成excel：Java代码：public void excel() System.out.println(come on!); HttpServletResponse response = ServletActionContext.getResponse(); try /设置返回类型为excel response.setContentType(application/vnd.ms-excel; charset=UTF-8); /设置返回文件名为aaa.xls response.setHeader(Content-Disposition, filename=aaa.xls); response.setHeader(Cache-Control, no-cache); /利用poi生成excel int index = 1; HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(); HSSFRow row = sheet.createRow(index+); HSSFCell cell = row.createCell(0, HSSFCell.CELL_TYPE_STRING); HSSFRichTextString str = new HSSFRichTextString(1); cell.setCellValue(str); cell = row.createCell(1, HSSFCell.CELL_TYPE_STRING); str = new HSSFRichTextString(2); cell.setCellValue(str); cell = row.createCell(2, HSSFCell.CELL_TYPE_STRING); str = new HSSFRichTextString(3); cell.setCellValue(str); cell = row.createCell(3, HSSFCell.CELL_TYPE_STRING); str = new H