How to export negative number to a .csv file using writetable()

2 次查看（过去 30 天）

Joel Olenga 2022-7-4

评论： Joel Olenga 2022-7-4

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.

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
C
4 -9

"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)

Joel Olenga 2022-7-4

Thanks!

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by