Filter löschen
Filter löschen

some numbers expressed as date when downloaded as xlsx file

1 Ansicht (letzte 30 Tage)
alpedhuez
alpedhuez am 2 Jul. 2020
Beantwortet: Gouri Chennuru am 8 Jul. 2020
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 Kommentar
Rik
Rik am 2 Jul. 2020
Blame Excel. You should probably explicitly set the data type to Number in Excel.

Melden Sie sich an, um zu kommentieren.

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (1)

Gouri Chennuru
Gouri Chennuru am 8 Jul. 2020
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!

Kategorien

Mehr zu Downloads finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by