Hi All,
I hope everyone is having a good day, i am am having a problem an i need to see how to solve this, nasically if you take a ,ook at this example sheet: Example Sheet.xlsx (8.6 KB), for every empty cell I need to add the N/A value, now i can do this with the write cell activity, but i need the boot to add the N/A to all cells in the whole range that the Read range activity gets, any ideas on how to do this?
Try below steps.
Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘inputDT’.
And then use ForEach Row activity to iterate the data one by one row.
ForEach row in inputDT
IF row(“ColumnName”).Tostring.Length = 0
Then row(“ColumnName”) = “NA”
Finally use Write Range activity to write into Excel file.
Do i need to do this:
ForEach row in inputDT
IF row(“ColumnName”).Tostring.Length = 0
Then row(“ColumnName”) = “NA”
For each Row? is there not a more dynamic way where it checks the whole range an sets the empty cells to N/A?
Hi @Palaniyappan, thank you for the example, but i am missing a activity
kindly remove the project.json file and try opening the xaml alone
Cheers @Sidney_Vogel
you need to open it to see what is inside… btw if you have empty excel cells, then row(0).ToString will give you errors…
Double Click on that while loop
Cheers @Sidney_Vogel
Hi @Palaniyappan, you solution worked, thank you so much for the example, i have now learned something more, thank you so much for the help, BTW, is the language Visual Basic? do you know any good resources for learning VB?
@bcorrea, thanks for the heads up, i guess it would make since since there is no data in the datatable
Hi @Palaniyappan never mind, i solved the problem, the counter in my other project was set as generic value instead of Int32. Thanks all for the awesome help.
Cheers @Sidney_Vogel
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
gorby
anjasing
adi.mehare
ppr
Speziman
Jon_Smith
Andreea_Nistor
Suzuki_N