topic Re: Layer list in Excel import in AutoCAD Forum

Layer list in Excel import

Anonymous — Tue, 03 Apr 2018 13:40:15 GMT

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

Re: Layer list in Excel import

Anonymous — Tue, 03 Apr 2018 14:11:00 GMT

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.

Re: Layer list in Excel import

leeminardi — Tue, 03 Apr 2018 15:05:19 GMT

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

Re: Layer list in Excel import

Anonymous — Mon, 09 Apr 2018 15:00:44 GMT

Worked well.
Thanks for your help

Re: Layer list in Excel import

bycakabo — Tue, 04 Dec 2018 08:58:18 GMT

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

Re: Layer list in Excel import

leeminardi — Tue, 04 Dec 2018 13:48:57 GMT

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)," ")

Re: Layer list in Excel import

Anonymous — Tue, 04 Dec 2018 17:34:12 GMT

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

Re: Layer list in Excel import

yasin.bosnali — Tue, 25 Aug 2020 12:03:11 GMT

Hi,

Any way to add Lineweight?

Thanks.

Yasin

Re: Layer list in Excel import

arturops96 — Tue, 01 Mar 2022 18:21:40 GMT

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