From uploaded attachment. I want to replace particular row into 1st place and already existing 1st row item to that replaced row.
Ex: Replace 7th row item to 1st row and 1st row item into 7th row.
What logic should we approach and activities to follow ?
InputSheet.xlsx (9.0 KB)
Read range for reading in the excel into a datatable -dtData
EDIT: Item Array Swap strategy
FirstRowRA = dtData.Rows(0).ItemArray
ChangeRowRA = dtData.Rows(6).ItemArray
dtData.Rows(0).ItemArray = ChangeRowRA
dtData.Rows(6).ItemArray = FirstRowRA
How to “Delete Data Row for deleting first and other row” ?
Could you please share demo xaml file ? for better understanding.
In collaboration with one of my colleagues, we found a more compact approach.
Strategy: ItemArray Swapping
ItemArrayList = arrSwapIDX.Select(Function (x) dtData.Rows(x).ItemArray).toList
dtData.rows(arrSwapIDX.first()).itemArray = ItemArrayList.Last()
dtData.rows(arrSwapIDX.Last()).itemArray = ItemArrayList.First()
Find initial starter help here:
DT_SwapDataRows.xaml (13.4 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.