write datatable to excel template and adding back color to row

See more:

C#

ASP.NET

Hi,

In the asp.net application i am working on, there is a requirement to send out Excel to client attached to a mail and i have to create excel in server in order to send it out as an attachment.and office is not installed in server.
so i cannot use microsoft.interop.excel.

the excel has image and some fixed text and columns are fixed
so i thought of making it as template and writing DataTable to it.
and i want to give some backcolor to a row.
and i also have to wrap text for coloumns

can anyone show me how to accomplish this.

Any Free 3rd party Dll's?? or any other way to do.

Thanks
--G