?
package com.xxxxxxxx
{
?import mx.controls.DataGrid;
?import mx.controls.dataGridClasses.DataGridColumn;
?import mx.collections.ArrayCollection;
?import mx.collections.XMLListCollection;
?import mx.collections.IList;
?import mx.collections.IViewCursor;
?import mx.collections.CursorBookmark;
?public class DataGridDataExporter
?{
??public static function exportCSV(dg:DataGrid,csvSeparator:String="t",lineSeparator:String="n"):String
??{
???var data:String="";
???var columns:Array=dg.columns;
???var columnCount:int=columns.length;
???var column:DataGridColumn;
???var header:String="";
???var headerGenerated:Boolean=false;
???var dataProvider:Object=dg.dataProvider;
???var rowCount:int=dataProvider.length;
???var dp:Object=null;
???var cursor:IViewCursor=dataProvider.createCursor();
???var j:int=0;
//loop through rows
???while (!cursor.afterLast)
???{
????var obj:Object=null;
????obj=cursor.current;
//loop through all columns for the row
????for (var k:int=0; k < columnCount; k++)
????{
?????column=columns[k];
//Exclude column data which is invisible (hidden)
?????if (!column.visible)
?????{
??????continue;
?????}
?????data+=""" + column.itemToLabel(obj) + """;
?????if (k < (columnCount - 1))
?????{
??????data+=csvSeparator;
?????}
//generate header of CSV,only if it's not genereted yet
?????if (!headerGenerated)
?????{
??????header+=""" + column.headerText + """;
??????if (k < columnCount - 1)
??????{
???????header+=csvSeparator;
??????}
?????}
????}
????headerGenerated=true;
????if (j < (rowCount - 1))
????{
?????data+=lineSeparator;
????}
????j++;
????cursor.moveNext();
???}
//set references to null:
???dataProvider=null;
???columns=null;
???column=null;
???return (header + "rn" + data);
??}
?}
}
?
?
?
前台
//复制datagrid的数据
???private function copyDatagrid():void
???{
????System.setClipboard(DataGridDataExporter.exportCSV(datagrid));//datagrid是DataGrid的id
???}
?
复制按钮 -- click=copyDatagrid
