i have an excel sheet of data having (400x256). The columnsn of each row B,D, F, F+2, F+4,..... till 256 having value either 80 or 90. i want to replace those values with "pass" or "fail".
I am using matlab 2018a. so i am using xlsread/xlswrite funtions.
I tried the below code but it is not working...
I read the excel to a variable in matlab
data = xlsread("filename.xlsx","sheet").
then tried changing that particular cell,
if data(1,2) == 80
data(1,2) = "pass"
then write back the data to excel.
xlswrite("filename.xlsx", data, "sheet")
but i don't see "pass" in B1 cell instead seeing an empty cell.