Code to append value in Data Table Cell –
‘ Set cursor to desired row of Data Table
DataTable.SetCurrentRow(2)
‘ Set cursor to desired row of Data Table
DataTable.SetCurrentRow(2)
‘This code first reads value from Cell, concatenate existing value & new value, value is stored in cell –
Datatable.Value(”Column Name”,”Sheet name”) = Datatable.Value(”Column
Name”,”Sheet name”)+str_ValueToAppend
Datatable.Value(”Column Name”,”Sheet name”) = Datatable.Value(”Column
Name”,”Sheet name”)+str_ValueToAppend
No comments:
Post a Comment