Loading...

How to Import vertexes/vertices polylines or points from Microsoft Excel to AutoCAD. InnerSoft CAD

4,548 views

Loading...

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 26, 2011

http://innersoft.itspanish.org/

InnerSoft CAD is a add-on for AutoCAD that install a set of useful tools.

4.2. - Importation of a sets of points in AutoCAD from an Excel sheet

From an Excel sheet, according to two methods:

Simple Method:

This method requires two columns: for the X coordinate and the Y coordinate; a third column is optional for Z coordinate of each point. If any cell in the first or second column is empty or does not contain a numeric value, application will discard the triad of data in that Excel row, and will continue reading the next row. If any cell in the third column is empty or does not contains a numeric value, Z coordinate will be assumed as zero for that point. Index/Text

Method:

This method requires three columns: for the index or text, for the X coordinate and for the Y coordinate; a fourth column is optional for the Z coordinate of each point. If any cell in the second or third column is empty or contains a numeric value, application will discard the triad of data in that Excel row, and will continue reading the next row. If any cell in the fourth column is empty or does not contains a numeric value, Z coordinate will be assumed as zero for that point.

The texts on the first column will be inserted with the X, Y, Z coordinates that the application read in the next three columns.

4.3. - Importation of polylines series in AutoCAD by reading the two coordinates of each vertex from an Excel sheet

From an Excel sheet, according to three methods:

Simple Method:

This method imports a single (only one) polyline. It requires at least two columns: one for the X coordinate and one for Y coordinate of each vertex, with an optional third column to set the elevation of the polyline. If any cell in the first or second column is empty or contains a numeric value, application will stop reading Excel data, drawing the polyline with the vertexes that have collected so far. The first numeric value is in the third column will be used to set the elevation of the polyline. If there is no numeric value in the third column, elevation will be set to 0.

Gap Method:

This method imports series of polylines. It requires at least two columns: one for the X coordinate and one for Y coordinate of each vertex, with an optional third column to set the elevation of the polyline. Application starts to collect a set of polyline vertexes when it finds a first valid XY pair of data. If during the reading it finds any cell in the first or second column that is empty or does not contain a numeric value, it interrupt the series of vertexes and if there is at least two consecutive vertexes it will draw a polyline with the collected data . The app will continue reading data in Excel, and when it finds a valid XY pair will start a new cumulative series of vertexes for a new polyline. Do all this process until the end of the data. Basically, you can use text or spaces for separating individual polylines, that is, for separating sets of numerical data, each of which corresponds to an individual polyline. The first numeric value found in the third column will be used to set the elevation of each polyline.

Index Method:

This method imports series of polylines. It requires three columns: one for the index of the polyline and two more for the X coordinate and Y coordinate of each vertex, with an optional fourth column to set the elevation of the polyline. Application starts to collect a series of polyline vertexes when it finds a natural number –index- with a first pair XY of valid data. If while reading Excel rows it finds one empty cell or no numeric values in the first three columns or it detects in the first column that the index value has changed, it will interrupt the collection of vertexes.

If application has collect at least two consecutive vertexes, will draw a polyline. Application will continue reading data in Excel, and when it finds a valid triad of XY-index, will begin a new series for a new polyline. Do all this process until the end of the Excel data. Basically, you must use an index in the first column to separate individual polylines, that is, for separating sets of numerical data, each of which corresponds to an individual polyline. The first numeric value found in the third column will be used to set the elevation of each polyline.

The index value must be a natural number.

If you checked the Insert Index option, application will insert then index value read from the Excel sheet next to the polylines drawn in AutoCAD. Start From field is not used in this method.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...