Is there a MS Excel API/SDK? I just noticed a Excel plugin which was a dll
file. I am wondering whether it's possible for one to create his own plugins
for Excel and how to go about it?

Also, is it possible to link in Excel with another application, say a 3rd
party program. So that Excel worksheets and cells correspond to values
stored in a 3rd party program's database.