exporting binary matrix to excel

Hi using dec2bin i have converted matrix into a binary vector, now i want to export the binary vector to excel, i am facing problem that all the bits of a particular element dont appear in the single cell,.e.g ,the

second element of the vector is 100, i want it to be stored as E1 in the picture, rather than it is stored by xlswrite command like the row 2. in three different cells, A2, B2 and C2

Answer 1

[Walter Roberson]

Provided that YourMatrix is the output of dec2bin(), which is actually character rather than numeric, then:

xlswrite(TheFileNameGoesHere, cellstr(YourMatrix))

[Hafeez]

thank you Mr Walters for your kind support.

Answer 2

[Cyrus]

you can download and use this file: xlsappend.m

move the file in the same directory close to your matlab files and use it this way:

Matrix = rand([3, 10]);
[success,message] = xlsappend('a.xlsx', Matrix);

and you have to create the excel file before you run the code and file shouldn't be open.