Flex(ActionScript)导出到Excel

来源:互联网 发布:应聘淘宝外包客服 编辑:程序博客网 时间:2024/05/18 19:39

使用开源项目as3xlsUTF8.swc。下载地址:打开链接

private var sheet:Sheet = new Sheet();/** * 导出到Excel */ protected function exportToExcel(e:MouseEvent):void{//在前台生成Excelvar excelFile:ExcelFile = new ExcelFile();var arr:Array = iGrid.selectedItems as Array;excelFile.sheets.addItem(generateSheet1());for(var i:int=0; i<arr.length;++i){var obj:Object = arr[i];var j:int = 0;for(var key:String in obj){excelFile.sheets.addItem(generateSheet(i,j+8,obj[key]));++j;}}var arrBytes:ByteArray = excelFile.saveToByteArray();var file:FileReference = new FileReference();try{file.save(arrBytes,"我的日报明细.xls");}catch(e:Error){Alert.show("导出失败,详情如下: "+e.toString(),"系统提示");}}/** * 生产Excel Sheet表 */ protected function generateSheet(i:int,j:int,o:Object):Sheet{if(!sheet){sheet = new Sheet();sheet.resize(10,10);}sheet.setCell(i,j,String(o));return sheet;}



原创粉丝点击