How to save tables in txt or xls file?

1 view (last 30 days)
Stefano Cucchi
Stefano Cucchi on 1 Feb 2022
Answered: KSSV on 1 Feb 2022
Hello,
i need to save tables into txt or xls file. That's the script:
  • %Create a "unique name" for the file
  • nrdm1={'File_Log_'};
  • lettere='A':'Z';
  • nrdm2=lettere(randi(numel(s)));
  • nrdm3=lettere(randi(numel(s)));
  • nrdm4={'.txt'};
  • name_file=strcat(nrdm1,nrdm2,nrdm3,nrdm4); %example: "File_Log_NX.txt"
  • %Create tables (tab1, tab2, tab3)
  • NomeDati = ["Frequenza di campionamento [Hz]";"Numero Canali [ ]";"Tempo di acquisizione [s]";"Blocco PSD [s]";" TF [s]"];
  • Valori=[Fs;n_canali;time_end;Tb;Tbd]; %variables
  • tab1 = table(NomeDati,Valori)
  • Warning = ["Warning valore medio";"Warning rumore"];
  • NomeCanale=["Rilevato";"Non rilevato"];
  • tab2 = table(Warning,NomeCanale)
  • NumeroCanale = ["1","2"]';
  • nome_canali=["fds","hgf"]';
  • tab3 = table(NumeroCanale,nome_canali)
  • %Save the file
  • save(name_files,'tab1','tab2','tab3','-ascii')
Of course it can't work properly ("Error using save: Must be a string scalar or character vector."). I tried also "writetable" or "xlswrite" but i don't know how to organize these datas and saving the file with the right name.
Anyone can help?

Answers (1)

KSSV
KSSV on 1 Feb 2022
Read about writetable.

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!