How can i extract all the coordinates from e57 file into an excel file?

Not tested but I think creating a Point Cloud XYZ file is much quicker. (pointcloudformat to pointcloudformat) A Point Cloud XYZ is like a CSV which should work ok in Excel.

But more important is the question, why do you need pointcloud coordinates in Excel? I think the limit of Excel is still 1,048,576 rows. Most pointclouds have multiple times more points. Converting a pointcloud to Excel just does not feel right?

Update

Added screenshot and FME 2019 templatefile.

e57_xyz.fmwt

Creator to initiate the translation. FeatureReader, point to file, it will select the format automatically. Connect the outputport to the inputport of a FeatureWriter. Select PointCloud XYZ format. Select file location. Click run to start translation.

Hi @mryashtomar,

I received your case and I'm really sorry for my late response. I'm glad to see that you've brought your question to the Forums and got some help in the meantime!

Have you already tried adding just an E57 reader and connecting it to a PointCloudXYZ writer? This seems to work successfully for me on sample data and then I can see all the coordinates of my point cloud when I open the .xyz file in Notepad++. If you have multiple features read in from your .e57 file, you may want to use a PointCloudCombiner to merge it into one point cloud so you get only a single .xyz file output.

You can even specify the extension to .CSV instead of .XYZ if you wish, and you might want to change the delimiter character from space to a comma if that matters to you.

Some things to keep in mind on this though are to be sure to check the parameters when adding the writer as you may need to remap some of the components (look for anything red that needs to be corrected in the table). I found that to view the output, it was easier doing it in the Data Inspector and opening the file anew, than the Visual Preview, and you can right click the output file as well to view it in a notepad or text program. This is what my output looked like:

Let me know if that helps and I can close your case for you, or else feel free to reply to the case emails and send a sample of your dataset and I can take a look at it there as well.

Thanks!

-Jovita