how to open excel files and write data?

Question

Devendra 2024-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2098196-how-to-open-excel-files-and-write-data

编辑： Devendra 2024-3-25

for m=1:mimgfiles
    for n=1:nshapefiles
        % Use the logical mask to extract data from ndvi image for villages
        village_ndvi = NDVI(logical_mask);
        village_ndre = NDRE(logical_mask);
        village_cire = CIRE(logical_mask);
        avg_village_ndvi = mean(village_ndvi(mask));
        avge_village_ndre = mean(village_ndre(mask));
        avg_village_cire = mean(village_cire(mask));
        end
     end

I want to open four different excel files before the loops and write these outputs avg_village_ndvi,avg_village_ndre1,avg_village_cire,and CAF in four different excel files within the loops.

I would appreciate any help in doing the required steps as mentioned above.

dave

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Alexander 2024-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2098196-how-to-open-excel-files-and-write-data#answer_1430141

编辑：Alexander 2024-3-24

Just use "xlswrite(FILE,ARRAY,SHEET,RANGE)" in your loop four times with the appropriate file and sheet name. Of cause you have to adjust RANGE with every loop. But must it be in the loop? Why not saveing you data in a variable (type table) and writing with "writetable" to a spreadsheet? It will be much faster.