How to export negative number to a .csv file using writetable()
2 次查看(过去 30 天)
显示 更早的评论
Hello,
I tried to export a table contaiing a negative value to a .csv file as follows:
C ={'4 -9'}
T = table(C)
writetable(T, 'filename' '.csv')
I'm getting 09-Apr as output because of the negative 9. How can I fix this issue directly in Matlab.
2 个评论
Stephen23
2022-7-4
编辑:Stephen23
2022-7-4
"I tried to export a table contaiing a negative value to a .csv file as follows:"
But your example shows you exporting some text, no negative numeric values are involved.
C = {'4 -9'};
T = table(C);
writetable(T, 'test.txt')
type test.txt
"I'm getting 09-Apr as output because of the negative 9."
No, you are getting "09-Apr" because you made the mistake of opening a text file using MS Excel.
"How can I fix this issue directly in Matlab."
How can MATLAB "fix" problems caused by MS Excel's dodgy importing algorithms? (hint: no one can)
回答(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!