Autolisp to seach excel column and fill the data in that row to block atributes

Hi there,

Are there any cad/excel specialist here who can solve my problem?

I need an Autolisp that compares a autocad block attribute (block name: "5555", attribute name: "drawingnumber") with "column B" in an excel file.

this excel file have the name "drawinglist" and the lisp should search the folder the acad-drawing is in.

when he found the drawingnumber in the exel file, the lisp should fill the data on the same row into other attributes of the same block "5555"

for example:

in block "5555", attribute "drawingnumber", the value "0505-01-13-0007" is found

lisp search excel "column B" for the value "0505-01-13-0007"

when he found that in "row 33" then he should add "cell C33" to block "5555" in attribute "revision"

"cell D33" to block "5555" in attribute "document-type"

==========

i manage to do this with an *.csv file but i cant use this set up since the drawinglist lose his layout when saved as *.csv

txs in advance!

jp

Search here for "excel" there are just so many examples for what you want.