topic Re: Copy Paste from Excel Cells into Command Line in AutoCAD LT Forum

Copy Paste from Excel Cells into Command Line

Anonymous — Mon, 17 Apr 2017 09:34:32 GMT

Dear Experts

i was copy pasting from many years from Excel Cells into Command Line,

recently i am facing problem while pasting it into Command Line,

earlier each cell was taking "enter" command

now it is ignoring the cell and pasted in a single row..

for example if i have copied cells A1 to A5 which are 1 to 5

earlier it was pasted in command line like

now its pasting like 1 2 3 4 5

any suggestions please

Thank You

Re: Copy Paste from Excel Cells into Command Line

pendean — Mon, 17 Apr 2017 12:03:12 GMT

Is each number in a unique cell in Excel? Or are that all in the same cell?
Show us

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Mon, 17 Apr 2017 12:12:15 GMT

Hi Sir,

Thanks for Reply

in Cell A1=Text1

in Cell A2=Text2

in Cell A3=Text3

in Cell A4=Text4

in Cell A5=Text5

text 1 to 5 are my choice..

here only the solution i am looking for is "for the last 10years every time i copy paste from these cells, at command line, it takes enter after each cell"

if i press f2, it was looking like this in past

Text1

Text2

Text3

Text4

Text5

but now problem is, it appears like this in Command Line - Text1 Text2 Text3 Text4 Text5

Re: Copy Paste from Excel Cells into Command Line

pendean — Mon, 17 Apr 2017 12:29:44 GMT

Thanks. So far it looks good.
What is your LT version? Windows version/ Excel version?

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Mon, 17 Apr 2017 12:40:29 GMT

ACAD 2014 - Student Version

Windows 7 Professional

Excel 2013

Re: Copy Paste from Excel Cells into Command Line

pendean — Mon, 17 Apr 2017 14:29:36 GMT

Thanks: I'm not able to replicate the problem here at all.
Create a new Excel spreadsheet and create your cells again, then copy/paste: still an issue?

Re: Copy Paste from Excel Cells into Command Line

steven-g — Mon, 17 Apr 2017 20:22:21 GMT

I can't reproduce this issue even if I try, how are you going about the copy and paste commands, keyboard shortcuts ctrl+c and ctrl+v or are you going through menu commands? Screen shots of both Excel and Autocad might show us a clue.

If you just make the Autocad screen active in place of the command line, and then paste (which is the _pasteclip command) does it show up correctly as a vertical column of cells, or is it transposed, and another thing to try would be pasting from Excel into notepad, just to check if the problem is coming from Excel or pasting into Autocad.

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Tue, 18 Apr 2017 06:36:17 GMT

Dear Sir,

i am sorry if i confuse with my query..

my query is not for pasting the text..

i want to paste the text into command line,

its like, if i have to make a number of circles i used to do like this

in Excel

Cell A1 C

Cell A2 2,2

Cell A3 10

Cell B1 C

Cell B2 4,4

Cell B3 10

i copy A1 to B3 and paste in command line, i can see 2 Circles with radius 10 at 2,2 and 4,4 centers.

last years i copy pasted in different systems with different configurations..no problem

recently i am facing this problem with new system at new site office..

problem is "in command line it is pasted like C 2,2 10"

it was taking enter after pasting each cell,

means

after pasting C, it is taking enter

after pasting 2,2, it is taking enter

after pasting 10, it is taking enter

but in this new system it is pasted like C 2,2 10 (please note that my actual inputs and commands are different than what i mentioned above)

Re: Copy Paste from Excel Cells into Command Line

steven-g — Tue, 18 Apr 2017 09:47:19 GMT

I understand the problem, I asked about pasting the values as text into both notepad and the Autocad modelspace area, just to see if we can figure out how and where it is going wrong, at the moment we don't know if the data is being placed onto the clipboard incorrectly from Excel, or if it is Autocad that is reading that information incorrectly. When you paste the data as text, is it pasting as a column or a row in other applications?

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Tue, 18 Apr 2017 10:21:33 GMT

Hi Sir,

i think it is morning there,

here it is 1PM..

while waiting for your reply..

i have gone through the problem and found my question was not clear..

now i got where i have struck..

actually i am trying to insert block with attribute..

i am copy pasting this from excel to command line

EXCEL

-i	block name	2,2	1	1	0	my text
-i	block name	4,4	1	1	0	my text

Command: -i -INSERT Enter block name or [?] <layoutpoint>: block name 2,2 1 1 0 my text

Command: -i -INSERT Enter block name or [?] <layoutpoint>: block name 4,4 1 1 0 my text

i understand that since it is block name it is merging all the cell together, not taking enter after "block name"

if i am doing it for Circle command it is Ok.

c	2,2	10
c	4,4	10

Command: c CIRCLE
Specify center point for circle or [3P/2P/Ttr (tan tan radius)]: 2,2
Specify radius of circle or [Diameter] <20.0000>: 10

Command: c CIRCLE
Specify center point for circle or [3P/2P/Ttr (tan tan radius)]: 4,4
Specify radius of circle or [Diameter] <10.0000>: 10

Now for Omitting this merging, we need solution, hope you will solve

Re: Copy Paste from Excel Cells into Command Line

steven-g — Tue, 18 Apr 2017 10:59:08 GMT

I'm in Europe, and at the moment the time is 12.45 (lunch time).

Yes that clears up the problem, in most cases when Autocad expects a text entry it will then ignore any spaces and not treat them as it normally does to separate commands. In order to fix that you have to make sure that anytime you need to enter a name like this that it is the last item in the excel cell, and any other commands are actually isssued in the next line of code, it's not easy to explain but your excel cells should look like this

-i block name
2,2 1 1 0 my text
-i block name
4,4 1 1 0 my text

which means you will have to add in extra lines into your excel data so that you have 2 cells for each block insertion (sometimes adding quotes around a text item will work but not always)

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Thu, 30 Nov 2017 17:03:11 GMT

Sorry for raising an old thread

I have an issue with a macro to paste into AutoCAD.

If in Excel I use Ctrl + C, and in AutoCAD select the command line and use Ctrl + V, the contents of the cells, (the first cell contains the LINE command) is pasted and executed to draw a simple shape.

If I try to use a Paste command (PASTECLIP), the Excel cells are pasted to the drawing in a AutoCAD table...

Is there a way of pasting the contents of the clipboard to the command line?

TIA

Tim

Re: Copy Paste from Excel Cells into Command Line

steven-g — Thu, 30 Nov 2017 17:17:34 GMT

You have to make sure the command line is active, or it will paste into the drawing area as an ole object.

So click twice inside the command line (not double click, just twice slowly) the first click only usually makes Autocad the active window again after leaving Excel, and the second click makes the command line active. You should see the cursor flashing inside the command line, and then use Ctrl+v

Re: Copy Paste from Excel Cells into Command Line

Anonymous — Fri, 01 Dec 2017 08:46:51 GMT

Steven thanks,

I can operate this using the Ctrl+v command in the command line, this works as you describe.

I am actually trying to create a macro that will do the same, so far I have

^C^Ccommandline;PASTECLIP;

but the above is pasting the Excel spreadsheet into the drawing, not the contents into the command line.

is there another command that I can use instead of PASTECLIP?

Re: Copy Paste from Excel Cells into Command Line

steven-g — Fri, 01 Dec 2017 10:08:33 GMT

That's not possible in LT, at least I have never found a way.