I have excel file attached here for reference[Template.xlsx|attachment] Template.xlsx (11.2 KB)
This is my main sheet
I have created sequences as per other sheet e.g. prashant.xaml,tushar.xaml.
Form main wrokflow is create as → if name = “Prashant” ->then ->invoke “Prashant.xaml” elseif …(validate other names)
Inside other sheets e.g Prashant,tushar,etc i am having multiple data.
e.g
“prashant.xaml” workflow is → used for each row ->sheet name(Prashant)-> fill data into form(should fill data by index number) same for other xaml.
main excel having names in random order.
when name =“prashant” for 1st time “prashant.xaml” should take all values for 1st row.
only selected one in above snap.
and if getting name = “prashant” for second or 3rd time “prashant.xaml” should take values for next row.
i am not getting it how to take value from the sheet by index or else
I would suggest keep a count outside the name:
example:
Count= 0
If name = Prasanth
then in assign give Count = count+1
and in reading the workbook keep the range as “A”+Count.tostring:“C”+Count.tostring then you will get only one row as ouput .
Then you can save that data
then use for each row and in that read with
increment is working it count taking 2 all the time
Range = “A” +count.ToString +“:C” +count.ToString = output is
data table = DT.ToString = output is blank.
You can create a variable with the sheet name like
if it is a, then the variable will be a, and get the value from the first row assigning value of a = 1, then increment the value by 1 for each iteration or occurance, then pick the value using the variable ‘a’ using it as index
