Alternative for database update command

Hi @Rohan Tiwari 6713 

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 @Rohan Tiwari 6713 ,

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.

@Rohan Tiwari 6713 I don't like using the Excel as Database either.

1. Loop through the excel sheet. Use a variable to keep track of your row.
2. Add an IF statement that contains your condition
   1. Update the specific cell using your row counter if the row meets your criteria
3. Add 1 to your row counter and keep looping