Flex(ActionScript)导出到Excel
发布时间:2020-12-15 04:21:45 所属栏目:百科 来源:网络整理
导读:使用开源项目as3xlsUTF8.swc。下载地址:打开链接 private var sheet:Sheet = new Sheet();/** * 导出到Excel */ protected function exportToExcel(e:MouseEvent):void{//在前台生成Excelvar excelFile:ExcelFile = new ExcelFile();var arr:Array = iGrid.
使用开源项目as3xlsUTF8.swc。下载地址:打开链接 private var sheet:Sheet = new Sheet(); /** * 导出到Excel */ protected function exportToExcel(e:MouseEvent):void { //在前台生成Excel var 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; } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |