nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

AntGiles

ShwetaM

Attached is a zip file containing both the compiled and uncompiled code. All you should need is an excel file that has a minimum of two columns one holding your x coords and the other your y coords (in the same spatial reference as your base map). All other columns will come across as attributes. In the config xml specify the column names used for your coords and a title field if required.

Place the images under assets in your assets/images folder.

Regards

Anthony

All comments

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?

AntGiles

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

mvolz47

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

AntGiles

Michael,

Yes it has that option

Regards

Anthony

mvolz47

Anthony:

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

AntGiles

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/01m300000051000000/

Regards

Anthony

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

anjelinaponker

Hi Parvaz,
I developped a widget that is doing what you want. It reads a CSV file that contains two columns with coordinates x and y. It can be in any coordinate system. The coordinate system is identified by the user through a combox box before the file is read and parsed. The parsing result is push into an array and for every record a MapPoint is created and projected on the map. Here are some code elements:

var outSR:SpatialReference = new SpatialReference(wkid.selectedItem.data);
for (var i:int = 0; i < donnees.length; i++)
{
var X:Number = donnees[abs];
var Y:Number = donnees[ord];
var point:MapPoint = new MapPoint(X, Y, outSR);
geometryService.project([point as Geometry], new SpatialReference(32198));
}
private function handlerProjectComplete(e:GeometryServiceEvent):void
{
if (incremente < donnees.length)
{
var pt:MapPoint = (e.result as Array)[0] as MapPoint;
var myGraphic : Graphic = new Graphic();
myGraphic.geometry = pt;
myGraphic.symbol = graphicPointSym;
myGraphic.addEventListener(MouseEvent.MOUSE_OVER, handlerMouseRollOver);
graphicsLayer.add(myGraphic);
donnees[incremente].push(myGraphic);       points.push(myGraphic);
incremente++;
}

The comboxBox dataProvider comes from this list that link the wkid number to project in the map's projection:
   private const projectionList:ArrayCollection = new ArrayCollection(
    [
     { data: 4326, label: "Géographique WGS84" },
     { data: 4269, label: "Géographique NAD83" },
     { data: 102113, label: "Web_Mercator WGS84 (Google)" }, /* Use 102100 instead */
     { data: 26917, label:"UTM fuseau 17N NAD_1983" },
     { data: 26918, label:"UTM fuseau 18N NAD_1983" },
     { data: 26919, label:"UTM fuseau 19N NAD_1983" },
     { data: 26920, label:"UTM fuseau 20N NAD_1983" },
     { data: 26921, label:"UTM fuseau 21N NAD_1983" },
     { data: 32183, label:"MTM fuseau 3 NAD_1983" },
     { data: 32184, label:"MTM fuseau 4 NAD_1983" },
     { data: 32185, label:"MTM fuseau 5 NAD_1983" },
     { data: 32186, label:"MTM fuseau 6 NAD_1983" },
     { data: 32187, label:"MTM fuseau 7 NAD_1983" },
     { data: 32188, label:"MTM fuseau 8 NAD_1983" },
     { data: 32189, label:"MTM fuseau 9 NAD_1983" },
     { data: 32190, label:"MTM fuseau 10 NAD_1983" },
     { data: 32198, label: "Lambert conique conforme - Québec" }
    ]);

Hope that helped.

pdio

Hi
How can I use this code? can you send your Widget source code?
Regards
Anjelina

anjelinaponker

Hi
How can I use this code?
Regards
Anjelina

PascalDionne

Hi Parvaz,
I developped a widget that is doing what you want. It reads a CSV file that contains two columns with coordinates x and y. It can be in any coordinate system. The coordinate system is identified by the user through a combox box before the file is read and parsed. The parsing result is push into an array and for every record a MapPoint is created and projected on the map. Here are some code elements:

var outSR:SpatialReference = new SpatialReference(wkid.selectedItem.data);
for (var i:int = 0; i < donnees.length; i++)
{
var X:Number = donnees[abs];
var Y:Number = donnees[ord];
var point:MapPoint = new MapPoint(X, Y, outSR);
geometryService.project([point as Geometry], new SpatialReference(32198));
}
private function handlerProjectComplete(e:GeometryServiceEvent):void
{
if (incremente < donnees.length)
{
var pt:MapPoint = (e.result as Array)[0] as MapPoint;
var myGraphic : Graphic = new Graphic();
myGraphic.geometry = pt;
myGraphic.symbol = graphicPointSym;
myGraphic.addEventListener(MouseEvent.MOUSE_OVER, handlerMouseRollOver);
graphicsLayer.add(myGraphic);
donnees[incremente].push(myGraphic);       points.push(myGraphic);
incremente++;
}

The comboxBox dataProvider comes from this list that link the wkid number to project in the map's projection:
   private const projectionList:ArrayCollection = new ArrayCollection(
    [
     { data: 4326, label: "Géographique WGS84" },
     { data: 4269, label: "Géographique NAD83" },
     { data: 102113, label: "Web_Mercator WGS84 (Google)" }, /* Use 102100 instead */
     { data: 26917, label:"UTM fuseau 17N NAD_1983" },
     { data: 26918, label:"UTM fuseau 18N NAD_1983" },
     { data: 26919, label:"UTM fuseau 19N NAD_1983" },
     { data: 26920, label:"UTM fuseau 20N NAD_1983" },
     { data: 26921, label:"UTM fuseau 21N NAD_1983" },
     { data: 32183, label:"MTM fuseau 3 NAD_1983" },
     { data: 32184, label:"MTM fuseau 4 NAD_1983" },
     { data: 32185, label:"MTM fuseau 5 NAD_1983" },
     { data: 32186, label:"MTM fuseau 6 NAD_1983" },
     { data: 32187, label:"MTM fuseau 7 NAD_1983" },
     { data: 32188, label:"MTM fuseau 8 NAD_1983" },
     { data: 32189, label:"MTM fuseau 9 NAD_1983" },
     { data: 32190, label:"MTM fuseau 10 NAD_1983" },
     { data: 32198, label: "Lambert conique conforme - Québec" }
    ]);

Hope that helped.

pdio

AntGiles

Parvaz,

Sorry but I have no intention of writing the code to perform any projection of the coordinates. I have supplied the source code if you want to develop the widget further but at the moment it meets my needs and I do not have the time to spend developing it.

If you do not have the ability to write flex code you could always look at doing the conversion in excel have a look at something like this http://www.dartmouth.edu/~renshaw/geogtools/ or the attached .xls file

Regards

Anthony

parvazparvaz

Hi
Any solution for changing Excell coordinate to web map application projection system? for example my map has 102100 WKID but my coordinate has 3546 WKID. in your widget I should change my excell coordinate to my web, that this is not user friendly.
Regards
A.ponker

AntGiles

Shweta,

Please don't forget to also mark the thread as answered (the tick on the thread with the answer)

Regards

Anthony

ShwetaMorkhandikar

I tried using this in my Flex viewer and it's works wonderfully.

AntGiles

ShewtaM,

Please don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow the steps as shown in the below graphic:

[ATTACH=CONFIG]15136[/ATTACH]

Regards

Anthony

ShwetaMorkhandikar

ShwetaM

Attached is a zip file containing both the compiled and uncompiled code. All you should need is an excel file that has a minimum of two columns one holding your x coords and the other your y coords (in the same spatial reference as your base map). All other columns will come across as attributes. In the config xml specify the column names used for your coords and a title field if required.

Place the images under assets in your assets/images folder.

Regards

Anthony

Thank you so much Anthony.

AntGiles

ShwetaMorkhandikar

ShwetaM,

Just to keep you up to date, I have just about finished creating a widget that allows you to upload data from an excel spreadsheet. I just need to test it a bit more. Unfortunately I am away from work next week so I will not be able to complete till the week begining the 11th June, hope this is ok.

Regards

Anthony

Anthony,
How's the testing going on?

ZahidChaudhry

Shweta,

Sorry I haven't implemented a solution to this problem to date but it is something that I want to do soon. I will post up the solution once I have done the work unless there is someone else out there that has already done this and doesn't mind sharing their compilied/uncompilied code (Zahid if you are reading this!!!).

Regards

Anthony

Anthony,

Let me know if you still needs code for mapping data from XLS. I have a widget working that allow you to upload xls/gpx files and display data on map...
thanks

parvazparvaz

Hi
I,m looking for this widget. can u help me? my email:anjelinapon@gmail.com
Regards
A.ponker

ShwetaMorkhandikar

That should be fine, Anthony. Looking forward for the widget. Thanks so much.

AntGiles

ShwetaM,

Just to keep you up to date, I have just about finished creating a widget that allows you to upload data from an excel spreadsheet. I just need to test it a bit more. Unfortunately I am away from work next week so I will not be able to complete till the week begining the 11th June, hope this is ok.

Regards

Anthony

YungKaiChin

I don't know if it will be easier, but you can convert the xls file to cvs, txt, or even xml file.
Then, load it, parse it, and last, loop through them to create point graphics or mappoints.

AntGiles

Shweta,

Sorry I haven't implemented a solution to this problem to date but it is something that I want to do soon. I will post up the solution once I have done the work unless there is someone else out there that has already done this and doesn't mind sharing their compilied/uncompilied code (Zahid if you are reading this!!!).

Regards

Anthony

ShwetaMorkhandikar

Thanks Anthony, I am not a full fledged programmer/developer. So was looking for a compiled version, if possible.

AntGiles

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.