Creating layers with external editor?

[Marionette]

I have to create a template file according to one of our clients' standards and I wonder if there is a way to import all the layer names, color, ltypes & descriptions from an Excel table or some other editor.

I know there are routines exporting all the layer setup to a .csv file, but I couldn't find a way to reverse the process.

I'm using acad2006.

[RAYMOND]

i do this via a lisp routine..

 

if you want it thru an excel sheet

you can write a VB app..

 

example...

 

(defun c:611 ()

(command "layer" "m" "m_ground" "c" "1" "m_ground" "" "")

(command "layer" "m" "m_pavment" "c" "2" "m_pavment" "" "")

);611

 

:D

[Kerry Thompson]

Hi

I often use Excel to write script files to undertake this type of task. Setup the list of layer names and their properties in the respective columns of the spreadsheet and concatenate the columns into a string stored in a resultant column. Copy the column of results into a file with the extension .scr and drop it into your AutoCAD session. The script will run creating the layer set. This layer script can be called from menus and tool palettes.

 

Kerry