Select to view content in your preferred language

Add Excel Widget uploaded to the Resource Center

4043
38
07-23-2012 10:29 AM
AnthonyGiles
Honored Contributor
All,

Please find a link to an add Excel Widget:

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

Thank You Robert for hosting sample application for me

Feedback welcome

Regards

Anthony
0 Kudos
38 Replies
AnthonyGiles
Honored Contributor
Kenneth,

Are the coordinates in your spreadsheet in the same spatial reference as your application?

They must match

Regards

Anthony
0 Kudos
KennethLyons
Emerging Contributor
Anthony,
If by "Spatial Reference" you mean coordinate system, I'm not sure, and how would I verify that.  I've tried all difference types of coordinates Decimal Degrees, MGRS, Easting/Northing.  All show up in the same location no matter what order I put them in.  Like I said the sample spreadsheet loads with no issue, All points show up in the Pacific NW.  I tried to follow the same format as the sample when creating my own test points, but for some reason the point is located in the middle of the Altantic Oceans instead of central Pennsylvania.

I'm not sure where the issue is coming from.
0 Kudos
RhettZufelt
MVP Notable Contributor
What does the <map> and <basemaps> section of your config.xml look like?

R_
0 Kudos
AnthonyGiles
Honored Contributor
Kenneth,

If you have not specified a wkid in your map tag then the spatial reference ( coordinate system) of your application will be determined from the first base map that is loaded. Check the Rest endpoint for your first basemap this will tell you it's spatial reference.

Your coordinates in your spreadsheet need to be in the same coordinate system as your first base map

Regards

Anthony
0 Kudos
KennethLyons
Emerging Contributor
Here is the <map> and <basemap> section of my config.xml

<map wraparound180="true" initialextent="-9441000 4769000 -7973000 5229000" fullextent="-20000000 -20000000 20000000 20000000" top="40">
       
        <basemaps>
            <layer label="Topo Maps"      type="tiled" visible="true" alpha=".8"
                   url="http://server.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer"/>                
     <layer label="World Imagery" type="bing" style="aerialWithLabels" visible="false" />      
     <layer label="Street Map"   type="osm" visible="false" />             
            <layer label="PA Imagery"    type="tiled" visible="false" alpha=".8"
                   url="http://146.186.163.133/ArcGIS/rest/services/AerialPhoto_Color2003-2006/MapServer"/>  
        </basemaps>
0 Kudos
AnthonyGiles
Honored Contributor
Kenneth,

From your last post your applications spatial reference is Web Mercator so you coordinates in your spreadsheet need to also be in Web Mercator

Regards

Anthony
0 Kudos
RhettZufelt
MVP Notable Contributor
This should work for you as a test. (as long as you haven't modified the addexcel.xml to change column names.  I noticed if you have the wrong column names, it doesn't error out, it just throws the points in some arbitrary place over in Europe)


R_
0 Kudos
KennethLyons
Emerging Contributor
Thanks it seems to be working now.  I'm going to try generating my own spreadsheet again.  Is there a specific column name that needs to be used in order for the pop-up window to work correctly?
0 Kudos
RhettZufelt
MVP Notable Contributor
Yes there is.  What ever you pick in the AddExcel.xml as the <message> tag in that file states.

R_
0 Kudos
KennethLyons
Emerging Contributor
Ok, so I understand that these points are based on the initial map background's coordinate system, but out of curiousity is there a way to modify this widget to plot the points based on a street address or road intersection?  I would try this on my own, but I'm not NEARLY compitent enough with this to even know where to start.

Thanks for any input..
0 Kudos