difference between visual lisp, autolisp its relationship with excel.

[kelvxd92]

Hello guys,

I'm pretty new to the autolisp and programming stuff. I'm a civil engineer and always been trying to produce higher efficiency at work and very interested in exposing myself to programming. There are several question i would like to ask :

1) As im always deal with excel and autocad, i was wondering how to create a relationship between these: 

For example, i have numbers and stuff in excel, how do i convert it into autocad lines or generally drawings ? how does autocad read my excel numbers ?

2) What is the difference between Visual LISP and AutoLISP ? it sounds the same for me. Depending on the explanation, i would like to expose myself into one of these.

Your kind replies is highly appreciated !! Thanks 

Please ignore me if im in the wrong thread/discussion. 

Regards,
Kelvin

[Ranjit_Singh]

See this link. It may be helpful Auto-Lisp vs Visual-Lisp

[kelvxd92]

That was helpful Ranjit ! Anyway, i still couldn't see how it work between excel and autocad. That would be grateful if you can provide such explanation there ? 😄 

[devitg]

Find attached a sample xls , then you shall open the visual Basic editor , or Alt+F11 key , there you will see basic operations to made from Excell to ACAD  

Maybe yo get a WARNING WINDOW about macros at the xls , chose enable. 

[kelvxd92]

Hi devitq,

That was awesome ! I wish to learn and gain more understanding how it works. That would be much grateful if you can provide me several tutorials for the basics or any websites. Thanks 😄

[devitg]

Hi kelvxd92, I never do it, I only get it for info , but never link XLS to ACAD.

I prefer to do it by lisp , I can make all data in XLS, then save as CSV and use LISP to do whatever I need.

And furthermore, some VISUAL BASIC , are not allowed as far as I know, in new ACAD version.

Example , revert , from Express tools , do not run in 2016.

[kelvxd92]

Do you mind to attached some example of doing by lisp and converting excel to CSV ? How does Lisp read the CSV data ?

[hmsilva]

---

@devitg wrote:

...

And furthermore, some VISUAL BASIC , are not allowed as far as I know, in new ACAD version.

...

---

Hello devitg,

VBA It is no longer distributed with AutoCAD, you have to Download it... Download the Microsoft Visual Basic for Applications Module

@kelvxd92

Terry Miller's GetExcel.lsp It may be a start to acess excel...

Hope this helps,
Henrique

[devitg]

It read line by line , and you have to split columns by lisp , the make what you need . Please send me your XLS example , I will show how to do it. 

[kelvxd92]

@devitq Currently i don't have any sample at the moment. Perhaps you can attach ur own sample and i will study it by myself ? 😄

@hmsilva That was cool, have u ever done any excel data to draw line in autocad ? 😄

[devitg]

kelvxd92

It is a place where you look for help, at least put some of your part. 

maybe what do you need to do. 

[kelvxd92]

Thanks everyone for the kind sharing. I will be studying all this new thing 😄