I am using Autocad2004. I am trying to write the routine that can draw the line from rectangle centre point to circle centre point according to the data in excel file. I've a bunch of rectangles and circles with the text number themselves. The details of excel data are:
column A : the text number of rectangle
column B : the text number of circle
column C : x-coordinate for rectangle centre point
column D : y-coordinate for rectangle centre point
column A , column B, column C, column D
1, 2, 0.123, 0.223
2, 3, 0.123, 0.321
3, 5, 0.123, 0.400
How to draw line from rectangle to circle accordingly by row that is rectangle no 1 to cirle no 2, rectangle no 2 to circle no 3, rectangle no 3 to circle no 5 etc...
Additional information: The layer names of rectangle, rectangle number, circle and circle number are different.