Layer list in Excel import

[Anonymous]

Hi,

Looking for a workflow if possible to import a list of layers from an excel file including layer name, colour,line type,plot style etc. 

Thanks in Advance 

[Anonymous]

Sorry for any grammatical error, I'm using google to translate.

Try this:  >>Link<<

Júnior Nogueira.

Por favor,  Aceitar como Solução se meu post te ajudar.

Please Accept as Solution if my post helps you.

[leeminardi · Accepted solution]

Take a look at the options when you give the command -layer and use the concatenate command in Excel to duplicate what you would need to type in.  Pay particular attention to the use of spaces.

For example, I created the following Excel spreadsheet for name, color and linetype. Cell F2 contains:

=CONCATENATE("-layer m ",A2," c t ",B2,",",C2,",",D2," ",A2," L ",E2," ",A2," ")

Fill it down to and copy it to Notepad (I prefer Notepad++)  and save it as a text file with the the extension .scr then t run the script in AutoCAD

[Anonymous]

Worked well.
Thanks for your help

[bycakabo]

I created the list in this way, but only one or a few of the many layers were imported. can you help me?

[leeminardi]

There are two problems in your Excel file.

1. Some of the layers names have space characters. This causes a problem in AutoCAD.  Since " marks are used in Excel to distinguish between text and cell references you cannot use a " in the concatenate function for this.  Instead use CHAR(34), the ASCII character for ".

2. You have "continuous" misspelled in column E.  Fix that!

Here's the new expression for cell H2 that you can fill down.

=CONCATENATE("-layer m ",CHAR(34),A2,CHAR(34)," c t ",B2,",",C2,",",D2," ",CHAR(34),A2,CHAR(34)," L ",E2," ",CHAR(34),A2,CHAR(34)," ")

[Anonymous]

HI

you can also do it by just copy and paste options.

Visit Below link for better understanding...

How to convert Layer list to Excel with all Properties in AutoCAD

[yasin.bosnali]

Hi,

Any way to add Lineweight?

Thanks.

Yasin

[arturops96]

Add: LW, value and the layername again separated by spaces.