topic Copy & Paste blocks from excel to command line in AutoCAD Forum

Copy & Paste blocks from excel to command line

Anonymous — Sun, 19 Apr 2020 11:23:53 GMT

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

Re: Copy & Paste blocks from excel to command line

Moshe-A — Sun, 19 Apr 2020 11:32:40 GMT

@Anonymous hi,

please upload the dwg + excel files

moshe

Re: Copy & Paste blocks from excel to command line

Anonymous — Sun, 19 Apr 2020 12:15:45 GMT

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

Re: Copy & Paste blocks from excel to command line

Moshe-A — Sun, 19 Apr 2020 12:42:07 GMT

@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

Re: Copy & Paste blocks from excel to command line

Anonymous — Sun, 19 Apr 2020 12:59:35 GMT

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

Re: Copy & Paste blocks from excel to command line

Moshe-A — Sun, 19 Apr 2020 13:07:50 GMT

this is a legal autolisp code line

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

Re: Copy & Paste blocks from excel to command line

leeminardi — Sun, 19 Apr 2020 14:16:21 GMT

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" "" "" "")

Re: Copy & Paste blocks from excel to command line

Anonymous — Tue, 28 Apr 2020 07:01:10 GMT

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