binding an autocad design to excel date

[Nichi]

then, first of all, good morning to all, I am new to this forum, my name is nicholas, I frequent the i.t.i.s galilei of livorno, I am at the 5th year and therefore I am going to give my examination of maturity. I apologize if I'm in the wrong area of the forum, but then I just signed up and I still have to take confide with the forum, this seemed to me the most suitable section.
coming to the problem, I would love to bring as a thesis a sort (which I imagine for you nn is nothing new) of "automatic drawing"
putting the size of any autocad piece (2010), according to the corresponding value, calculated by formulas on excel. so and way, that if I change a parameter on the excel sheet, then varying for example a diameter, this actually changes me on autocad.

even better would be to use caia, but as I am a little rusty, and the time tightens, I think it is, at the expense, of the figure I would do in the tesina, better to use autocad. If anyone can tell me, if you can do it, and how can you do it, whether by catia or by autocad, I would be enormously grateful, since you are together with the internet, my only source from where to draw such information.


thank you all, I hope to read you soon!

 

[Tristan]

in autocad something so you don't do it unless you put your hand on vba or vsta and write a special program

 

[PlannerRoad]

for simple things, type rectangles, shape had already developed something:
http://www.cad3d.it/forum1/showthread.php?t=25383but you want to do it for anything, it's different.

putting the size of any piece of autocad (2010), according to the corresponding value, calculated by formulas on excel. so and way, that if I change a parameter on the excel sheet, then varying for example a diameter, this actually changes me on autocad.

 

[Giuseppe Mauro]

in autocad I see it basically easy. . .

just find the program draw.lsp:biggrin:

 

[Nichi]

@tristan: very clear I have a friend, graduating in computer science I try to ask him, since I obviously do something like that.

@planner road: I nn is that I want to do it for anything, the idea for now is to have a sheet excel where to large lines, I have the data incoming, and outgoing (n° of turns), the transmission yields, and in the same sheet the various designs, for the various organs of connection, puges, toothed wheels, joints. I admit the data in the design of the piece that I decided to use, through functions, I size it, and on autocad (where I have a standard example by type of piece) , the size of the piece I chose to use fit the dimensions calculated on excell. This is what I define as "automatic drawing" I don't know if this changes anything anyway, but I'll take a look at it.

@giuseppe mauro: sorry, maybe I'm ignorant, but I understand

 

[Onda]

It's not that hard, you can use a vba routine, but you can even do without it.
You have to do an input page, where you put all the necessary data and do the accounts.
then do an output page where you put the commands that create your design.
for example, to make a line between two coordinate points x1,y1 x2,y2 that are in the boxes a1,a2 b1,b2 I write:

=concatena("line "&a1&","&a2&", "&b1&", "&b2&" ")

with patience and dedication you can get a list that you can copy and paste on notepad, create a *.scr file and read it as autocad script.
Obviously you can also do a vba routine that writes the script, launches autocad and reads the file.
I hope I've been clear
wave

 

[Tristan]

It's not that hard, you can use a vba routine, but you can even do without it.
You have to do an input page, where you put all the necessary data and do the accounts.
then do an output page where you put the commands that create your design.
for example, to make a line between two coordinate points x1,y1 x2,y2 that are in the boxes a1,a2 b1,b2 I write:

=concatena("line "&a1&","&a2&", "&b1&", "&b2&" ")

That's not what Nichi asked. he wants to change a parameter in the xls file and see that in autocad it changes the design.

 

[Onda]

It's a simple system to make an excel-driven autocad design without having to plan. and is therefore very close to what has been requested.
Why don't you tell him if it's a useful solution?

 

[Shape]

then, first of all, good morning to all, I am new to this forum, my name is nicholas, I frequent the i.t.i.s galilei of livorno, I am at the 5th year and therefore I am going to give my examination of maturity. I apologize if I'm in the wrong area of the forum, but then I just signed up and I still have to take confide with the forum, this seemed to me the most suitable section.
coming to the problem, I would love to bring as a thesis a sort (which I imagine for you nn is nothing new) of "automatic drawing"
putting the size of any autocad piece (2010), according to the corresponding value, calculated by formulas on excel. so and way, that if I change a parameter on the excel sheet, then varying for example a diameter, this actually changes me on autocad.

even better would be to use caia, but as I am a little rusty, and the time tightens, I think it is, at the expense, of the figure I would do in the tesina, better to use autocad. If anyone can tell me, if you can do it, and how can you do it, whether by catia or by autocad, I would be enormously grateful, since you are together with the internet, my only source from where to draw such information.


thank you all, I hope to read you soon!

Look, I have to see if I find it somewhere because it's the tesina that I brought to maturity.

