Writing into a formatted template

Aspose.Cells Product Family
1

Hi,

I am new to using Aspose.Cells for creating excel reports.
Task at my hand is that i have to load a well formatted template (including coloring,tables & filters)
and then writing into it keeping the format intact .
Now when i go to add rows to already existing formatted table using ws.Cells.ImportDataRow(datatablexyz.Rows[j],rowindex, coulmnindex); the formating i…e.
coloring,filters etc gets removed .
Is there a method so that i can add rows into excel table without disturbing formatting ??

Waiting for responses !!
Thanks !!
2

Hi,


Well, when you use Cells.ImportDataRow() method, it will by default insert a blank row (without formatting etc.) and then paste the data row into it. You may use Cells.ImportDataTable(DataTable dt, bool isFieldNameShown, int firstrow, int firstcol, bool insertRows) instead. Set “false” for the last parameter for your need. The insertRows boolean parameter in the method e.g specifies that there will be no extra rows inserted for the import operation.

Thank you.