How to export negative number to a .csv file using writetable()
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Stephen23
el 4 de Jul. de 2022
Editada: Stephen23
el 4 de Jul. de 2022
"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)
Respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!