Skip to main content

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 @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 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

 


Reply