writing date on an excel sheet
조회 수: 27 (최근 30일)
이전 댓글 표시
Hi folk,
Got a question about writing date on an excel sheet. I am using the following codes:
DATE=datestr(now);
xlswrite('test.xls', DATE, 'A1')
The problem is that it separates each number and letter and put them in separate cells. I want the whole date in one cell like 'A1' but it appears from 'A1' to 'T1'
I appreciate your help. Thank you.
S:-)
댓글 수: 1
Prieni
2017년 8월 18일
편집: Prieni
2017년 8월 18일
Just came across the problem to export date/time to an Excel sheet. If you do this:
DATE = now - datenum(1899,12,30,0,0,0);
xlswrite('test.xls',DATE)
you get a number in your Excel sheet that, if you change formatting to date, shows the current date. It also includes the current time which you can see when you select that date.
채택된 답변
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!