I have a datatable (via read range from an excel) and i have a datacolumn with some pre-filled data. Is it possible that i can add this datacolumn with data to datatable.
I see add data column activity is adding an empty column to datatable, but i want to add datacolumn with data in it
Or one of the laziest way is to use Excel with 2 WriteRange and ReadRange.
Let’s assume there is dt which has 4 columns and dt2 which has 1 column to add to dt.
First, write dt to “A1” of some sheet, and write dt2 to “E1”. Then Read from “A1” using ReadRange. it returns merged datatable with data.