Hi,

I have a requirement, where I want to use an Excel Template and write DaaTable into it.

Let me ellobrate my requirement.

1. I have an Excel Template say **MonthlyReport.xls**

2. In my ASP.Net Application I should be able to open that excel file, using Aspose.Cell.

3. I will have a dataset, and I want to write a ds.Tables[0] into the excel sheet.

4. Inside Excel file I should be able to write a particular row at particular location, say ds.Tables[0].Rows[0] at A4 row

More practically I should be able to say where to write the DataTable row write inside the excel file.

My excel file template wil have some formulas.

I want to know is it possiable to write whole row from an datatable into an excel, or I need to write cell by cell.

Please advice the best approach with sample code.

Let me know if you need more clarification

Thanks

Siraj