Looking for a Simple Lisp to Change Block Layers in AutoCAD Based on Excel Data

[Hai]

Hello,

I am looking for a simple Lisp that can change the layers of multiple blocks in AutoCAD. The blocks have different names, their current layers are the same, but the new layer will be different. I need to assign each block to a different new layer. The blocks already exist in the drawing, I extracted the names of the blocks that need to be changed into an excel file and I assigned their new layers in the Excel sheet, too.

My goal is to:

Create the new layers first 

Assign each block to its respective new layer, while keeping all other block properties unchanged.

If the Lisp can read the Excel file and use it to map the necessary layer changes, that would be perfect.

Does anyone have a tool or Lisp code that can help with this?

Thank you in advance!

[BIGAL]

What do you know about lisp ?

 

Yes read/write a cell exists, NOTE not for LT2024 or 25. 

 

Happy to provide the defuns that can be used to carry out this task, for an experienced coder. Please let us know.

[Hai]

Thank you for reaching out. I have some experience with Lisp and would appreciate receiving the defuns for the task I mentioned. Could you please send them over? I’ll be happy to take a look and proceed accordingly. Best regards, Hai