modify data in sheet

hi,

I've got several sheets in my document and I need to modify them to a given criteria. I'm willing to write a small program to do this. The program is intended to open the given document, modify content (like deleting some rows, altering some values etc) and save. So for this what API should I use?

Is there any sample code written using the API, that I can refer?

Thanks in advance