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
Solved
how to show the graphic from excel file ?
+3- Contributor
Best answer by jkr_wrk
According to this page:
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+60- Evangelist
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.
+3- Contributor
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 ?
+60- Evangelist
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.
+3- Contributor
It is clear What u describe .
When someone use the excel file in arcmap .
will the graphic shows without problem ?
+35
According to this page:
It won't.
But I did not test.
+35- Best Answer
According to this page:
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.
💡 Did you know... The FeatureWriter is more intuitive. 😏
+60- Evangelist
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.
+3- Contributor
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
