How to save tables in txt or xls file?

조회 수: 1 (최근 30일)
Stefano Cucchi
Stefano Cucchi 2022년 2월 1일
답변: KSSV 2022년 2월 1일
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?

답변 (1개)

KSSV
KSSV 2022년 2월 1일
Read about writetable.

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

제품


릴리스

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by