How can I suppress that xlswrite automatically converts a double into a date?
조회 수: 1 (최근 30일)
이전 댓글 표시
When I save a floating point number into an excel File with xlswrite() it automatically converts into a date. Can anybody tell me how I can suppress this?
댓글 수: 0
답변 (1개)
Albert Yam
2012년 8월 27일
Can you give an example of what you are experiencing in the OP? I have had a date appear, for me, but for a different purpose (not floating point). This is how I got what I was looking for.
xlsname = 'testxls.xls';
writethis = {'1/94';... %this give Jan/94 = 1/1/94 = 34335(text)
'''1/94';... %what I needed
12.1;... %trying to replicate
'''12.1';... %but no problem
1.12;... %please
'''1.12'}; %give example
xlswrite(xlsname,writethis)
댓글 수: 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!