Hi,
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 ?
Thanks
InputSheet.xlsx (9.0 KB)
ppr
(Peter Preuss)
2
Read range for reading in the excel into a datatable -dtData
EDIT: Item Array Swap strategy
Assign Activity
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.
ppr
(Peter Preuss)
6
In collaboration with one of my colleagues, we found a more compact approach.
@kumar.varun2
Strategy: ItemArray Swapping
ItemArrayList = arrSwapIDX.Select(Function (x) dtData.Rows(x).ItemArray).toList
First row:
dtData.rows(arrSwapIDX.first()).itemArray = ItemArrayList.Last()
Second row:
dtData.rows(arrSwapIDX.Last()).itemArray = ItemArrayList.First()
Find initial starter help here:
DT_SwapDataRows.xaml (13.4 KB)
1 Like
system
(system)
Closed
8
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.