Writetable for different data to same file
24 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello,
I have a script that reads in a csv file and outputs a number of variables. I then store this variable in a table with two headings, the name of the file and in this case Time to Completion.
varNames = {'File','Time to Completion)'};
T = table(Name,TTC,'VariableNames',varNames);
writetable(T,'Time_Completion.xls');
My problem is that I want to use this same file (Time_Completion.xls) for different runs of the script with new data so that the columns populate with every new run rather than overwriting. I don't know to read the file every time it opens and if there's data in one row go down and fill the next. Appreciate any help. Thanks.
0 Kommentare
Antworten (1)
Cris LaPierre
am 5 Aug. 2021
6 Kommentare
Cris LaPierre
am 5 Aug. 2021
Do you get an error when you run the following?
InsectSpecies = {'Monarch Butterfly';'Seven-spot Ladybird';'Orchid Mantis';...
'American Bumblebee';'Blue Dasher Dragonfly'};
InsectOrder = {'Lepidoptera';'Coleoptera';'Mantodea';'Hymenoptera';'Odonata'};
InsectFamily = {'Nymphalidae';'Coccinellidae';'Hymenopodidae';...
'Apidae';'Libellulidae'};
PredatoryInsect = logical([0;1;1;0;1]);
T = table(InsectSpecies,InsectOrder,InsectFamily,PredatoryInsect)
writetable(T,'InsectCollection.xls','WriteRowNames',true)
%% Now append a new row to the table
newInsect = table({'Red-banded leafhopper'},{'Hemiptera'},{'Cicadellidae'},logical([0]));
writetable(newInsect,'InsectCollection.xls','WriteMode','Append',...
'WriteVariableNames',false,'WriteRowNames',true)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!