• This forum is the machine-generated translation of www.cad3d.it/forum1 - the Italian design community. Several terms are not translated correctly.

data cells eexcel in autocad texts

  • Thread starter Thread starter domenicoMori
  • Start date Start date

domenicoMori

Guest
Good morning.

I would have the need to insert data in an excel file inside the quota texts, and this data should be updated if I deceive the excel.

Say hi.
 
I don't know how to plan in .net.
I would also be fine to convert the excel file to any other format or import it to any other program as long as I update those values data in the quotas.
greetings and thanks for the answer.
 
I would also be fine to convert the excel file to any other format or import it to any other program as long as I update those values data in the quotas.
If you don't know how to plan and/or you don't have anyone who can do it for you, said in plain words, you attack. there is no native autocad command able to read a file, of any type, and write its contents in one or more quotas
 
If the excel table imported it as an object in autocad? would there be a way to make him read those values and write them where I say in the quota?
 
a system is there, it takes an excel file with macro that imposes a series of lisp variables inside autocad, type varr1c1, varr1c2 etc. taken from the various cells, replace to the value of the quotas the data field "lispvariable" selecting the variable lisp.
practically, dwg file and open excel, the macro will set variables, in autocad it will be enough to update the fields or regenerate the design.
 
Although apparently not interested in the applicant, the attachment contains the xlsm file that serves to set the variables in the current design, the dwg with a quoted rectangle with the quota values replaced with the lispvariable field, rpdim_l and rpdim_h.
variables are string values, the number of decimals is set in excel.
modifying the values in excel, the dwg is updated.
 

Attachments

Hello.
first of all thanks to the answer. I care, but it doesn't work. with autocad and excel both open, modifying column b of excel file opens to me the visual editor basic of excel returning an error of "impossible to find the project or the library". Maybe I need to install some excel add-ons?
 
in the vba editor select tools/references, remove the check from the autocad library 2021 and select the version you use.
 

Forum statistics

Threads
44,997
Messages
339,767
Members
4
Latest member
ibt

Members online

No members online now.
Back
Top