Write datatable to excel template and adding backcolor to a row in excel

May 2 2012 9:24 AM
Hi All,

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 create excel in server in order to send it out as an attachment and office is not installed in server so i cannot user Microsoft.office.interop.excel ,the excel has image and some text and columns are fixed so i thought of making it as a template and writing Data table to it, and i want to give some back color to a row and wrap text for columns.

can anyone show me how to accomplish this.

Thanks.



Answers (1)