datagrid 数据导出到 Excel

最新推荐文章于 2021-11-28 12:44:48 发布

Rod_Johson

最新推荐文章于 2021-11-28 12:44:48 发布

阅读量211

点赞数

CC 4.0 BY-SA版权

文章标签： Excel Flex Adobe XML

本文链接：https://blog.youkuaiyun.com/Rod_Johson/article/details/83766894

本文介绍了一个使用Adobe Flex进行数据展示并导出到CSV文件的具体实例。该示例通过DataGrid组件展示了音乐专辑的数据，并提供了一个按钮用于触发导出功能。点击按钮后，DataGrid中的数据将以CSV格式保存到本地。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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">
	<s:layout>
		<s:BasicLayout/>
	</s:layout>
	<fx:Script>
		<![CDATA[
			import mx.collections.ArrayCollection;
			[Bindable]
			private var dpADG:ArrayCollection = new ArrayCollection([
				{Artist:'成龙', Album:'Slanted and Enchanted', Price:12.99},
				{Artist:'Pavement', Album:'Brighten the Corners', Price:13.99},
				{Artist:'Saner', Album:'A Child Once', Price:14.99},
				{Artist:'Saner', Album:'Helium Wings', Price:12.99},
				{Artist:'The Doors', Album:'The Doors', Price:10.99},
				{Artist:'The Doors', Album:'Morrison Hotel', Price:12.99},
				{Artist:'Grateful Dead', Album:'American Beauty', Price:11.99},
				{Artist:'Grateful Dead', Album:'In the Dark', Price:17.99},
				{Artist:'Grateful Dead', Album:'Shakedown Street', Price:13.99},
				{Artist:'The Doors', Album:'Strange Days', Price:12.99},
				{Artist:'The Doors', Album:'The Best of the Doors', Price:10.99}
			]); 

			// 先搞 1 个 FileReference
			private var file:FileReference = new FileReference();
			protected function Excel_clickHandler(event:MouseEvent):void
			{
				var testStr:String;
				var ExcelStr:Array = [];
				if(dpADG!=null){
					for each(var obj:Object in dpADG){
						testStr = obj.Artist+","+obj.Album+","+obj.Price;
						ExcelStr.push(testStr);
					}
					
				}
				
				file.save(ExcelStr.join("\r\n"),"hahaha.csv");
			}

		]]>
	</fx:Script>
	<fx:Declarations>
		<!-- 将非可视元素（例如服务、值对象）放在此处 -->
	</fx:Declarations>
	<mx:DataGrid dataProvider="{dpADG}" x="75" y="80" height="183">
		<mx:columns>
			<mx:DataGridColumn dataField="Artist"/>
			<mx:DataGridColumn width="150"  dataField="Album"/>
			<mx:DataGridColumn  dataField="Price"/>
		</mx:columns>
	</mx:DataGrid>
	<s:Button x="307" y="51" label="Excel..." click="Excel_clickHandler(event)" id="Excel"/>
	
</s:Application>