how to programmatically display data into an excel worksheet
 

I have an excel application project type in my VS.net now i need to get the
data from my ms sql server then display it programmatically in my excel
application without using design time controls. How can i do that?

as of now, i have created the connection to the database and do a select
statement and have the result save into a datatable. how can i transfer the
data into the excel ranges/cells?

thanks