importing excel data into flash?

[suryakantsshukla]

Hi all! In an application we have an excel file of large amount of data whose every row we want as an array of data for impoting into flash application.Can anyone help me out.Here i give a small description what we want to do:

*****Excel Sheet

HallNo     ComName     Stall

1               ABC             12

2               GHD             17

3               JKH              6A

*********Data format in which we want

_global.HallNo[0] = '1';

_global.ComName[0] = 'ABC';

_global.Stall[0] = '12';

_global.HallNo[0] = '1';

_global.ComName[0] = 'GHD';

_global.Stall[0] = '17';

_global.HallNo[0] = '1';

_global.ComName[0] = 'JKH';

_global.Stall[0] = '6A';

Thanks for help in advance.

[kglad]

excel can export a csv file.  you can load that (using the urlloader) into flash and parse the data (using the string and array classes).

[suryakantsshukla]

Thanks for help!

I forgot to mention that our major issue is to convert that excel into csv. we are well aware of urlloader and we are able to parse as well.

The problem is we are not able to convert into above format, as i have mentioned its a large volume of data so we can't copy and paste one by one too.

[birnerseff]

Hi,

in case neither excel nor openoffice can do the conversion, there is xlscat at cpan,org

[kglad]

open your file in excel, click save as/other formats and selected csv type.