Copy & Paste blocks from excel to command line

[Anonymous]

Hi All

I have been trying to copy & paste a block from an excel sheet when I paste into command line (-Insert Double socket 222,333) I get a box wanting a substitute block, but the block is already in the blocks file, pic attached any help would be greatly appreciated.

Chris 

[Moshe-A]

@Anonymous  hi,

please upload the dwg + excel files

moshe

[Anonymous]

Hi

Please find drw attached the excel sheet only has this at the moment(-Insert test 222,333)   which I am pasting into autocad command line

Regards

[Moshe-A]

@Anonymous  hi,

if you want to insert a block why don't you use the insert command?

the autolisp code you are pasting is incomplete and that's why it doesn't work.

moshe

[Anonymous]

Hi 

I use pline all the time from a spreadsheet to plot lines so was hoping to do the same with a block for multiply insertions could you tell me what is missing from code

Thank you

[Moshe-A]

this is a legal autolisp code line

(command "-insert" "test" "222,333" 1 1 0) 

[leeminardi · Accepted solution]

You can use the Excel concatenate function to build a vlisp command to insert the cells.  I used char(34) to create the quotes around some of the parameters in the insert command.

You can copy the contents of column D off the spreadsheet into the command line of AutoCAD to add multiple instances of many blocks.

Cell D2 contains:

=CONCATENATE("(command ",CHAR(34),"-insert",CHAR(34)," ",CHAR(34),A2,CHAR(34)," ",CHAR(34),B2,",",C2,CHAR(34)," ",CHAR(34),CHAR(34)," ",CHAR(34),CHAR(34)," ",CHAR(34),CHAR(34),")")

Which yields a statement like the following:

(command "-insert" "Doors_ExtDbl_w-Glazing_Bars_1 - 1510x2110mm-10509454-Level 0" "1000,600" "" "" "")

[Anonymous]

Hi Thank you very much for your reply,but I still have the warning message,drives you crazy ? Picture attached