exporting binary matrix to excel

3 次查看（过去 30 天）
Hafeez
Hafeez 2016-12-7
评论： Hafeez 2016-12-9
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

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

采纳的回答

Walter Roberson
Walter Roberson 2016-12-7
Provided that YourMatrix is the output of dec2bin(), which is actually character rather than numeric, then:
xlswrite(TheFileNameGoesHere, cellstr(YourMatrix))

更多回答（1 个）

Cyrus
Cyrus 2016-12-7
编辑：Cyrus 2016-12-7
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.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by