script di ricerca su excel

[erlaziale_85]

Hello everyone,
I'm a new user and I've just been trying to figure out autocad.
I ask you experts if you can create a script that can verify that a list of data on an excell table (example of simple tags or names) are all present in a dwg and return me a positive or negative answer. For example, I would like to know if in a table excel there are in my dwg the names: stefano and marco... if they are all present I give positive answer otherwise tells me what are missing.
quesot i need because I usually have hundreds of tags to do, you can imagine that the verification of excell tags on autocad is very long and I can make mistakes.
thanks in advance to all for the help.

 

[erlaziale_85]

Good morning to all,
Perhaps yesterday I was unclear, but it is difficult for me to explain because I am unfamiliar with this.
cmq I look for a way to search and verify the tags(names in text format) present in a dwg with a excel file.
it would already be useful to know if there is a way, then on this create a macro or script.
example a excel file with type names: I want to search these names in a dwg file and export an excell file (or even the same modified) with the search result.
I've already seen that there's a dead command... and it's already very useful.
thank you all again and I wish you a good day

 

[erlaziale_85]

hello to all and good start of week. . Can no one answer my question?

 

[MBT]

I'm a little hard to figure out what you need exactly.
However, try to see if the _dataextraction command can help you
as a result you should get an ascii file containing all the attributes present on the drawing and their value
this file you can import it into xl and from them do all searches and filtrations you want

 

[erlaziale_85]

thank you so much for the answer.... I look for a "auotmatic" way of doing what you said... Imagine having an excel file with name column... example: guy pippo caio and sempronio... These names should be present in a dwg planimetry (e.g.: carcad-designed equipment that is called that way)... I'm interested in checking these names in excels are present in the dwg and returning an answer... For example, they lack names, which are and if there are doubles.
_dataexstraction should be benign...but can you enter data on an existing excel sheet without however overwriting (for example in a new column)?
thanks again for the answer

 

[MBT]

Mah. integrating xl with autocad is not impossible, but having never done it I don't know what to tell you
by the way.. the names present in xl should "fight" with what in autocad? with blocks or tags of attributes?

 

[erlaziale_85]

attributes and blocks tags

 

[MBT]

I don't know what to say.
You could make a vba uploading the dataextraction, add it to the queue to the existing data and call the function that format duplicate values, see who is there or what is missing.
but I don't know how to do it "interactive" with autocad