some numbers expressed as date when downloaded as xlsx file

조회 수: 1 (최근 30일)
alpedhuez
alpedhuez 2020년 7월 2일
답변: Gouri Chennuru 2020년 7월 8일
I created some numbers in a table and downloaded the table into xlsx using writetable function. Then some numbers are displayed as date in the output xlsx file. How can I fix this issue?
  댓글 수: 1
Rik
Rik 2020년 7월 2일
Blame Excel. You should probably explicitly set the data type to Number in Excel.

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

이 질문에 답변하려면 로그인하십시오.

답변 (1개)

Gouri Chennuru
Gouri Chennuru 2020년 7월 8일
Hi alpedhuez,
You can create a table and export into xlsx file with the help of writable function using this documentation link.
You can select the columns in excel spreadsheet and change the number format in xlsx file to Number if any dates are visible.
Hope this Helps!

카테고리

Help Center 및 File Exchange에서 Downloads에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by