How can data gradually be exported to an Excel file?

Question

Erik Näslund 2019-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/471649-how-can-data-gradually-be-exported-to-an-excel-file

评论： Erik Näslund 2019-7-14

I am having/creating several workspaces of different recorded data, representing a function (called RS). At four different occasions data/blood samplings were done at different times (”a”, ”b”, ”c” and ”d” respectively). Via a ”input”-function I can assign the current times to respective data sampel. After that, I create a +/- 15 s interval of each data sampel and calculate the mean.

a = input('seconds:');
b = input('seconds:');
c = input('seconds:');
d = input('seconds:');
% Determine the different intervals and mean-values:
ai = (a-15:a+15)
bi = (b-15:b+15)
ci = (c-15:c+15)
di = (d-15:d+15)
mai = mean(RS(ai))
mbi = mean(RS(bi))
mci = mean(RS(ci))
mdi = mean(RS(di))

Is there a way, to export the data to an Excel spreadsheet, with the name of the different workspaces in column 1 and the different mean-values in columns 2 to 4, and every time the code is run a new row is added with the current values?

I hope someone can help me! Thank you

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2019-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/471649-how-can-data-gradually-be-exported-to-an-excel-file#answer_383152

编辑：Image Analyst 2019-7-14

在 MATLAB Online 中打开

You could just read in the existing worksheet and find out the last row:

if isfile(filename)
    % Read in existing file to get its last row.
    [numbers, strings, raw] = xlsread(filename);
    [rows, columns] = size(raw);
else
    % File doesn't exist yet.
    rows = 0;
    columns = 0;
end
    

then when you make up a cell reference, start writing at the next row

nextRow = rows + 1; % Or wherever you want.
cellRef = sprintf('A%d', nextRow);
xlswrite(filename, data, worksheetName, cellRef);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Erik Näslund 2019-7-14

Thank you for your help! But, unfortunately I must be missing something and can’t get the code to work. Since I’m fairly unexperienced using Matlab I am wondering if you could provide me with a concrete example using the following conditions?

Filename = testdata

Matlab workspace savename = GX_RY (unique name for all the different recordings)

Organisation/headers of the Excel file: ‘Workspace name’, ‘mai’, ‘mbi’, ‘mci’, ‘mdi’

Worksheet name – it doesn’t matter…

I very much appreciate your help!

请先登录，再进行评论。