About Level and Offset of Polyline in excel

[Rabindra Bhatta]

Is there any method so that we can get level and offset of a polyine?

 

Let us assume we have drawn a polyine in zigzag way. A level is provided at one point and we need to find the offset of polyline point and the points level and then export it to excel.

 

Please kindly help.

[SLW210]

I moved your thread to the AutoLISP, Visual LISP & DCL Forum.

[BIGAL]

Yes is the answer as the pline has 2d points you know Y values so can work out all points including Z then send to excel.

 

I do direct to excel others do CSV.

 

Here is pline points as a start. 

 

(setq plent (entsel "\nPick rectang"))
(if plent (setq co-ord (mapcar 'cdr (vl-remove-if-not '(lambda (x) (= (car x) 10)) (entget (car plent))))))
(princ co-ord)

On holidays so limited time may  be later or some one else will jump in.

 

Excel defuns you can use to open Excel and put cell values.

Alan Excel library.lsp

[Rabindra Bhatta]

Thank you very much. But the file after loading shows an error

(Alan Excel library.lsp successfully loaded.
Command:
bad argument type: VLA-OBJECT nil
Cannot invoke (command) from *error* without prior call to (*push-error-using-command*).
Converting (command) calls to (command-s) is recommended.)

 

Edited September 22 by Rabindra Bhatta

[Rabindra Bhatta]

I have a level mentioned and have to export the distance of points in polyline with its level to excel. No any coordinates are required. 

Please kindly help with the problem.

[BIGAL]

The Alan excel.lsp is not a program that you load rather it contains multiple functions that you use in your own code like Putcell. I have limited time at moment someone else may jump in.