清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

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

2 次查看（过去 30 天）
krai
krai 2018-6-13
关闭： MATLAB Answer Bot 2021-8-20
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

此问题已关闭。

回答（1 个）

KSSV
KSSV 2018-6-13
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 个评论
显示 3更早的评论
KSSV
KSSV 2018-6-13
What is size of text1? YOu may trying adding header....as I have shown in the code, if you are getting error.
krai
krai 2018-6-13
"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

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by