Skip to main content
Solved

how to show the graphic from excel file ?


soly
Contributor
Forum|alt.badge.img+3
  • Contributor


hello ,

i would like to save geometric data into excel file 

then I read the excel file in arcmap ,

It shows me the attribute tables and location of lines .

How to achieve it ?

fme 2021

thanks in advance 

Best answer by jkr_wrk

According to this page:

https://gis.stackexchange.com/questions/62384/importing-excel-point-and-line-data-into-arcgis-desktop-as-shapefile

You could write point data to an X and Y column, and use a function in ArcMap to make Point-data from your Excel file.

But…

Why would you write Excel if you want users to show it in ArcMap? Write Shapefile or other files that are made for Spatial data.

View original
Did this help you find an answer to your question?

8 replies

geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • April 18, 2024

First of all: why not use a geospatial format like shapefile or a personal geodatabase?

But if you really want to use Excel you can use a GeometryExtractor to convert the geometry to Geohash, GeoJSON, Well Known Text, GML, and many other formats.


soly
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • April 18, 2024

@geomancer 

Thanks for reply 

the requirement is excel file .

i have tried ur method but it does not worked with me 

i have used geometry extractor to convert it to geojson or geohash then write. The output in excel file .

but when I check the output in Fme , it shows me only tables without graphics .

What I did wrong ?


geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • April 18, 2024

The GeometryExtractor has an option to remove the geometry (which is the default setting), or keep the geometry.

When you open the Excel file in FME it will contain no geometry, but you can use the GeometryReplacer to convert the encoded geometry (GeoJSON or Geohash) to geometry.


soly
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • April 18, 2024

It is clear What u describe .

When someone use the excel file in arcmap .
will the graphic shows without problem ?


jkr_wrk
Influencer
Forum|alt.badge.img+29
  • April 18, 2024

jkr_wrk
Influencer
Forum|alt.badge.img+29
  • Best Answer
  • April 18, 2024

According to this page:

https://gis.stackexchange.com/questions/62384/importing-excel-point-and-line-data-into-arcgis-desktop-as-shapefile

You could write point data to an X and Y column, and use a function in ArcMap to make Point-data from your Excel file.

But…

Why would you write Excel if you want users to show it in ArcMap? Write Shapefile or other files that are made for Spatial data.


geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • April 18, 2024
soly wrote:

It is clear What u describe .

When someone use the excel file in arcmap .
will the graphic shows without problem ?

  Not automatically, the user of Arcmap will have to convert the GeoJSON, Geohash, WKT or whatever back to geometry.

Which is exactly why I was surprised you want to use Excel instead of a spatial format.


soly
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • April 20, 2024

Thanks a lot for all information .

It is clear for me to use shape file or gdb better than excel file .

but they prefer excel file and they do not want to get shape file (old fashion )

Thanks a lot 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings