Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

How to rejoin text and numbers into raw format and export to excel

1 vue (au cours des 30 derniers jours)
krai
krai le 13 Juin 2018
Clôturé : MATLAB Answer Bot le 20 Août 2021
I have a excel file with data as shown,
Time Exp1 Exp2
0.1 26 965
0.2 23 966
0.3 25 963
0.4 NA 956
0.5 24 951
0.6 26 944
I have used the code
[num,text,raw] = xlsread('test.xlsx');
num_avg = fillmissing(num,'linear'); % to fill the missing data in the file
Now I want to write the processed data with the header to an excel file as shown below
Time Exp1 Exp2
0.1 26 965
0.2 23 966
0.3 25 963
0.4 24.5 956
0.5 24 951
0.6 26 944
How do I do it??
Thanks in advance

Réponses (1)

KSSV
KSSV le 13 Juin 2018
str = {'Time' 'Exp1' 'Exp2'};
data = [0.1 26 965
0.2 23 966
0.3 25 963
0.4 24.5 956
0.5 24 951
0.6 26 944] ;
A = num2cell(data) ;
T = [str ; A] ;
xlswrite('check.xls',T)
  5 commentaires
KSSV
KSSV le 13 Juin 2018
What is size of text1? YOu may trying adding header....as I have shown in the code, if you are getting error.
krai
krai le 13 Juin 2018
"What is size of text1? "
the size of text1 is 1x3
"YOu may try adding header....as I have shown in the code, if you are getting error."
How do I do that when pulling data from excel?
Thanks

Cette question est clôturée.

Community Treasure Hunt

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

Start Hunting!

Translated by