how to open excel files and write data?

6 次查看（过去 30 天）
Devendra
Devendra 2024-3-24
编辑： 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

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

回答（1 个）

Alexander
Alexander 2024-3-24
编辑：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.

类别

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

标签

产品


版本

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by