Flex中生成Excel

来源：互联网发布：网络舆情监测员工资编辑：程序博客网时间：2024/05/19 16:38

场景：

flex生成Excel并保存到本地

要求：

[1] as3xls.swc 下载

[2] flash player 10及以上

代码：（FlashBuilder4.0）

<?xml version="1.0" encoding="utf-8"?><s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"   xmlns:s="library://ns.adobe.com/flex/spark"   xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600"><fx:Script><![CDATA[import com.as3xls.xls.ExcelFile;import com.as3xls.xls.Sheet;private function exportExcel():void {var excelFile:ExcelFile = new ExcelFile();var sheet:Sheet = new Sheet();sheet.resize(10, 10);sheet.setCell(0, 0, "Today's date:");sheet.setCell(0, 1, new Date());excelFile.sheets.addItem(sheet);var mbytes:ByteArray = excelFile.saveToByteArray();var filerefer:FileReference = new FileReference();filerefer.save(mbytes,"demo.xls");}]]></fx:Script><s:Button x="219" y="161" label="生成Excel" click="exportExcel()"/></s:Application>