Import form Excel layers to Autocad
@dseshanZQS9M wrote:
.... I need to use Dashed and Centre line Type,
If it's ultimately going into a command-line Layer command, it is not necessary for those linetypes to be already loaded into the drawing. If they're linetypes that come with AutoCAD, a Layer command will find them [which other approaches, such as (entmake)ing the Layers, won't if they're not loaded].
What is needed is to incorporate a linetype component into the Layer command. In @leeminardi's latest spreadsheet file, there is nothing of that, because all the Layers there are to be Continuous linetype, and that's the default, so it doesn't need to be spelled out in the Layer command. It should be "addable" easily enough.
Attached is a sample Excel file that includes the specification of line type for the created layers. The syntax is a bit unwieldy but keep in mind that char(34) is used to create a " for use in the vlisp command that should not be confused with the " needed for the Excel concatenate function.
You can also try the CsvLayers freeware tool - see:
https://www.cadforum.cz/en/how-to-create-dwg-layers-from-a-list-in-csv-excel-tip7193
Vladimir Michl, www.arkance-systems.cz - www.cadforum.cz
