how to export a time matrix to Excel
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a time matrix a=[04:23:00; 05:34:22; 05:44:43]
I want to export this one to Excel. I tried but it put every time digit in a cell
0 commentaires
Réponses (1)
Image Analyst
le 8 Mai 2016
That's not a time matrix. It's a matrix of 3 sequences, the first of which are null, and the last two just have the first element, strung together. So the entire array is [5,5].
Anyway, to write it out to Excel workbook, you do it just like any other variable
xlswrite(filename, a);
2 commentaires
Image Analyst
le 9 Mai 2016
That's because your matrix is not right. Please show the exact matrix. If you're using strings, you need to use single quotes around them, otherwise you get numbers, like I showed. If you have strings, you need to put them into cells before writing them out otherwise the string will go one character per column rather than the whole string into one Excel cell.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!