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

Export array as excel format

2 次查看（过去 30 天）
Majid Mohamod
Majid Mohamod 2017-6-6
评论： Majid Mohamod 2017-6-6
Hi all,
The following code is work perfectly to read the netcdf files. It has written by KSSV.
files = dir('*.nc4') ;
nfiles = length(files) ;
P = cell(nfiles,1) ; % precipitation of all files
date = cell(nfiles,2) ;
time = cell(nfiles,2) ;
for i = 1:nfiles
%%Read dat
date{i,1} = ncreadatt(files(i).name,'/','HDF5_GLOBAL.BeginDate') ;
date{i,2} = ncreadatt(files(i).name,'/','HDF5_GLOBAL.EndDate') ;
%%Read time
time{i,1} = ncreadatt(files(i).name,'/','HDF5_GLOBAL.BeginTime') ;
time{i,2} = ncreadatt(files(i).name,'/','HDF5_GLOBAL.EndTime') ;
%%REad precipitation
P{i} = ncread(files(i).name,'precipitation') ;
end
I added the following part, in order to export the array "P" as excel format. Please, I have basic knowledge to solve this problem. I appreciate your help and time!
Majid
i=1:nfiles
X=[{'P'};P]
xlswrite('f',X)
end

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2017-6-6
编辑：KSSV 2017-6-6
myfile = 'myfile.xlsx' ;
for i = 1:nfiles
xlswrite(myfile,P{i},i)
end
Each nc-file's precipitation data written into one sheet of excel file.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 NetCDF 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by