Pasting a multiple line set of coordinates for multiple holes.

[gbestwick]

Hello!

I'm doing a small project that requires me to enter a whole pile of holes of all the same diameter who's locations are calculated in Excel.

Now, I know that you can choose your hole type and set your diameter, but you can only type in a single set of coordinates at once. Is there some way of me delineating sets of coordinates on a single line?

For example:

0,1/0,2/0,3

or

{0,1}{0,2}{0,3}

Which would then get me holes at 0,1 0,2 0,3

(I don't really need holes at those coordinates, so please don't talk about math functions or copy/pasting)

Thanks!

[Husky]

Hello gbestwick - welcome to the forum.

Hello!

I'm doing a small project that requires me to enter a whole pile of holes of all the same diameter who's locations are calculated in Excel.

Is the distance from hole to hole always the same?
Those holes are oriented evenly on a line (1) or an array (2)?

Husky-2017.02.28-01.png (17.94 KiB) Viewed 1873 times

[andrew]

please don't talk about math functions or copy/pasting)

Actually, I think copy / pasting the whole list of coordinates might be the quickest and easiest option:

First, get the coordinates into the following format (for example through a CSV export from Excel):

x1,y1
x2,y2
x3,y3
...

For example:

12.5,5.4
7.3,2.5
23.5,5.6
...

Copy the whole list of these coordinates to the clipboard (select the multiple lines from the plain text or CSV file and copy to clipboard in a text editor).

Then, start the tool Draw > Circle > Center, Radius (or any other tool that accepts coordinates as input).

Click into the command line input field or press the space bar to make sure the command line has the keyboard focus.
Paste the list of coordinates into the command line input field using Ctrl-V (or Cmd-V on macOS).

QCAD now enters the list of coordinates just as if you would have entered them one by one manually, drawing a circle at each coordinate.