Writetable for different data to same file

8 次查看（过去 30 天）
CH
CH 2021-8-5
编辑： CH 2021-8-6
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.

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2021-8-5
See the Append Data to Bottom of Table example on the writetable documentation page.
  6 个评论
显示 4更早的评论
CH
CH 2021-8-5
编辑：CH 2021-8-6
So if I change my line of code to include that line the error I get is below. Matlab version is 2021a
writetable(T,'Time_Completion.xls','WriteMode','Append');
Error using table (line 264)
Invalid parameter name: WriteMode.
Cris LaPierre
Cris LaPierre 2021-8-5
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)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by