Map XY data from Excel into Flex

[ShwetaMorkhandikar]

I have the excel file with X Y location, i need to map these dynamically onto Flex API. I am using Flex API 2.5

[tanyabisen]

Hi Anthony,

I was going through this forum and I have a similar requirement however I dont see the source code attached. Can you please email me at bisen.tanya@gmail.com.

Also, i have csv file link. I dont have the excel file stored at some location.. I converted the link from .csv to .xml but how do I parse it.

Can you please help me on that too.

Thanks,
Tanya

Shweta,

There is an example here but it will require you doing soming coding:

http://www.arcgis.com/home/item.html?id=173870a7926c4ef9b2a5121be0b46211

regards

Anthony

[AnthonyGiles]

Tanya,

Here is the link to my load data file, which will allow you to load local excel and csv files:

http://www.arcgis.com/home/item.html?id=cdac64f40b53435c9b191731fcd3c9c1

If you are running you web app on a network with Internet access you can also add a csv file directly within a layer tag, see:

http://resources.arcgis.com/en/help/flex-viewer/concepts/index.html#/CSV_GeoRSS_and_KML_layer_types/...

Regards

Anthony

[MichaelVolz]

Anthony:

Does this widget create a heat map for the data from Excel in the flexviewer web application?

[AnthonyGiles]

Michael,

Yes it has that option

Regards

Anthony

[MichaelVolz]

Has this widget been around for at least a few versions, as I thought I downloaded it for Flex 3.1 or 3.2?

[AnthonyGiles]

Michael,

It's an updated version of my add excel widget. You can now also add a csv file and the data will be reprojected to fit your basemap.

It has been released against version 3.4 of the api.

Regards

Anthony

[JoeHewitt]

I would like to use my own WKT (It does not have a WKID). Is this possible/ Will it require much alteration of the code?