Info
この質問は閉じられています。 編集または回答するには再度開いてください。
Saving a table with different values
1 回表示 (過去 30 日間)
古いコメントを表示
I am having some trouble will developing my code to only save the table with different values to the file. So far I have,
savefile='Tumble Data User Applicable.mat';
PrevTable=load(savefile,'ATtablef');
ATcellf={AccelSN,Teststr,Accel0,Accel90,Accel180,Accel270,Temp0,Temp90,Temp180,Temp270,VB,HB,VSF};
ATtablef=cell2table(ATcellf);
ATtablef.Properties.VariableNames={'Accel S/N' 'Test date' 'Accel_0' 'Accel_90' 'Accel_180' 'Accel_270'...
'Temp_0' 'Temp_90' 'Temp_180' 'Temp_270','Vertical Bias','Horizontal Bias','Vertical Scalefactor'};
savepath='\\172.30.248.24\share\For Redmond\transfer\Alexandra\MatlabFiles';
savefile='Tumble Data User Applicable.mat';
save(fullfile(savepath,savefile),'ATtablef')
ATtablef=[PrevTable.ATtablef;cell2table(ATcellf,'VariableNames',ATtablef.Properties.VariableNames)];
savepath='\\172.30.248.24\share\For Redmond\transfer\Alexandra\MatlabFiles';
savefile='Tumble Data User Applicable.mat';
save(fullfile(savepath,savefile),'ATtablef')
If on a second run the table has the same values it should not be saved therefore, only values that are different in ATtablef may be saved to the file.
Any suggestions or resolutions?
4 件のコメント
Walter Roberson
2020 年 7 月 22 日
That is not possible without changing the table format. You have numeric columns, and the only way to not save at those locations is to change the column from numeric to cell so that you could empty the cells at the places the numeric values are the same. Likewise for the datetime column. Your Accel S/N looks like it might perhaps be character, so that one would be okay since empty characters are okay in Excel.
回答 (0 件)
この質問は閉じられています。
参考
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!