latitude/longitude From Excel?

[squidg]

In another post by Somar in http://board.flashkit.com/board/showthread.php?t=666832 he posted a file called map.fla.
That file explaned how to move an object usinig latitudes and longitudes. It does this by using the following code

// Change these to whatever you want to see.
Desired_Latitude = 51.5;
Desired_Longitude = 30.5;


That works fine but the problem is that i have about 100 or more latitudes and longitudes position for that same object so it is very time consuimg if i entered them all manually using that method. IS there anyway i can read the longitudes and latitdues from the excel file instead of manually inserting one by one?

[webdreamer]

Dont think you can from an excel file but you can from a text file or an xml file.

Hope it help

[squidg]

Would u happen to know how by anychance?

[webdreamer]

check the flash doc for working with external data (http://livedocs.adobe.com/flash/9.0/main/00001046.html)

hope it helps

[whispers]

you can save you excel sheet to a delimited character file and import it that way separating your data (lat/lon) by that character..

you could then dump all the values into an array & just loop through it.. plotting your markers (moving your object)

[silentweed]

or as an xml file from excel as well... excel xml is really messy though.. so u will need to create a mapping in excel ..which maps to that data
this may help get you started:

http://msdn.microsoft.com/en-us/library/aa203737.aspx#officeexcelxmlmappingscenarios_map