在Excel与Flex之间粘贴数据

2种方法，

 

一，利用js读取黏贴版：

 

 

var content = clipboardData.getData("Text");

document.getElementById("${application}").getClipboardData(content);

 

 

二，直接复制到datagrid

 

在DataGrid中，当按下Ctrl键时，我们创建一个隐藏的文本（TextField）组件，并将焦点定位给它，这样，我们就可以接受任何通过Ctrl+V粘贴过来的数据。相应的我们也将DataGrid选择行数据以TSV格式拷贝到TextField组件中，并且将所有的文本选择，这样我们使用Ctrl+C操作就可以复制当前行所有数据了。 
监听隐藏文件组件的textInput事件。如果有任何数据被粘贴的话，那么在这里数据将被解析，并插入到DataGrid中。 
当Ctrl键释放后，移除隐藏的文本组件

 

看例子代码：

 

<?xml version="1.0"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"> <mx:Script> <!--[CDATA[ import flash.events.KeyboardEvent; private function dataGridKeyDownHandler(event:KeyboardEvent):void { if (event.ctrlKey && !dataGrid.getChildByName("clipboardProxy")) { // Add an invisible TextField object to the DataGrid var textField:TextField = new TextField(); textField.name = "clipboardProxy"; dataGrid.addChild(textField); textField.visible = false; textField.type = TextFieldType.INPUT; textField.multiline = true; // Populate the TextField with selected data in TSV format textField.text = getTextFromItems(dataGrid.selectedItems); textField.setSelection(0, textField.text.length - 1); // Listen for textInput event textField.addEventListener(TextEvent.TEXT_INPUT, clipboardProxyPasteHandler); // Set player-level focus to the TextField systemManager.stage.focus = textField; } } private function dataGridKeyUpHandler(event:KeyboardEvent):void { if (!event.ctrlKey) { var textField:TextField = TextField(dataGrid .getChildByName("clipboardProxy")); if (textField) dataGrid.removeChild(textField); } } private function clipboardProxyPasteHandler(event:TextEvent):void { // Extract values from TSV format and populate the DataGrid var items:Array = getItemsFromText(event.text); for each (var item:Object in items) dataGrid.dataProvider.addItem(item); } private function getItemsFromText(text:String):Array { var rows:Array = text.split("/n"); if (!rows[rows.length - 1]) rows.pop(); var columns:Array = dataGrid.columns; var itemsFromText:Array = []; for each (var rw:String in rows) { var fields:Array = rw.split("/t"); var n:int = Math.min(columns.length, fields.length); var item:Object = {}; for (var i:int = 0; i < n; i++) item[columns[i].dataField] = fields[i]; itemsFromText.push(item); } return itemsFromText; } private function getTextFromItems(items:Array):String { var columns:Array = dataGrid.columns; var textFromItems:String = ""; for each (var it:Object in items) { for each (var c:DataGridColumn in columns) textFromItems += it[c.dataField] + "/t"; textFromItems += "/n"; } return textFromItems; } ]]--> </mx:Script> <mx:DataGrid id="dataGrid" editable="true" keyDown="dataGridKeyDownHandler(event)" keyUp="dataGridKeyUpHandler(event)"> <mx:columns> <mx:DataGridColumn headerText="Scheduled Date" dataField="scheduledDate" /> <mx:DataGridColumn headerText="Home Team" dataField="homeTeam" /> <mx:DataGridColumn headerText="Away Team" dataField="awayTeam" /> <mx:DataGridColumn headerText="Field" dataField="field" /> </mx:columns> <mx:dataProvider> <mx:Object scheduledDate="4/1/2006" homeTeam="Chester Bucks" awayTeam="Long Valley Hitters" field="Dawn Field" /> </mx:dataProvider> </mx:DataGrid> </mx:Application>