3. - EXPORT TO EXCEL MENU
3.1. - General Options
The Selection Mode works as in Inquiry Menu, as well as the filters by type and decimal places. Besides we have 3 check-boxes to:
Insert Filter Row, in the sheet of Excel. The row of filters allows discriminatory selections depending on the different values which are presented in each column. That is to say, if there are five different layers in the column, choosing the name of any layer from the filters combo-box, user will see the rows of values for only the elements in that layer.
Insert Total Sum Row, in the sheet of Excel. The row of sum will appear at the end of values in columns for area or length or projected length, this way showing the sum of values of the whole column.
ACAD Index. Have these options:
• Insert Indexes, in AutoCAD
• Remove Previous Indexes, if other indexes were inserted in the same drawing.
• Index Height, to introduce the height of the AutoCAD text used as index.
• Index Text Style, to select the style of the AutoCAD text used as index.
• Start From, a positive integer value to start indexing AutoCAD objects.
Drop-down list Sort Data By has options for sorting the indexes that relate exported data and AutoCAD objects. ACAD Selection option has no way of sorting the indexes when you perform a multiple selection by a Window Selection or Crossing Selection. Anyway, you can set a specific order in a multiple selection if pick AutoCAD objects individually, one after another, using the square pickbox cursor. Coord. X option will sort indexes according to the X coordinate value of a point of the object. Coord. Y option will sort indexes according to the Y coordinate value of a point of the object.
In Sorting Direction drop-down list, you can set the sort order direction of indexes respect to the X coordinate axis or Y axis:
• Up: lowest to highest value of X or Y coordinate.
• Down: highest to lowest value of X or Y coordinate.
Drop-down list Reference Point has options to select the point of the object used for sorting them. Start Point option will use the first vertex (polylines) or the start point (Arches, Lines and Ellipses) of each object. Box Center option will use the center of the objects bounding box to sort their indexes.
3.2. - Exportation to Excel of Length and/or Area by selection
Working with entities:
• MLines (computed length)
• Hatchs (only those that have area as property)
• Planar 3DFace (those whose vertices lies in the same plane, coplanar)
Please, read the information in point 2.4 of Inquiry Menu about the area of 3D Faces.
The indexes inserted by this menu, if checked, will belong to layer InnerSoft-IndexL.
TIP: The minimum surface area of a four-point non-planar 3DFace (a skewed quadrilateral) is a saddle shape that passes through the intersection of lines drawn from the midpoints of opposite pairs of sides. Application does not compute the area of four points 3DFaces.
3.3. - Exportation to Excel of projected Length by selection.
Working with entities:
The indexes inserted by this menu, if checked, will belong to layer InnerSoft-IndexLP.
TIP: The limit for these functions (3.2 and 3.3) is 65.536 objects (the maximum that a sheet of Excel allows). If you need to export the data of a greater set of objects, must do it in different steps.
3.4. - Exportation to Excel of coordinates from vertexes, centers or points
Working with following entities vertex:
• Arc (Start Point, Center Point and End Point)
• Ellipse (Start Point, Center Point and End Point)
• Circle (Center Point)
• 3D Faces
• 2D Solids
• Polyface Meshes
• Polygon Meshes
The indexes inserted by this menu, if checked, will belong to layer InnerSoft-IndexV.
For planar polylines (2D and LW), app will export Z coordinate of its vertices and general elevation of the polyline. Usually, those values are equal, but not if you rotate the polyline respect to the X or Y axis.
TIP: As Excel does not allow sheets with more than 65.536 cells, the application will divide the list to be exported in sheets of approximately 50.000 rows each one, creating new sheets as they are needed. Moreover, the book of Excel will be saved before beginning to fill the second sheet and it will be saved whenever a new sheet will be filled.