replace cell content of excel from matlab script

Question

Deepan Muthusamy 2021-7-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/873578-replace-cell-content-of-excel-from-matlab-script

评论： Mathieu NOE 2021-7-7

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"
       end

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Mathieu NOE 2021-7-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/873578-replace-cell-content-of-excel-from-matlab-script#answer_741588

在 MATLAB Online 中打开

hello

this is my suggestion - convert your data (numeric double) to cell array first

and more robust if statement as numerical round off can cause some issues it you do "strict" comparison with the given value (here 80), so use a tolerance to account for this

data = xlsread('filename.xlsx','sheet');
cellarray = num2cell(data);
tol = 1e-12;
% then tried changing  that particular cell,
        if abs(cellarray{1,2} - 80) < tol
            cellarray{1,2} = "pass"
       end
% then write back the data to excel.
       xlswrite('filename.xlsx', cellarray, 'sheet')