Converting matrix to binary matrix and then saving the matrix to excel

Question

Hafeez 2016-12-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/316131-converting-matrix-to-binary-matrix-and-then-saving-the-matrix-to-excel

评论： Hafeez 2016-12-9

Hi.I want to export image matrix in binary format to excel,I have used dec2bin to covert my image matrix into binary format.The problem i am facing is that the dec2bin coverts the image matrxi into binary vector, i want the results in matrix form and then stored in the excel as rows and coloums.code is attached.

    A=imread('lena.tiff');
x=dec2bin(A,8)
xlswrite('bin.xlsx', cellstr(x))

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-12-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/316131-converting-matrix-to-binary-matrix-and-then-saving-the-matrix-to-excel#answer_246561

编辑：Guillaume 2016-12-9

在 MATLAB Online 中打开

As pointed out by Walter in your previous identical question, dec2bin does not convert into a binary vector but into a char matrix.

It's not clear what your new question is asking. If you're asking how to reshape that cell array that is the result of cellstr into the same shape as your image, then simply use reshape

xlswrite('bin.xlsx', reshape(cellstr(x), size(A)))