I am currently testing Aspose.Cell for my company, and I have a question about the “ImportDataTable” function.
Basically, I have some data on a DataTable, and I want to insert it on a worksheet which already contains custom columns.
Let’s say the DataTable has 20 columns and 10 rows, and my customs values start at column 25.
I use the “DeleteRange” function to clear everything that could exist from column 1 to 24, then use “ImportDataTable” to insert my data on that space.
The problem is, my existing values do stay on the right column (25), but are moved to row 11, under the new data I insert. It’s like the import cleared everything on his right and moved it to the bottom.
Since those values are actually formulas I want to apply on my data, I would like to know if it is possible to maintain them at the exact same place ?