some numbers expressed as date when downloaded as xlsx file
1 回表示 (過去 30 日間)
古いコメントを表示
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
2020 年 7 月 2 日
Blame Excel. You should probably explicitly set the data type to Number in Excel.
回答 (1 件)
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!
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Downloads についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!