Flex4 读取Xls表格数据

首先定义变量

?????????? private var file:FileReference = new FileReference();
?????????? private var xls:ExcelFile;

????????? private var stateText:String = "请选择一个文件";

第二步添加监听

??????????? file.addEventListener(Event.SELECT,file_select);
?? ??? ??? ?file.addEventListener(Event.COMPLETE,file_complete);
?? ??? ??? ?file.addEventListener(IOErrorEvent.IO_ERROR,file_progress);

第三步添加事件函数

//选择文件的事件 ?? ??? ?private function file_select(e:Event):void{ ?? ??? ??? ?stateText = "选择了文件"+file.name; ?? ??? ??? ?textinput.text = stateText; ?? ??? ??? ?upload(); ?? ??? ?} ?? ??? ?//上传完毕后的事件 ?? ??? ?private function file_complete(e:Event):void{ ?? ??? ??? ?//生成xls文件 ?? ??? ??? ?xls = new ExcelFile(); ?? ??? ??? ?//加载数据 ?? ??? ??? ?xls.loadFromByteArray(e.target.data); ?? ??? ??? ? ?? ??? ??? ?var sheet:Sheet = xls.sheets[0]; ?? ??? ??? ? ?? ??? ??? ?xlsSet = sheet.values; ?? ??? ??? ?//数据赋值 ?? ??? ??? ?resultSet = getArrayCollection(xlsSet); ?? ??? ???? ?? ??? ?} ?? ??? ? ?? ??? ?private function file_progress(e:ProgressEvent):void{ ?? ??? ??? ? ?? ??? ??? ?//判断progressBar是否为空 ?? ??? ??? ?if(progressBar !=null){ ?? ??? ??? ??? ? ?? ??? ??? ??? ?progressBar.label = "已上传";//+Math.round(100*e.bytesLoaded/e.bytesTotal)+“%”; ?? ??? ??? ??? ?progressBar.setProgress(Math.round(100*e.bytesLoaded/e.bytesTotal),100); ?? ??? ??? ??? ? ?? ??? ??? ?} ?? ??? ?} ?? ??? ?//加载xls数据的方法 ?? ??? ?private function upload():void{ ?? ??? ??? ?if(file.size > 0){ ?? ??? ??? ??? ?file.load(); ?? ??? ??? ?} ?? ??? ?}