Skip to main content
Participant
February 11, 2012
Question

importing excel data into flash?

  • February 11, 2012
  • 2 replies
  • 4398 views

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.

This topic has been closed for replies.

2 replies

Participant
February 12, 2012

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.

Inspiring
February 12, 2012

Hi,

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

kglad
Community Expert
Community Expert
February 12, 2012

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

kglad
Community Expert
Community Expert
February 11, 2012

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).