Excel data into Flash

[alexanderdring]

Hi everyone,

I was wondering if anyone knew how to reference data from excel spreadsheets and display it in Flash or give me any guidance on how to input text in Flash to do this. I'd like to create a form where someone can type in, say, a PRODUCT NUMBER like this:

PRODUCT NUMBER: 02316891968

TYPE: -------------

POWER SUPPLY: -----------

etc.

and have all of the information related to that product (TYPE, POWER SUPPLY) appear in boxes on another page like this:

PRODUCT NUMBER: 02316891968

TYPE: COMPUTER

POWER SUPPLY: 220v

iT would also be great if it could happen the other way around, so if they type in POWER SUPPLY, the closest PRODUCT NUMBER to that figure would appear in the same way. At present, I intend to put it together off-line as a CD-based technical source and I've been having some trouble getting anywhere in normal HTML.

Thanks.

Alex D.

 

[billwatson]

as long as you dont want to update the excel file then save the excel as csv which flash can then import

use loadvars to bring in the data

use split to get the data into arrays which can then be searched