Flex:无法从文件夹中加载Excel文件并更新它们(删除)

Question

我正在尝试从 50 个 excel 文件中删除一行，为此我正在 flex 中制作一个工具来浏览文件夹，找到 xls 文件，然后对其执行操作。我在这里面临两个问题：1.我有一个循环，该循环对文件夹进行迭代，一旦找到xls，它应该调用一个函数来删除该行并返回for循环并继续处理文件夹中的其他Excel文件。但它没有这样做。

2.我无法在 excel 中删除和行。我正在使用as3xls来处理excel。在这种情况下，我将行的值设置为我不要求空白，因为我不知道如何删除它。

我是弹性新手，所以请帮忙。

enter code here
<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:fx="http://ns.adobe.com/mxml/2009" 
  xmlns:mx="library://ns.adobe.com/flex/mx" layout="absolute"
  creationComplete="onCreate(event)">

       <fx:Script>
              <![CDATA[
              import com.as3xls.xls.Cell;
              import com.as3xls.xls.ExcelFile;
              import com.as3xls.xls.Sheet;
              import flash.filesystem.FileMode;
              import flash.utils.Timer;
              //     import flash.events.TimerEvents;

              import mx.collections.ArrayCollection;
              import mx.controls.Alert;
              private var sheet:Sheet; 
              private var  interval: uint;
              private var loadedFile:ByteArray;
                     function trigger():void { setTimeout(doIt, 10000); }
                     function doIt():void    { }

              private function onCreate(e:Event):void
              {
                     var fileDirectry:File = File.documentsDirectory.resolvePath("D:/temp");
                     var excelFile:File = null;
                     var files:Array = fileDirectry.getDirectoryListing();
                     for(var i:int = 0; i < files.length; i++){
                           var temp:File = files[i];
                           if(temp.extension == "xls"){
                                  excelFile = temp;
                                  break;
                                  //var request:URLRequest = new URLRequest(excelFile.nativePath);
                                  //var urlLoader:URLLoader = new URLLoader(request);
                                  //urlLoader.addEventListener(Event.COMPLETE, onURLLoaderComplete); // Once file loaded, function call onURLLoaderComplete
                                  //urlLoader.dataFormat = URLLoaderDataFormat.BINARY; // to Read Data in Binary Format
                                  //urlLoader.load(request);
                                  //trigger();
                     //     interval=setTimout( onCreate(event) ,200);

                           }
                     }
                     var request:URLRequest = new URLRequest(excelFile.nativePath);
                     var urlLoader:URLLoader = new URLLoader(request);
                  urlLoader.addEventListener(Event.COMPLETE, onURLLoaderComplete); // Once file loaded, function call onURLLoaderComplete
                     urlLoader.dataFormat = URLLoaderDataFormat.BINARY; // to Read Data in Binary Format
                     urlLoader.load(request);

              }
              private function onURLLoaderComplete(event:Event):void
              {
              loadedFile = event.target.data; 
              var excelFile:ExcelFile = new ExcelFile(); 
              excelFile.loadFromByteArray(loadedFile);
              sheet = excelFile.sheets[0]; // Reads sheet1
              //trace(sheet.getCell(1,1).value);
              //Alert.show(sheet.getCell(0,0).value)// getCell(Row, Col)
              var rows:int = sheet.rows;
              var cols:int = sheet.cols;
              for(var i:int = 0; i < rows; i++){
                     for(var j:int = 0; j < cols; j++){
                           if(sheet.getCell(i,j).toString() == "second" || sheet.getCell(i,j).toString() == "Second" )
                           {
                                  Alert.show(sheet.getCell(i,j-1).value)
                                         for (var k:int =0;k< cols;k++){
                                         sheet.setCell(i,k,'');

                                         }
                                         excelFile.sheets.addItem(sheet);
                                         var ba:ByteArray = excelFile.saveToByteArray();
                                         var fr:FileReference = new FileReference();
                                         fr.save(ba,"SampleExport1.xls");

                                         //sheet.
                                  //TypeLib name and TypeDef Id
                           }
                     }
              }             
              //Alert.show(sheet.getCell(0,0).value)
              //return ;
              //DG.dataProvider=sheet.values; // Imports all excel cells to Datagrid
              }


              ]]>
       </fx:Script>


       <fx:Declarations>
              <!-- Place non-visual elements (e.g., services, value objects) here -->
       </fx:Declarations>
</mx:WindowedApplication>

Answer 1

问题是加载是一个异步操作，因此您需要创建某种系统来暂停循环的处理，直到加载完成。这样的事情应该有效：

public class ProcessFilesCommand
{
    private var _files:Array;
    private var _index:int = 0;
    public function processFiles(path:String):void
    {
        _index = 0;
        var fileDirectry:File = File.documentsDirectory.resolvePath(path);
        _files = fileDirectry.getDirectoryListing();
        if(!_files || _files.length == 0)
            return; //or dispatch a complete event
        processFileAt(0);
    }
    private function cleanFile(data:Object):void
    {
        //do your excel stuff here
    }
    private function processFileAt(index:int):void
    {
        trace("ProcessFilesCommand.processFileAt(" + index + ")");
        if(index >= _files.length)
        {
            //maybe a good spot to dispatch a complete event...
            return;
        }
        var file:File = File(_files[_index]);
        if(file.isDirectory || file.extension == null || file.extension.toLowerCase() != "xls")
        {
            processFileAt(++_index);
        }
        else
        {
            var request:URLRequest = new URLRequest(file.nativePath);
            var loader:URLLoader = new URLLoader(request);
            loader.addEventListener(Event.COMPLETE, loader_completeHandler); // Once file loaded, function call onURLLoaderComplete
            loader.dataFormat = URLLoaderDataFormat.BINARY; // to Read Data in Binary Format
            loader.load(request);
        }
    }
    private function loader_completeHandler(event:Event):void
    {
        trace("ProcessFilesCommand.loader_completeHandler(event)");
        cleanFile(event.target.data);
        processFileAt(++_index)
    }
}