I am trying to read values from the excel sheet and entering it into the text field. If the excel row has some value, then the previous text value is cleared using Empty Field, and new value is entered.
But if the value in the excel sheet is blank, then the value is not cleared and the previous value is left as is.
If the value in excel sheet is blank then I want to clear the field and save the record.