Unable to update Color in Excel sheet as using database

[Mahebub_Nabi]

Hi, Good Evening, i am unable to update color by using update SQL command in Excel sheet as Excel sheet is using as a database so kindly suggest on this. Below is error getting.

[Rajeswari24 (Rajeswari Punnamaraju)]

You can go through this forum discussion

Error in Excel as Database execute Non-Query: Update query

when I am Using this query in Execute Non Query Activity “Update [Sheet1$] Set Salary=‘23000’ Where Name=‘Nisarg’” I am Facing an issue Execute Non Query: ERROR [HY000] [Microsoft][ODBC Excel Driver] Operation must use an updateable query. Please any one help me Thanks in advance

and check whether you have selected write mode when creating the Data base

You can also refer to this video which is very useful!

How to automate Excel Operations in UiPath ? | How to Use excel as a Database in UiPath