VERTCAT error when trying to populate array

Question

Teshan Rezel 2021-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/871268-vertcat-error-when-trying-to-populate-array

评论： Teshan Rezel 2021-7-7

Hi folks,

I am trying to write some fata into an array, which I will then write to excel. I get the VERTCAT error when trying to create the array (Error using vertcat Dimensions of arrays being concatenated are not consistent).

Can you help identify why this is please?

Each column of data should be 256 elements long.

My code is as follows:

headings = {'Pixel Value', 'R', 'G', 'B', 'Grey'};
pixelValue = (0:255)';
allCoke_R = imhist(allCokeMask(:,:,1));
allCoke_G = imhist(allCokeMask(:,:,2));
allCoke_B = imhist(allCokeMask(:,:,3));
allCokeGrey = imhist(rgb2gray(allCokeMask));
dataCollectionAllCoke = zeros(257, 5);
dataCollectionAllCoke = [headings; pixelValue, allCoke_R, allCoke_G, allCoke_B, allCokeGrey];
writecell(dataCollectionAllCoke, resultsPath, 'Sheet', nameStringExcel, "Range", 'A1'); 

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

请先登录，再进行评论。

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

Answer 1

Jonas 2021-7-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/871268-vertcat-error-when-trying-to-populate-array#answer_739223

在 MATLAB Online 中打开

try putting {} around the second line of concatenation

dataCollectionAllCoke = [headings; {pixelValue, allCoke_R, allCoke_G, allCoke_B, allCokeGrey}];

or convert all variable entries to cells

dataCollectionAllCoke = [headings;num2cell([pixelValue, allCoke_R, allCoke_G, allCoke_B, allCokeGrey])];

both should work concerning the concatenation, but i am not sure about the needed format for the writematrix() command

4 个评论
显示 2更早的评论隐藏 2更早的评论

Jonas 2021-7-6

在 MATLAB Online 中打开

i tested the code myself now, it works as expected. of course i don't know what you spcified in the further parameters of the writecell() call

headings = {'Pixel Value', 'R', 'G', 'B', 'Grey'};
pixelValue = (0:255)';
allCokeMask=randi(255,100,100,3);
allCoke_R = imhist(allCokeMask(:,:,1));
allCoke_G = imhist(allCokeMask(:,:,2));
allCoke_B = imhist(allCokeMask(:,:,3));
allCokeGrey = imhist(rgb2gray(allCokeMask));
dataCollectionAllCoke = [headings; num2cell([pixelValue, allCoke_R, allCoke_G, allCoke_B, allCokeGrey])];
writecell(dataCollectionAllCoke, 'test.xls'); 