Insert information from an excel cell to an autocad multileader

[joseZ9KZ7]

Hi everyone!

I would like to figure out any lisp routine or any way to solve this workflow

Having an existing excel file, extract the information and have it available in autocad to add it to multileaders (maybe through custom fields that will be automatically updated if there is any change in the excel file).

To set an example, if this is my excel file

@1	concrete
@2	steel
@3	floor
@4	window

I would like to go to autocad, write "@1" and get the value "concrete".

Also if later on, the value "concrete" changes to "concrete HA-25" it would be great to automatically update that information on fairly easy way.

Thank you very much in advance, I believe is not an easy task, but it would save us a lot of hours in my company.

[Sea-Haven]

Some commands support transparent entry so '@1 would produce "Concrete" unfortunately text is not one of them. 

Custom leader code could change the @1 to Concrete with out any problems, same ccc sss etc If you think it may Become Concrete 25mpa then I would add a hidden character to Concrete one of the extended characters that does not show. So using FIND would change Concrete to Concrete 25mpa.

(setq str (strcat "Concrete" (chr 11)))
(command "text" (getpoint "pick") "" "" str)

Not sure about which character to use may be a better one than 11. I tested using Bricscad Find, had to copy the text then paste into find as can not enter the extended character directly but easy.