Im sure than u have a bad path, use a message box activity (we going on to verify the data) just next to Read Range with this properties
And show me ur result, should be “201901”.
hey, u have helped me in replacing the space between the values, so now i might be able to add it normally.
Right?
Let me try!!
yeah, the function regex.replace search all spaces and delete it, only of that way we can use a formula in excel.
U can execute correctly?
no i am not able to do it, it is showing blank value when i try to sum using the code.
but now since u have helped me replace all the values in the desired sum column, i will use for each row to manipulate and get the sum of the data!
I need to use for multiple sheets will work perfectly right??
Thank You
How are u adding it? In the excel?
Can works for multiple sheets, only change the name of the sheet in invoke code where is “example”, regards and bless
i am adding it using ur method using dow while while taking in the counter. Then adding the values one by one or may be i will take it using the read column activity then add them!!
thank you
1 Like
If u want to add it in the loop u can try with an assign
Assign
table(row)(column) = “value”
Bless
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.