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; } } }

Add Excel Widget uploaded to the Resource Center

AntGiles

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

Find more posts tagged with

Accepted answers

All comments

JeffersonFerreira_Ferreira

Hi Anthony! Great work! Congratulations. It is primordial for a GIS user's somethings like this.

But, A little question: How can I plot the coordinates in DD.DDD (decimal degreees) instead WebMercator metrical coordinates?

The widget recognizes the webmercator coordinates, but it's too confusing to a kind of users. Furthermore all my application display the wgs84 decimal degrees system. I'm not a "hard developer", but I can set up my "Frankensteins" takeing a piece here, another there and customizing my widgets. The CoordinateMenu widget can Go To coordinates entered as WGS decimal degrees, even behind the "backstages" the webmercator is acting. So it would be the same thing with your widget: enter wgs decimal degrees coordinates by the UI, that passes through webmercator and are ploted at the right place.

Is it possible? Do you've done like this? If not, we can think in. I could help you if I can.

Best Regards

AntGiles

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

JeffersonFerreira_Ferreira

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

Anthony, thanks for you attention. But "houston, we have a problem...!
When I upload a sheet in decimal degrees they are ploted at webmercator and all at the same place. Exemple, in my sheet:
X Y
-64.84071 -3.04574
-64.85397 -3.03276
-64.85832 -2.98987
-64.83300 -3.06294
-64.84892 -3.04203
-64.77522 -3.10844
-64.79987 -3.10231

The first coordinate pair, for exemple, represent -7218035.058740 -339215.035943 in webmercator, but they are ploted at the -64.84071 -3.04574 webmercator...

Any idea?

AntGiles

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

JeffersonFerreira_Ferreira

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

Hi Anthony;

In fact, I have 4 basemaps. Three of them are bingmaps mapservice (webmercator) and one is an image service that I've published. Originally it is in WG84. These bing services determine that all my application are in webmercator? Even if all of my operational layers and my image service as a basemap are in WGS geographic?
A schematic image is attached.
Thanks

Thanks

Start_2012-08-31_11-46-16.jpg

AntGiles

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:

http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m300000018000000/

Regards

Anthony

JeffersonFerreira_Ferreira

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:

http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m300000018000000/

Regards

Anthony

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

RhettZufelt

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

Hi Jefferson,

If they are plotting correctly then you must have got the map wkid to WGS84 so they display correctly.

However, that means that your map is now WGS84 and the Bing maps are tiled in the webmercator system. Did you find a way to load Bing maps as dynamic so they actually overlay, or did you give up on having a bing map as well?

Thanks,

R_

KennethLyons

I'm having a similar issue with the points in my spreadsheets not plotting correctly. the Sample that came with the download loads with no issue, but when I create my own the points end up in the middle of the ocean. I'm not sure where the disconnect is on my end. I've tried using several different coordinate types in the spreadsheet, but they all plot in the same area.

Any thoughts??

Thanks

AntGiles

Kenneth,

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

They must match

Regards

Anthony

KennethLyons

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.

RhettZufelt

What does the <map> and <basemaps> section of your config.xml look like?

R_

AntGiles

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

KennethLyons

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>

AntGiles

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

RhettZufelt

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_

Spreadsheet_mercator.xls

KennethLyons

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?

RhettZufelt

Yes there is. What ever you pick in the AddExcel.xml as the <message> tag in that file states.

R_

KennethLyons

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..

AntGiles

Kenneth,

To achieve what you are after would require some sort of geocode server that holds your street names / junction names. What you would have to do then is for every street / junction name entry on your spreadsheet you would have to make a call to the geocode service to see if it has a match and if so return the coordinates so you could plot it on the map.

This is not impossible to do but the hardest thing will be finding a geocode service that suits your requirement (or host your own)

Regards

Anthony

KennethLyons

I'm having some issues with the excel widget not recognizing the web mercator lat/long that I've inputted. It's only a couple points so it's not a major issue, but I'm unsure as to why those couple points are not plotting correctly. I'm attaching a copy of the spreadsheet I'm using for any feed back.

thanks

PACounties(WebMercator).xls

AntGiles

