How to export negative number to a .csv file using writetable()
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Stephen23
il 4 Lug 2022
Modificato: Stephen23
il 4 Lug 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)
Risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!