Hi Team,
Input excel file is attached below:
MR.xlsx (11.8 KB)
i want to read each row from the excel
and each value should be pasted in one application as shown below.
each value in the columns which is single name or the value may be null or some times it is having more than one value seperated by semicolon
if it is null value then we no need to fill any thing in the respective text box.
if the value is one then enter the name in the respective label of the application
if their are multiple names seperated by semicolon then need to add each name and type enter and continue untill all the names are entered
example:
how can we write logic for this case
ProjectChampion=row(“Project Champion (develops and follows progress of project”).tostring
ProjectChampion_Arr=split(ProjectChampion,"
but its not working for all three scenarios(Null, Single value,Multiple values seperated by semicolon)
Please help me with some solution
Thanks in Advance
Likitha
