Is there a way to add value to a specific row (like 2 nd row)when using AddParameter method for a DataTable Object?
For example, my script is reading 2nd row of the Datatable and I need to write a new column. When adding the column, I would like for the value to get added to the 2nd row, but right now it adds to the first row in the newly created column.
The issue is even if I set the row index, when I use AddParameter method to add a column and its value, the value is by default added to the first row in the new column. I hope it clarified your question.
'Create your column here
'Jump to your row in this case,row=2
'Enter your data
dataTable.localSheet.GetParameter("MyColumn").Valu e="My data"