I have two problems:
1) When I call cells.ImportDataTable(dataTable, true, 0, 0, true) it inserts the rows and the table (listobject) size is adjusted but there is an extra row at the bottom with the pre-existing column names. If I insert the rows anywhere other than 0,0 the table size is not adjusted.
2) Also, if the template has a conditional format on one of the columns, I am getting an nullreference exception when I call cells.ImportDataTable(dataTable, true, 0, 0, true);
System.NullReferenceException: Object reference not set to an instance of an obj
ect.
at Aspose.Cells.ConditionalFormattings.xc62b07e82af56ce0(Int32 x78a7603cacf2a
e22, Int32 xa21e294c3adee41c)
at Aspose.Cells.Cells.InsertRows(Int32 rowIndex, Int32 rowNumber)
at Aspose.Cells.Cells.ImportDataTable(DataTable dataTable, Boolean isFieldNam
eShown, Int32 firstRow, Int32 firstColumn, Int32 rowNumber, Int32 columnNumber,
Boolean insertRows, String dateFormatString, Boolean convertStringToNumber)
at Aspose.Cells.Cells.ImportDataTable(DataTable dataTable, Boolean isFieldNam
eShown, Int32 firstRow, Int32 firstColumn, Int32 rowNumber, Int32 columnNumber,
Boolean insertRows, String dateFormatString)
at Aspose.Cells.Cells.ImportDataTable(DataTable dataTable, Boolean isFieldNam
eShown, Int32 firstRow, Int32 firstColumn, Int32 rowNumber, Int32 columnNumber,
Boolean insertRows)
at Aspose.Cells.Cells.ImportDataTable(DataTable dataTable, Boolean isFieldNam
eShown, Int32 firstRow, Int32 firstColumn, Boolean insertRows)