Oledb excel update is not working

See more:

C#5.0

Am trying to update single column based on condition in the Excel using Oledb. Am facing issue like "

Operation must use an updateable query

"

Please anyone help in this.

What I have tried:

using (OleDbConnection objConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath1 + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';"))
            {
                objConn.Open();
                
                OleDbCommand cmd = new OleDbCommand();                

                cmd.Connection = objConn;
                cmd.CommandType = CommandType.Text;

                cmd.CommandText = "UPDATE [Sheet1$] SET [F6]='5' where [F2]='2992269'";
                
                cmd.ExecuteNonQuery();
}