Flex中生成Excel

场景：

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>