Excel sheet modification

Question

I've searched and read and searched and posted...  And I can't find anything useful.

So HOW do you actually interact/create an Excel file?  What kind of level of interaction is there?  Like, can my app create a pie chart on an Excel sheet using data on another sheet?

Thanks.