Select sheet name based on sheet structure

Help Activities
1

if i have excel file with multiple sheets an i need to get the sheet name of one of the sheets based on the content of this sheet lets say the column name. how do i achive this

2

@mohamed.saty2012,

Follow this approach:

  1. Use Excel Process scope → Inside it use Use Excel File → Inside it use For Each Excel Sheet activity
  2. Now use Find/Replace Value activity to find the desired column. If found it will return the Range else Null
  3. Add if condition to check if step 2 activity return null or range. If Range that’s your sheet. Do your work here and use Break / Exit Loop activity to exit from the For Each Excel Sheet activity
3

Thanks for the amassing support as usual

1 Like
4

resultString = String.Join(ControlChars.NewLine,
“01 abc02 cde”.Split(" “c).
Aggregate(”“, Function(acc, s) If(acc <> “” AndAlso Char.IsDigit(s(0)), acc & “|” & s, acc & s)).
Split(”|"c)) cccccccahhdjejzjsjdjxkdnjxjxendnzn dhsj

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.