Flex把datagrid的内容导出到Excel

最新推荐文章于 2022-02-25 20:00:37 发布

iteye_14479

最新推荐文章于 2022-02-25 20:00:37 发布

阅读量96

点赞数

CC 4.0 BY-SA版权

分类专栏： Flex 文章标签： Excel Flex 编程 Flash C

本文链接：https://blog.youkuaiyun.com/iteye_14479/article/details/81921452

Flex 专栏收录该内容

197 篇文章

订阅专栏

本文介绍如何使用Flex将DataGrid中的数据导出至Excel文件。通过自定义函数实现数据收集、格式化并最终保存为Excel文件的过程。适用于希望快速实现此功能的开发者。

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

flex 把datagrid的内容导出到Excel
文章分类:Flash编程

SDK要3.4以上的版本：

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">
<mx:Script>
<![CDATA[
import mx.controls.dataGridClasses.DataGridColumn;
import com.as3xls.xls.Cell;
import mx.collections.ArrayCollection;

import com.as3xls.xls.Sheet;
import com.as3xls.xls.ExcelFile;

private var fileReference:FileReference;
private var xls:Class;
private var sheet:Sheet;

[Bindable]
private var fields:Array = new Array();

[Bindable]
private var ItemDGDataProvider:ArrayCollection = new ArrayCollection([
{name:"Item1",value:"21",qty:"3",cost:"12.21", apples: "1"},
{name:"Item2",value:"20",qty:"4",cost:"12.22", apples: "1"},
{name:"Item3",value:"22",qty:"5",cost:"12.23", apples: "1"},
{name:"Item4",value:"23",qty:"2",cost:"12.24", apples: "1"}
]);

private function fileReference_Cancel(event:Event):void
{
fileReference = null;
}

private function exportToExcel():void
{
sheet = new Sheet();
var dataProviderCollection:ArrayCollection = rebateByItemDG.dataProvider as ArrayCollection;
var rowCount:int = dataProviderCollection.length;
sheet.resize(rowCount + 1,rebateByItemDG.columnCount);
var columns:Array = rebateByItemDG.columns;
var i:int = 0;
for each (var field:DataGridColumn in columns){
fields.push(field.dataField.toString());
sheet.setCell(0,i,field.dataField.toString());
i++;
}

for(var r:int=0; r < rowCount; r++)
{
var record:Object = dataProviderCollection.getItemAt(r);
/*insert record starting from row no 2 else
headers will be overwritten*/
insertRecordInSheet(r+1,sheet,record);
}
var xls:ExcelFile = new ExcelFile();
xls.sheets.addItem(sheet);

var bytes: ByteArray = xls.saveToByteArray();
var fr:FileReference = new FileReference();
fr.save(bytes,"SampleExport.xls");
}
private function insertRecordInSheet(row:int,sheet:Sheet,record:Object):void
{
var colCount:int = rebateByItemDG.columnCount;
for(var c:int; c < colCount; c++)
{
var i:int = 0;
for each(var field:String in fields){
for each (var value:String in record){
if (record[field].toString() == value)
sheet.setCell(row,i,value);
}
i++;
}
}
}
]]>
</mx:Script>
<mx:VBox width="100%" height="100%">
<mx:Form>
<mx:FormItem label="Export Datagrid items to Excel?" fontWeight="bold">
<mx:Form>
<mx:HBox width="100%" verticalAlign="middle">
<mx:DataGrid id="rebateByItemDG" includeInLayout="true" visible="true" dataProvider="{ItemDGDataProvider}" width="100%" editable="true"/>
<mx:Button label="Export To Excel" click="exportToExcel();"/>
</mx:HBox>
</mx:Form>
</mx:FormItem>
</mx:Form>
</mx:VBox>
</mx:Application>