Save results on different sheets in excel

Question

Aristi Karavi 2021-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/874728-save-results-on-different-sheets-in-excel

回答： Ankit 2021-7-12

Hi,

I created an excel file named 'results' and then made different sheets. Now I don't know how to save the results in every sheet while for loop runs.

% Connect to Excel

Excel = actxserver('excel.application');

results = 'results.xlsx'

% Get Workbook object

WB = Excel.Workbooks.Open(fullfile(pwd, 'results.xlsx'), 0, false);

% Get Worksheets object

WS = WB.Worksheets;

k = 1

for s_rate = 1.1:0.1:1.5 % 5 different values

% Add a sheet after the last sheet

WS.Add([], WS.Item(WS.Count));

% Name the Sheets

while k <= 5

WB.Sheets.Item(k).Name

for r = 0.000000010:0.0000000010:0.00000010 % 100 different values

J = J_if(N0,v,b,C0,C,Qd,T,k,a,x,s_rate); % The 2-D nucleation rate (per unit time per unit area)

dh_dt = J*pi*(r^2)*a; % wire growth rate

% Add the results

writetable(k, results, 'Sheet' ,k, 'Range' ,'C2')

end

k = k + 1;

% Save

WB.Save();

end

%Quit Excel

Excel.Quit()

2 个评论
显示无隐藏无

Ankit 2021-7-9

your first input to the writetable command should be in table format.

What you are trying to save in excel sheet?

Aristi Karavi 2021-7-9

I need 5 different sheets (extracted from 1st for loop (for s_rate)) and into them I need to save the values that extracted from the 2nd for loop ( loop for r).

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2021-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/874728-save-results-on-different-sheets-in-excel#answer_743548

See the Write Table to Specific Sheet and Range in Spreadsheet example on the writetable documenation page.

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

请先登录，再进行评论。

Answer 2

Ankit 2021-7-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/874728-save-results-on-different-sheets-in-excel#answer_744988

在 MATLAB Online 中打开

You can try this example and adapt to your requirement. first "for loop" you can use for creating 5 different sheets as mentioned by you. And second loop you can use for saving the values extracted from the inner loop.

results = 'results.xlsx';
for k = 1:1:2
res = table('Size',[1 4],'VariableNames',{'r','J','a','dh_dt'},'VariableTypes',{'double','double','double','double'});
    for r = 0:1:5 % 100 different values
        J = 1;
        a  = 2;
        dh_dt = J*pi*(r^2)*a; % wire growth rate
        % Add the results
        res_new = table(r,J,a,dh_dt,'VariableNames',{'r','J','a','dh_dt'});
        res = [res;res_new];
        writetable(res,results,'Sheet',k)        
    end
end
Warning: Added specified worksheet.