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

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

Answer 1

[KSSV]

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)

[krai]

It is giving an error as ,

"Dimensions of matrices being concatenated are not consistent."

I checke the size of str is 1x3

and the size of A is 6x3

[KSSV]

The same code works fine in my version...what version you are using?

[krai]

code,

[num, text] = xlsread('test.xlsx');
numfill = fillmissing(num,'linear'); % fill missing cells, replaces NA with the average of previous and next cell
text1=text(1,:);                     %  since the text has "NA" strings as well
T = [numfill ; text1]

when I read the excel initially using the below mentioned code,

 [num, text] = xlsread('test.xlsx');

"NA" in the excel is also considered as a string as shown below,

text =

5×3 cell array

    'Time'    'Exp1'    'Exp2'
    ''        ''        ''    
    ''        ''        ''    
    ''        ''        ''    
    ''        'NA'      ''

That is the reason I have used this

text1=text(1,:);

 to consider only the first row of the array.

But when I run the code I get the error,

Error using vertcat Dimensions of matrices being concatenated are not consistent.

Error in Untitled3 (line 5) T = [numfill ; text1]

I use 2016b version. I hope this clears the doubt.

[KSSV]

What is size of text1? YOu may trying adding header....as I have shown in the code, if you are getting error.

[krai]

"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