exporting binary matrix to excel
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/158760/image.png)
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
0 Commenti
Risposta accettata
Walter Roberson
il 7 Dic 2016
Provided that YourMatrix is the output of dec2bin(), which is actually character rather than numeric, then:
xlswrite(TheFileNameGoesHere, cellstr(YourMatrix))
Più risposte (1)
Cyrus
il 7 Dic 2016
Modificato: Cyrus
il 7 Dic 2016
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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets 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!