working with excel

[salman]

Using VLISP How can we add rows, remove rows & search for records in excel sheets. I have looked at the excel object model reference but cannot get the job done, Any examle will be a big help.

 

thanks

[Commandobill]

by "search for records" do you mean look for a value in a specific row or column? and as far as add or remove rows do you mean inserting rows and deleting all values in a row?

[gile]

Hi,

 

You can get some inspiration from Terry Miller's GetExcel:

 

http://autolisp-exchange.com/Forums/Forum3/F3T5P1.htm

 

To find availabe methods and properties, run the vlax-dump-object function on the worksheet vla-object.

[salman]

by search records I mean finding values in cells of the spread sheet and then accessing that cell.