excel file to block in drawing

[Anonymous]

I have a task that will touch multiple drawings. (like hundreds - thousands) what I want is a lisp that can update a block with information from an excel file. I have looked through the forums and haven't found much for this. 

The needs for this lisp are:

     search excel for specific number (ie. 05-FT-1825)

     place information about this number from excel into a block in a drawing. (the drawing will be open with the block inserted.) (this would of course still take a bunch of time but not near as much as manually searching and inserting information)

wants for this lisp:

     Look at excel and find a number (ie. 05-FT-1825)

     Open a folder of drawings and find the number in the drawings (Looking for 05-FT-1825)

      If the number is found place a block in the drawing with information from the excel file

      if the number is not found create a new drawing from a template that has the block in it. insert the information from excel. save the drawing in a new folder under the number (ie. 05-FT-1825) 

Once this is finished move on to the next number in excel. 

A few possibilities for errors:

     The numbers may be different (ie. [excel = FI05_1825] [Cad = 05-FT-1825/05-FL-1825]) 

                    I would need this to be able to search around these various combinations. which there is only a couple ways that it can be written. 

The older cad files may not have blocks with the numbers in them simply text files. 

Any help is greatly appreciated. Let me know if there is any other information that you may need.

[devitg]

Please show us  sample.xls and a few samples.dwg 

[Anonymous]

I have attached two .dwg files which are numbers that are in the excel (sample.xlsx). So the lisp should open these files place the corresponding information in the block save and close. There is a third number in the excel file that I did not create a .dwg for this one I would like for the file to open a new .dwg from a template place the corresponding information in the block then save the .dwg under the name of the instrument. This dropping into another folder if possible.

I hope that all makes sense.