Well, I must admit that it has been fun talking about this subject, so in this post I want to show the best we have found.
- We saw that Microstation Has integrated The functionality to import directly from a txt file
- We also saw how Do it with AutoCAD
- We saw how Export from AutoCAD o Microstation to csv or txt
- Then we saw how to use the command concatenate In case of having bearings and distances in excel
- And we saw a VBA application for Microstation that works in both ways
But best of all was to learn from someone who in his comments told us about this tool that allows from an excel file to generate a dxf file, using the coordinates of x, y, z, an identification code and the level where We want it to be drawn.
The application is called XYZ-DXF and you can download it here;
Let's see how it works:
1. The data of origin:
This application is appropriate for information downloaded from a gps or total station, as long as the coordinates are UTM, it means that its units in a Cartesian plane are in meters. The code column is an identifier of the point, then the x, y, z coordinates and finally the layer in which we want them to be drawn, these can be, for example, street axis, trees, boundaries, polygonal or any characteristic that later allows us filter the data in AutoCAD or Microstation.
* All points must have code.
* All points must be entered one after the other, without leaving blank rows.
We have to thank Juan Manuel Anguita, a Surveyor from Jaén, Spain who made an effort to build this macro. The Excel file has three sheets, one of them called Preview allows you to see the chart in plan, and side views (built on pure Excel charts!). Also each of these 9 quadrants can be viewed, in case of changing data in the table, use the button «update views»
Configure data for export
The third sheet called options, allows you to define whether the file to be exported will go in two or three dimensions, the size of the letter, if we want the elevations (dots) and the name of the dxf file to be displayed.
Once the purple button is pressed, a .dxf file is created, which can be opened with Microstation, Arcview, AutoCAD or almost any CAD program. In this, a layer is created for each different text found in the 'Layer' column (eg: lev), where the points will be; There will also be another layer whose name will be the text of the column 'Layer' + txt (ex: levtxt), where the codes will be, and another will be created, where the dimensions will be, with the name 'text of the column 'Layer' + dimensions (ex: levcotas). An excel file with the same name and in the same destination is also created.
The destination file (dxf)
This is the example of the file viewed from AutoCAD. Then you can change the colors of the layers (format / layers) or the point format (format / point styles).
It is simply an impressive application, for how useful and simple it is to handle. It doesn't draw lines, it just sends points.