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 into the excel sheet.
4. Inside Excel file I should be able to write a particular row at particular location, say ds.Tables.Rows 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