CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 4281

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 Load it with APPLOAD and type the CSVLAYERS command.

An example of the layer definition file:

;CsvLayers sample file
;Expected format:  
MyHidden,4,Dashed,1,1,1,25,"This will be hidden,OK?",50
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 ";")

100% *  CAD 
29.1.2010    27351×  

See also:
Tip 13014:StickLay - unchangable, fixed layers for selected DWG objects.
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.

Back   All CAD Tips

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   

Export 3D VRML scenes from AutoCAD and Inventor
VRMLout 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.