How to Export Text to Excel & How to Export Pline Coordinates to Excel using AutoLISP Program

1) In this session you will learn how to export text from CAD drawing to Notepad.
2) In this session you will also learn how to export polyline coordinates to Excel.

[@mohamedalijinnahsheikabdul1223]

This Prof Mohamed Ali Jinnah, in Civil Engineering Field. I have to appreciate you in all aspects
1. Efficiency in Subjects Matter
2. Your English Pronunciation and continuous flow of words like anyone can understand easily.
3. You ask Question and Answering as if Student and Faculty approach
4. No struck in any point of lecture.
But I wanted you, to write bundle and collection of Auto-lisp of Scripts in automating Civil Engineer's Work, although any Engineer's Works.
Try one book which explains 1001 Auto-Lisp Scripts for Every Day works of Engineers.
Wishing you all for ever, May Almighty Blessing be on you and your family members till end of this world.
Tons of thanking for your teaching.

[@cyberCADsolutions]

Thank you very much. I will try my best as you suggested. Please share the video.

[@georgekhaba6436]

time table:
@1:54 program to export text to external file
@10:01 program to export co-ordinates of a polyline to excel
happily finish all videos on autolisp........ so informative and easy to apply
thank you sir and hope there is more autolisp tutorials about blocks and attributes in them

[@cyberCADsolutions]

Thank you. I will try to upload more videos. Please share.

[@1975ghosh]

Very good. Please upload a video to update Dynamic Block property value from csv. where program math property name and update value

[@behruz.anvarovich]

Super, as always, thank you for your efforts.

[@cyberCADsolutions]

Thank you. Please share to your friends and colleagues

[@behruz.anvarovich]

@@cyberCADsolutions Hi sir, how export coordinate from 3D polyline, with cons 10 can't get coordinates, thanks in advance

[@wanrids]

Thanks 100 times

[@cyberCADsolutions]

Thank you. Please share to your friends and colleagues.

[@maryahharzarinajasni3715]

hello sir! can we draw pline by importing the data from excel to Autocad using AutoLISP program??

[@cyberCADsolutions]

For sure madam. I will make a video on this in a couple of days. Please subscribe and keep watching.

[@maryahharzarinajasni3715]

@@cyberCADsolutions thank you sir. I have a query about AutoLISP. Is there have limitation on programming line in AutoLISP? this is because when my coding is too long some of my code can't be run.

[@manuelfernandoespinosacast7717]

excellent video, thank you very much for sharing your knowledge. I have a concern, instead of using the extension (.csv) and used (.xlsx), the routine generates the file for me but when I go to open it it tells me that the file is bad or is of an invalid format, why? Could it be that for the (.xlsx) it is done in another way?

[@cyberCADsolutions]

Lisp can't read or write Excel directly. CSV is a text format file. So use CSV extension only.

[@cyberCADsolutions]

Please share.

[@akkumar9242]

Hello,
I just want to use lisp for DTEXT/MTEXT to Excel Table.
is this lisp useful for text2excel?
Thank You

[@suresh.kmuthu7644]

Hi sir,
Can u pls create a Lisp prgm to place the light fix automatically by asking a no of fixture and type of light in Archi layout.

[@ifty_arain]

Any function to change position of UCS from one object to another in autoLISP program? please help

[@cyberCADsolutions]

As far as I know, no such function available.

[@jahanzaib1992]

Thank you sir

[@cyberCADsolutions]

Thank you. Please share to your friends and colleagues.

[@ifty_arain]

Can we not create an excel file by using file extension .xlsx? I did try, file was created in drive d but couldn't open it.

[@cyberCADsolutions]

We can do using activex methods.

[@ifty_arain]

@@cyberCADsolutions Do you have any tutorial videos on activex methods?

[@shanmukhachari8515]

dear sir,
if i want to extract the text information from table format and i want to output each column as it is mentioned in the cad..and how to save with dwg file name..please slove this sir..

[@Mr.1997-e3h]

Can you make a video for main function with sub function knit working

[@cyberCADsolutions]

Sure my friend. Thank you. Please subscribe and share to your friends and colleagues.

[@Mr.1997-e3h]

@@cyberCADsolutions ok, thanks

[@veerraju6478]

Sir give me a video for coordinates xl to autocad concatenate..plz

[@cyberCADsolutions]

ruclips.net/video/APkFR44OdiM/видео.html

[@vkshettykannadiga3939]

Hi sir can we extract cad text to opened exl file live time by clicking one by one text.

[@cyberCADsolutions]

No.

[@vkshettykannadiga3939]

@@cyberCADsolutions ruclips.net/video/5wtrX8mpm9M/видео.html

[@vkshettykannadiga3939]

Sir like this

[@vkshettykannadiga3939]

@@cyberCADsolutions Thankyou

[@vkshettykannadiga3939]

Sir it's possible???

[@sadamth6714]

Why need "counter 0"?kindly explain

[@cyberCADsolutions]

Index always starts at zero and ends with n-1.

[@sadamth6714]

@@cyberCADsolutionsthanks for the reply.next tutorial when it comes?