Retain cell formulas throughout

excel
activities

#1

How to retain the the cell formulas even if we use
(For example…Newdatatable = olddatatable.clone)
The .clone function???
I used an invoke method in the for each row after this function… I gt d correct output rows… But i am nt getting the formulas copied back again??
How do i retain the cell formulas inspite of clone function and invokemethod


#2

I’m sorry, I don’t understand what you mean. Cell formulas (from Excel sheets) are not read into a DataTable, they would not have been there even before cloning. Furthermore, Clone copies only the old table’s “schema”, which is just the description of columns (names and settings), for the purpose of starting a new table without data but with the same format as an existing one.