Hi,
I want to update an excel using update command where I set some values using where condition. Is there any alternative to this? Can I use an excel command for doing this? I don’t want to use database. I cannot see any command for this in automation anywhere
Hi
You dont want to use database or Excel as database ?
The following link can be a useful resource
Regards
Hi Rahul,
No I am not talking about this. I don’t want to use ‘Update’ command of database. I am asking what could be the alternative to this?. I can use excel ‘Set cell’ but it does not have ‘where’ clause like we use in ‘update’. Hope I am clear
Hi Rahul,
No I am not talking about this. I don’t want to use ‘Update’ command of database. I am asking what could be the alternative to this?. I can use excel ‘Set cell’ but it does not have ‘where’ clause like we use in ‘update’. Hope I am clear
Hi
Ignore this if you have already checked.
Try with IF Condition and Set Cell action
Pass your condition to the IF block and if it succeed, it will execute the Set Cell action. You can use the Data Table package instead of Excel package for a faster Execution if that is also a concern for you.
- Loop through the excel sheet. Use a variable to keep track of your row.
- Add an IF statement that contains your condition
- Update the specific cell using your row counter if the row meets your criteria
- Add 1 to your row counter and keep looping
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.