Polylines dimensions export to excel

[milivojekrstanovic]

Can anyone please help me. I am trying to find a lisp which could help me with making of the bbs (bar bending schedule). It means that I want to export my polyline dimensions from autocad drawing to excel file. Every dimension should be in its separate column. Thanks.

[pbejse]

Can anyone please help me. I am trying to find a lisp which could help me with making of the bbs (bar bending schedule). It means that I want to export my polyline dimensions from autocad drawing to excel file. Every dimension should be in its separate column. Thanks.

You mean the length of the polyline?
Columns? 15 polylines 15 columns?

Will there be a test for equal length and a row for quantity?

Would it be better if Rows for length and colums for quantity?

Retriving the length is fairly easy

(defun c:test ( / aDoc ss )
(vl-load-com)
(setq aDoc (vla-get-ActiveDocument  (vlax-get-acad-object)))
	(if  (ssget '((0 . "LWPOLYLINE")))
	  (progn
	  	(vlax-for itm (setq ss (vla-get-ActiveSelectionSet aDoc))
	  		(princ (strcat "\nPolyline length :\t"
				       (rtos (vlax-curve-getDistAtParam
					       itm
					       (vlax-curve-getEndParam
						 itm
					       )
					     ) 2 2)
				       )
			       )
		  )
	    (vla-delete ss)
	    )
	  )(princ)
  )

[milivojekrstanovic]

You mean the length of the polyline?
Columns? 15 polylines 15 columns?

Will there be a test for equal length and a row for quantity?

Would it be better if Rows for length and colums for quantity?

No. I mean length of each segment of polyline. I want to make a separate column for all polyline segment lengths. I plan to make one layer for all polylines which could have the same code (same type). Al of those in that layer would be bars (polylines) of shape code (label) for example 61. So that when you extract it to excel, you get a new row for every polyline, and the name of the row is the name of the layer. So first column would be name of the polyline, and the rest of them would be A, B, C, D, E... lengths of the segments of polylines. And you get a new row for every polyline, no matter if they are the same layer or not.

[pbejse]

No. I mean length of each segment of polyline. I want to make a separate column for all polyline segment lengths. I plan to make one layer for all polylines which could have the same code (same type). Al of those in that layer would be bars (polylines) of shape code (label) for example 61. So that when you extract it to excel, you get a new row for every polyline, and the name of the row is the name of the layer. So first column would be name of the polyline, and the rest of them would be A, B, C, D, E... lengths of the segments of polylines. And you get a new row for every polyline, no matter if they are the same layer or not.

Post a snapshot of the excel forrmat milivojekrstanovic

And welcome to the forum

[milivojekrstanovic]

Post a snapshot of the excel forrmat milivojekrstanovic

And welcome to the forum

A, B, C, D .... are the lengths of the segments of the polylines. Shape code column would be the name of the layer.

[pbejse]

A, B, C, D .... are the lengths of the segments of the polylines. Shape code column would be the name of the layer.

Hmm not as simple as i thought it would be but doable

What about the Datas for the first 7 columns?

[milivojekrstanovic]

Hmm not as simple as i thought it would be but doable

What about the Datas for the first 7 columns?

it would be great if they could be assinged to the polyline somehow in cad, so that they are generated automatically in excel. all except total length, it has special formula.

[pbejse]

it would be great if they could be assinged to the polyline somehow in cad, .

Need to get back to you on that one.. for now i'll try to write a simple one.

One more question, will it be one excel file for inidvidual drawing? and not appending the existing worksheet?

[milivojekrstanovic]

Need to get back to you on that one.. for now i'll try to write a simple one.

One more question, will it be one excel file for inidvidual drawing? and not appending the existing worksheet?

Yes one excel file per one dwg.

[pbejse]

Yes one excel file per one dwg.

Ok, while i'm working on the code, try searching the forum for similar request