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
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
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.
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 ?
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.
It is clear What u describe .
When someone use the excel file in arcmap .
will the graphic shows without problem ?
According to this page:
It won't.
But I did not test.
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.
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.
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