Need help one multiple data exporting to xls

Question

Haolong Huang 2019-5-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462266-need-help-one-multiple-data-exporting-to-xls

评论： Haolong Huang 2019-5-16

采纳的回答： convert_to_metric

在 MATLAB Online 中打开

Hi All,

I encountered some trouble in exporting and naming my data to .xls.

I'm trying to do two for loops in order to process my 30 data. I firstly remove NaN values and the use log10 to revalue them. However, for writetable code, there always shows errors.

I would very appreciate it if anyone can help me solve the bugs in my codes!

Thanks!

for time=1:6
    for drug=1:5
        x1 = reshape(p(drug,time,1:2,:),[],1);
        y1 = reshape(N(drug,time,1:2,:),[],1);
        z1 = reshape(A(drug,time,1:2,:),[],1);
        X = [x1 y1 z1];
        X(any(isnan(X),2),:) = [];
        data_log=[log10(X(:,1)) log10(X(:,2)) log10(X(:,3))];
        data_log_table=array2table(single_cell_log);
        %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%problems for the following row
        filename=['time_';num2str(time);'_drug_';num2str(drug_);'.xlsx'];
        writetable(single_cell_log_table, filename)
        %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    end
end

Error using vertcat

Dimensions of arrays being concatenated are not consistent.

Error in subsettry (line 11)

filename=['time_';num2str(time;'_drug_';num2str(drug_);'.xlsx'];

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

请先登录，再进行评论。

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

Answer 1

convert_to_metric 2019-5-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462266-need-help-one-multiple-data-exporting-to-xls#answer_375153

编辑：convert_to_metric 2019-5-15

Hi Haolong,

I see 2 issues on line 11. You should use commas instead of a semicolons so that you will horizontally concatenate the strings. Also, there might be a typo. Perhaps you meant num2str(drug) and not num2str(drug_). In other words, try changing:

filename=['time_';num2str(time);'_drug_';num2str(drug_);'.xlsx'];

to

filename=['time_',num2str(time),'_drug_',num2str(drug),'.xlsx'];