Obviously at that time... mmm it was the 2000 or 1999 (miiii that old that they are)... returning to us I did not plan and the thesis used precisely a excel sheet that defined the size (forms etc) and as wave sugerito with the concatena command defined me the script for realization (drawing of the piece). of course it was a simple piece (if I don't remember badly a tree of a sewing lady).

the bell was that (I used autrocad 13 at the time) in addition to the design 2d I make the 3d and the "render of the piece, at that point the commission to fact "ohhhhhh".

then always from the excel sheet I created the program to pass then to numerical control.

at the end with a couple of clicks I had my "parametric" reducer designed in 2d and 3d and then came out of the numerical control machine.

In the end I brought home a nice 58 (the story never liked me otherwise it would have been a 60)...to avoid easy battutine we were still in 60esimi ehhhhh :biggrin:.

returning to topic according to me you can do it even without being an expert programmer, of course in the first place you have to define the geometry to realize, define the parameters "variable" and then build it all.

 

[Nichi]

You guys can imagine how grateful I am, I see you have "heart" my problem. I have to ask you to be as much land as possible in explaining what I have to do, today the preparation of the school is different, and with it my ability to understand what you say. Anyway, I want to do this, I want to amaze and I want to do something good.
I should like to say that I have understood, I would first exclude the method with vba or vsta, which seems to me to have understood that it is in fact the programme, which I can do, and that I can explain to the committee. I think you all understand what I want to do, so if someone wants to spend five minutes of his time to spy out in detail, the method, which I think I understand is the most suitable for my abilities that quoted by wave and shape, I would be eternally grateful.

Meanwhile: wave the input and output page where they have to be on excell? concatena is a command of autocad or excell?

shape: what is this rendering speech?

 

[Shape]

Meanwhile: wave the input and output page where they have to be on excell? concatena is a command of autocad or excell?

shape: what is this rendering speech?

hope not to run too much... So... .

1)autocad can you use it from 1 to 10 how much?

2)You can use it as much as 1 to 10?

because it is essential to understand where you leave.

You know what an autocad script is? I'll explain it to you so you better understand the wave concept.

autocad uses both keyboard commands (command) and icons, and so far nothing new, a script that runs from the tool->exegui menu is nothing but a set of commands written in a text file that autocad reads and executes.

step 2 how to create a scipt:
a script is nothing but a text file

to make a simple example here is a script to draw a rectangle:

psyche
0.0
100,0
100,100
0.100
0.0


the concatena command suggested by wave does nothing but merge two or more cells in excel and return a string (text) with coordinates of a point or center.
of course in addition to coordinates there will also be commands etc for that not enough the concatena.

But now you have to tell us more or less what kind of geometry you want to achieve otherwise it is difficult to guide you

 

[Onda]

It already explained shape,
in any case:
concatena is an excel comado that serves to merge more information into a single string that then becomes the autocad command.
in my example the concatena serves to combine the command "line" (in English) at the beginning and end summit, present in four distinct cells.
input and output page must be excel.
then to make the output you can make paste copy on a notepad text sheet or write a very simple vba macro.
for which you strut the sheet in this way:
first sheet: part of input of the dimensional quantities.
at the bottom do any calculations.
second sheet:
put the autocad commands that will be a series of chains so that the necessary command comes out.
Pay attention to spaces
autocad takes space as an enter, so an incorrect space and nothing works!!

 

[Shape]

an example is worth more than a thousand words.

look at the annex obviously is a trivial thing but this is the basis.

I have marked you to make copy/paste of the text in autocad to avoid creating the text file etc ... is only demonstrative.

 

[Shape]

you can also give a read to this tutorial that is well done
http://autocad.compago.it/14-programmazione/script/20-guida-introduttiva-agli-script-per-autocad.html

 

[tir]

tutorial script

 

[Onda]

I recommend setting excel with international options in English.
means that the decimal separator must be the point and not the comma, as in Italian.
this because autocad recognizes the comma as a separator between the coordinates and the point as a decimal separator.

 

[Nichi]

sisi, it is that I had never used concatena, cmq now finish one thing then in the afternoon I try and I let you know, in the meantime thank you very much

 

[Nichi]

I tried, what you gave me, it works very well, obvious that for what I want to do I will need to learn all the "scripts" (it seems to me the term is those) necessary, for quotas, look for things here, that so far or done "manually"

 

[Shape]

I tried, what you gave me, it works very well, obvious that for what I want to do I will need to learn all the "scripts" (it seems to me the term is those) necessary, for quotas, look for things here, that so far or done "manually"

exactly, the script is nothing but the written form what you would do manually.

in this who uses autocad from the first versions, that is almost only from command line, is very advantaged because the syntax of the commands knows it by memory, in the scripts are important also the spaces and the bosses, that are read by autocad as sending and/or confirmation

if you need help now you know where we are!

 

[Nichi]

then so far, nn there are problems for dissected views, transmission organs such as pulley wheels or trees, which as you can well imagine are easily executable, with the polyline command. My question is in short, can I copy and paste a script, put multiple different operations? for example in the sectional view, polylinea, fittings and quotas?
Obviously in the front view, I will use other commands usually circumference, i.e. the juice is I can put more than one function, or I have to copy/paste every script, for every function different from polylinea, which obviously allows me to draw more lines with the same command, because if so nn it was, I should do up it is copy and paste several things, and at that point nn it would be more the same thing.
in case the syntax of, mainly: Can I find you in the links above?