Hey Ganesh,
Thanks for reply,here is the code to get data from excel sheet:
//call init at creationcomplete
private function init():void{
var load:URLLoader = new URLLoader();
load.addEventListener(Event.COMPLETE,onComplete);
load.dataFormat = URLLoaderDataFormat.BINARY;
load.load(new URLRequest("data/sample.xls"));
}
private function onComplete(event:Event):void {
var urlLoader:URLLoader = event.target as URLLoader;
var byteArray:ByteArray = urlLoader.data as ByteArray;
var excelFile:ExcelFile = new ExcelFile();
excelFile.loadFromByteArray(byteArray);
var sheet:Sheet = excelFile.sheets[0];
var sheetOneData:ArrayCollection = sheet.values as
ArrayCollection;
//put this object in loop you we get each cell value for
sheet1
var dataObj:Object = sheetOneData.getItemAt(0) as Object;
}
Thanks,
DineshKumar.T
On Thu, Feb 5, 2009 at 10:52 PM, Ganesh r <[email protected]> wrote:
> hi dinesh can you sent me the code for how to read from excel sheet.
>
> http://kukiel.instantspot.com/blog/2008/11/24/Flex-Data-grids-and-Excel
>
>
>
>
> On Tue, Feb 3, 2009 at 3:37 PM, [email protected] <
> [email protected]> wrote:
>
>>
>> Hi all,
>>
>> I have a created a excel file under the src folder,i got how to read
>> the excel data ....but i am not getting how to write
>>
>> some text to this excel file....please anyone help me......
>>
>>
>> Thanks,
>> DineshKumar.T
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en
-~----------~----~----~----~------~----~------~--~---
