how to export a time matrix to Excel

조회 수: 1 (최근 30일)
zeezo
zeezo 2016년 5월 8일
댓글: Image Analyst 2016년 5월 9일
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

답변 (1개)

Image Analyst
Image Analyst 2016년 5월 8일
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
zeezo
zeezo 2016년 5월 9일
Thank you but this one does not work because It separate each digit in a cell
Image Analyst
Image Analyst 2016년 5월 9일
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.

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by