clc;
clear;
warning off;
geoSampleFile = 'O:\5. CRU 气候数据 气温 降水 辐射\USED DATA\wrf\滑动15\yanmo\1982-1996.tif';
[A,R] = geotiffread(geoSampleFile);
info = geotiffinfo(geoSampleFile);
[numRows,numCols] = size(A);
datadir = 'O:\5. CRU 气候数据 气温 降水 辐射\USED DATA\wrf\滑动15\yanmo\'; %指定批量数据所在的文件夹,要改
filelist = dir([datadir,'*.tif']);
k=length(filelist);
for i = 1:k
outputdata(i).name = filelist(i).name;
%FilePath = ['G:\CMFD\Prec\Prec\',filelist(i).name];
[A,~] = geotiffread(fullfile(datadir,filelist(i).name));
A = double(A);
A(A <= -1000) = NaN;
outputdata(i).num = nanmean(nanmean(A));
end
resultTable = struct2table(outputdata);
excelFileName = 'O:\5. CRU 气候数据 气温 降水 辐射\USED DATA\wrf\滑动15\yanmo\均值.xlsx';
writetable(resultTable, excelFileName);
%xlswrite('E:\SM\Anual_Mean\不同区域的均值\Arid',resultTable);
disp('ok')
批量提取tif文件平均值代码到excel
最新推荐文章于 2024-07-05 19:32:17 发布