How to export xls file from Matlab

2 visualizzazioni (ultimi 30 giorni)
Hello
I use this code to get the sum of pixels for a certain area of an image
for col = col1 : col2
row2 = find(mask(:, col), 1, 'last'); % Get bottom row of mask
if ~isempty(row2)
% Get the sum in the GREEN channel, from row1 to row2.
grayLevelSum(col) = sum(greenChannel(topRow:row2, col));
% Compute the height of the mask at every column.
heights(col) = sum(mask(topRow:row2, col));
end
end
I also get the results like
Column 0:
0 0 23 23 22 22 21 100 112 113
Column 1:
99 99 87 88 84 32 23 22 21
Column 2:
113 114 155 165 166 210 222 255
... etc
What I want is a way to either have the column results vertically so I can copy and paste them in rows in an xls file or if there is a script to export them directly in rows,columns in xls file determined by me.
Thank you so much

Risposta accettata

Walter Roberson
Walter Roberson il 18 Gen 2019
data = [grayLevelSum(:), heights(:)];
sheet = 1;
range = 'A:B';
xlswrite('YourFile.xls', data, sheet, range)
  1 Commento
Stelios Fanourakis
Stelios Fanourakis il 18 Gen 2019
More or less yes. What I need. But why two columns (A:B) that have same values?
The numbered column before A, gives the number of columns in the image, then column A should give the sum number of pixels for the respective column. Why column B then? In my case, it is just a duplicate column of A, having the same values as column A.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Display Image in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by