How can data gradually be exported to an Excel file?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Erik Näslund
le 14 Juil 2019
Commenté : Erik Näslund
le 14 Juil 2019
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 commentaires
Réponse acceptée
Image Analyst
le 14 Juil 2019
Modifié(e) : Image Analyst
le 14 Juil 2019
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);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!