Kenneth,

I have just uploaded your spreadsheet to the sample site at:

http://gis.calhouncounty.org/FlexViewer2.5/index.html?config=config-addexcel.xml

And I get 67 points, the same that is in your spreadsheet,

How many do you get

Regards

Anthony

KennethLyons

I'm getting all 67 points as well. the issue is that there is at least one point that is not plotting correctly. It's being put in the altantic ocean off the west coast of africa. not sure what is causing this. I'm getting it in your test viewer as well. Just not sure what is causing it so I can correct it.

Thanks for taking a look

AntGiles

Kenneth,

I dont think any points are getting plotted in the place. You have 67 locations and 68 points are being plotted. I think the 68th point is the one getting plotted in the ocean. I suspect this is at 0,0 and what is happening is the for loop that plots the points is doing one to many and it is reading the empty row at the end of the data. When I get chance I will have a look at the code.

Thanks for pointing this out

Anthony

RhettZufelt

Have not completely tested it to see if it breaks something else, but this seems to "fix" it.

locateResult.content = "Number of Features: " + (tempData.length - 1).toString();
locateResult.icon = "assets/images/excel.png";
locateResult.layerID = String(layerNumber);
ResultAC.addItem(locateResult);
    
for(var i:int = 0;i<tempData.length;i++)                //change from
for(var i:int = 0;i<(tempData.length - 1);i++)          //change to

Plus it makes it match the count from a few lines above.

R_

RichardDiaz

If you wish to map Decimal Degrees that are in the spreadsheet to a Web Mercator basemap (i.e. Bing), do the following:

Add the reference: import com.esri.ags.utils.WebMercatorUtil;
Change the gmapPoint variable as illustrated below:

var long:Number = Number(tempData.getItemAt(i)[longNumb].value);
var lat:Number = Number(tempData.getItemAt(i)[latNumb].value);
// var gmapPoint:MapPoint = new MapPoint(long,lat,new SpatialReference(4326));
var gmapPoint:MapPoint = new MapPoint(long,lat);
gmapPoint = WebMercatorUtil.geographicToWebMercator(gmapPoint) as MapPoint;

Regards,

Rick

AntGiles

All,

With Roberts help an updated version for use with 3.0 has been uploaded to the resource center.

The update also has a few additions and bug fixes:

[INDENT]�?�Bug fixes for one more graphic being added to the graphics layer with 0,0 coordinates and the first point not having a click handler.
�?�Esri popup used to display attributes.
�?�Ability to specify a link field and alias.
�?�Zoom to extent of features when feature panel clicked [/INDENT]

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

Regards

Anthony

deleted-user-yA_w_FC9FKe5

All,

With Roberts help an updated version for use with 3.0 has been uploaded to the resource center.

The update also has a few additions and bug fixes:

[INDENT]�?�Bug fixes for one more graphic being added to the graphics layer with 0,0 coordinates and the first point not having a click handler.
�?�Esri popup used to display attributes.
�?�Ability to specify a link field and alias.
�?�Zoom to extent of features when feature panel clicked [/INDENT]

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

Regards

Anthony

Has anyone updated this yet? I am about to roll out a new product and this feature would be great to display using the new 3.3.

If someone has the time could you please post the importexcel for 3,3. I have a feeling quite a few of you have done this already and it would be greatly appreciated.

Thanks,

Michael

deleted-user-yA_w_FC9FKe5

Sorry I thought I would try this one more time. Has anyone updated the addexcel widget for 3.3 that they care to share.

I'm not real familiar with how to do this and figured/hoped someone else had already taken the steps to do this. If you have could you please take a moment to upload it for those of us who are not as experienced please. This would be a nice widget just to have with the main flex builder.

AntGiles

Michael,

Sorry its taken me a while to respond, i was not planning on upgrading my projects to 3.3 as 3.4 is out very soon and I just cannot keep up with how fast the releases are coming out. I have quickly thrown together a 3.3 project and recompiled the widget for you. I have not fully tested it but hopefully it should be ok.

Regards

Anthony

imran.jpeg

AddExcel.zip

Join the Conversation

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

Quick Links

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