1009 Error - Githubissues

What steps will reproduce the problem?
1. I use with flex sdk version 4.1 and player 10.1.
2. I try to browse and select a xls file.
3. I saw an error about 1009 error

What is the expected output? What do you see instead?
TypeError: Error #1009: null 객체 참조의 속성이나 메서드에 
액세스할 수 없습니다.
    at com.as3xls.xls::ExcelFile/dimensions()[D:\project\hanjun\flex\SampleFlex4\src\excel\com\as3xls\xls\ExcelFile.as:619]
    at Function/http://adobe.com/AS3/2006/builtin::call()
    at com.as3xls.xls::ExcelFile/loadFromByteArray()[D:\project\hanjun\flex\SampleFlex4\src\excel\com\as3xls\xls\ExcelFile.as:309]
    at ExcelDownload/fileReference_Complete()[D:\project\hanjun\flex\SampleFlex4\src\excel\ExcelDownload.mxml:61]

What version of the product are you using? On what operating system?
Windows XP Proffesional

Please provide any additional information below.

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" 
               xmlns:s="library://ns.adobe.com/flex/spark" 
               xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600">
    <fx:Declarations>
        <!-- Place non-visual elements (e.g., services, value objects) here -->
    </fx:Declarations>

    <fx:Script>
        <![CDATA[
            import com.as3xls.xls.Cell;
            import mx.collections.ArrayCollection;

            import com.as3xls.xls.Sheet;
            import com.as3xls.xls.ExcelFile;
            import mx.controls.dataGridClasses.DataGridColumn; 

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

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

            [Bindable]
            private var rebateDGDataProvider:ArrayCollection = new ArrayCollection();

            private function browseAndUpload():void
            {
                fileReference = new FileReference();
                fileReference.addEventListener(Event.SELECT,fileReference_Select);
                fileReference.addEventListener(Event.CANCEL,fileReference_Cancel);
                fileReference.browse();
            }
            private function fileReference_Select(event:Event):void
            {
                fileReference.addEventListener(Event.COMPLETE,fileReference_Complete);
                fileReference.addEventListener(IOErrorEvent.IO_ERROR, onLoadError);
                fileReference.load();   
            }
            private function fileReference_Cancel(event:Event):void
            {
                fileReference = null;
            }
            private function onLoadError():void
            {
                /*body not implemented*/
            }
            private function fileReference_Complete(event:Event):void
            {
                var fileData:ByteArray  = fileReference.data;
                var excelFile:ExcelFile = new ExcelFile();
                var noOfRows:int;
                var noOfColumns:int;
                if(fileData!=null && fileData.length > 0){
                    excelFile.loadFromByteArray(fileData);
                    var sheet:Sheet = excelFile.sheets[0];
                    if(sheet!=null)
                    {
                        noOfRows=sheet.rows;
                        noOfColumns = sheet.cols;
                        for(var row:int = 0; row<noOfRows;row++)
                        {
                            var cellObject:Object ={};
                            for(var col:int=0;col<noOfColumns;col++)
                            {
                                var cell:Cell = new Cell();
                                var cellValue:String = new String();
                                cell = sheet.getCell(row,col);
                                if(cell!=null)
                                {
                                    cellValue =(cell.value).toString();
                                    addProperty(cellObject,col,cellValue);
                                }
                            }// inner for loop ends

                            rebateDGDataProvider.addItem(cellObject);
                        } //for loop ends
                    } //if sheet   
                } //if filedata
                rebateScheduleDG.includeInLayout = true;
                rebateScheduleDG.visible = true;
                fileReference = null;
            }
            private function addProperty(cellObject:Object,index:int,cellValue:String):void
            {
                if(index == 0)
                    cellObject.cost = cellValue;
                else if(index == 1)
                    cellObject.name = cellValue;
                else if(index == 2)
                    cellObject.qty = cellValue;
                else if(index == 3)
                    cellObject.value = cellValue;
            }

            private function exportToExcel():void
            {
                sheet = new Sheet();
                var dataProviderCollection:ArrayCollection = rebateByItemDG.dataProvider as ArrayCollection;
                var rowCount:int =  dataProviderCollection.length;
                sheet.resize(rowCount+4,10);
                sheet.setCell(0,0,"Item Name");
                sheet.setCell(0,1,"Item Cost");
                sheet.setCell(0,2,"Item Qty");
                sheet.setCell(0,3,"Item Price");
                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+2,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);  
                        } // if  
                        i++;  
                    } // for record  
                } // for fields  
            } // for colCount  

        ]]>
    </fx:Script>

    <s:layout>
        <s:VerticalLayout/>
    </s:layout>

    <s:Button label="Browse" click="browseAndUpload()"/>
    <mx:DataGrid id="rebateScheduleDG" 
                 dataProvider="{rebateDGDataProvider}" width="100%"/>
    <mx:DataGrid id="rebateByItemDG" 
                 dataProvider="{ItemDGDataProvider}" width="100%" editable="true"/>
    <s:Button label="Export To Excel" click="exportToExcel();"/>

</s:Application>
Original issue reported on code.google.com by bryan.wi...@gmail.com on 16 Dec 2010 at 12:48
aoiu / as3xls

1009 Error #38
