TheSwamp

Code Red => AutoLISP (Vanilla / Visual) => Topic started by: SeanyB001 on March 30, 2015, 01:51:24 AM

Title: Excel Layer Spreadsheet To AutoCad
Post by: SeanyB001 on March 30, 2015, 01:51:24 AM

Hi Guys,
I have a queery if anybody has any ideas on Creating a Set of layers in Excel and then using that spreadsheet to control a group of drawings with that spread sheet by importing them into the drawing from Excel.
I can write some lisp routines more on the simple side of things and i have been researching for a while as im pretty new to this and eager to learn.
I have been using a layer state and wrote a lisp import into the drawings etc and running it through  script, but this is annoying to go into the control drawing change the layers and then re export etc.

I have seen routines like this so i am aware that it can be done:
https://www.youtube.com/watch?v=f3krAjjkKm0

I do know you can ctrl + C the layer box in cad and paste into excel and it has everything there.
but going the other way seems like it could be a little more challenging.
I would be much appreciated for your Help and ideas.

Thanks Sean

Title: Re: Excel Layer Spreadsheet To AutoCad
Post by: mkweaver on March 31, 2015, 08:44:12 AM

What is the format of your spreadsheet?  Can you post an example?

Title: Re: Excel Layer Spreadsheet To AutoCad
Post by: ChrisCarlson on March 31, 2015, 08:55:36 AM

http://www.cadtutor.net/forum/showthread.php?57570-Layer-Creater-Lisp-Routine-Issue

Does this help?