import layer list from excel file
Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DXF formats, Design Review, AutoCAD web, Drive, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=4959
Printed Date: 10.Jul.2026 at 21:11
Topic: import layer list from excel file
Posted By: Macieto
Subject: import layer list from excel file
Date Posted: 14.Dec.2010 at 07:48
|
HI, I want to import layer list form excel file and I found a beautiful tool for that: http://www.cadforum.cz/cadforum_en/how-to-create-dwg-layers-from-a-list-in-csv-excel-tip7193 - http://www.cadforum.cz/cadforum_en/how-to-create-dwg-layers-from-a-list-in-csv-excel-tip7193 But this tool does not do one thing - tool doesnt import descriptions of layers. Does anybody know a tool that will import all data for layer properties manager? (name, on/off, freeze/thaw, lock, color, linetype, lineweight, plot, description) Description is most important for me. Thanks |
Replies:
Posted By: Vladimir Michl
Date Posted: 14.Dec.2010 at 08:12
|
There is a simple fix - just update to the latest version of CsvLayers - see Download. ------------- Vladimir Michl (moderator) ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner |
Posted By: Macieto
Date Posted: 14.Dec.2010 at 08:25
Right now I have downloaded todays version of csvlayers and still there is no possibility to import descriptions of layers |
Vladimir Michl wrote:Posted By: Vladimir Michl
Date Posted: 14.Dec.2010 at 08:52
|
The older version may be still stored in your browser cache. Try the direct link http://www.cadstudio.cz/dl/csvlayers.zip" rel="nofollow - http://www.cadstudio.cz/dl/csvlayers.zip and make sure the VLX filedate is 14.12.2010. ------------- Vladimir Michl (moderator) ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner |
Posted By: Macieto
Date Posted: 14.Dec.2010 at 09:19
You were right Vladimir! Now I am able to import descriptions too but there is one more problem because in layer properties manager at the end of the description semicon occures. So if the description in CSV file is my hidden line than in layer properties manager You will see my hidden line; Is there any way to det rid of that semicon? |
Posted By: Vladimir Michl
Date Posted: 14.Dec.2010 at 09:59
|
That's strange - the layer description is just read from the CSV file, no other modifications are done to it. Are you sure your line in the CSV file does not end with the semicolon?
------------- Vladimir Michl (moderator) ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner |
Posted By: Macieto
Date Posted: 14.Dec.2010 at 10:25
Vladimir after I deleted that 3first lines of example in CSV file it seems to be ok - there is no possibility to have lineweight bigger than 1mm but i can live with that. |
Posted By: Vladimir Michl
Date Posted: 14.Dec.2010 at 11:46
|
Can you post the contents of your CSV file? Both cases seem to work fine here:
1) lines starting with ";" are simply ignored
2) any AutoCAD lineweight can be applied - replace 25 in the sample by 200 and you will get a 2.0mm thick line ------------- Vladimir Michl (moderator) ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner |
Posted By: Macieto
Date Posted: 14.Dec.2010 at 12:05
I was about to paste my CSV code when I found the mistake. 1) i was using not standard lineweights (fe. 250) 2) i was using linetypes that hasnt been loaded in my ACAD (fe. "GAS") Now after reading what ACAD has written in "commandline" after "csvlayers" command I corrected my CSV file and everything seems to be OK. It would be much better if ACAD would send some kind of "alert dialog box" saying that sth is wrong, but on the other hand I should always read ACAD respons in "commandline" :-) thanx |