CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 2199 

CAD tip CAD tip # 7193:

Question CAD 
 %  platform  category 
Q - question

How to create DWG layers from a list in CSV/Excel?

A - answer Using the free utility CADstudio CsvLayers you can automatically create (import) an arbitrary list of layers to your DWG drawing by reading in a text file with layer definitions.

You can create the layer list in Excel (CSV - comma-delimited values format), or type it in a text editor. The list can contain either the layer names only, or also their properties - color, linetype, lineweight, plot/noplot, visibility… Possible already existing layers will be redefined with the properties read from the CSV file.

The requested linetypes must be preloaded or they are autoloaded from the default .LIN file. Colors are supported only from the ACI palette (indexed). The parameters you don't want to set can be omitted.

You can download the application CsvLayers from www.cadstudio.cz/download. Load it with APPLOAD and type the CSVLAYERS command.

An example of the layer definition file:

  
;CsvLayers sample file
;Expected format:  
;LayerName[,Color#[,LineType[,NoPlot(0/1)[,Off(0/1)[,Freeze(0/1)[,Lweight#[,Description[,Transparency#]]]]]]]
;  
MyHidden,4,Dashed,1,1,1,25,"This will be hidden,OK?",50
YellowLayer,2,GAS  
Prague  
Ceske Budejovice,,,,,,,My hometown

Created layers

The command LAYERS2CSV can export the CSV layer definition file from your existing drawing.

Enclose descriptions in double quotes ("") to include commas. You can preset your own delimiter by setting:

(setq _CSVdelimiter ";")

ACADADTACADMCivilMap
100% *  CAD 
29.1.2010    24457×  

See also:
Tip 12392:Export unfolds of sheetmetal parts to DXF - parameters for iLogic and VBA
Tip 11868:Open just a part of a DWG drawing - layers, views.
Tip 11160:Dynamic display of layer/block/text style/linetype properties.
Tip 10693:List of blocks (incl. nested blocks) used in a DWG drawing.
Tip 9843:How to add Classic workspace (toolbars) to AutoCAD 2015?


Back   All CAD Tips All CAD tips&tricks



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Track your time spent working on AutoCAD or Revit jobs - automatically with
CADstudio JobTime More info


Please use these tips at your own risk.
CAD Studio is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist