Author Topic: Excel Layer Spreadsheet To AutoCad  (Read 4660 times)

0 Members and 1 Guest are viewing this topic.

SeanyB001

  • Guest
Excel Layer Spreadsheet To AutoCad
« 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


mkweaver

  • Bull Frog
  • Posts: 352
Re: Excel Layer Spreadsheet To AutoCad
« Reply #1 on: March 31, 2015, 08:44:12 AM »
What is the format of your spreadsheet?  Can you post an example?

ChrisCarlson

  • Guest