"xlswrite" Generates A Negative Number for This Line
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Dear All,
I find that the following command line "xlswrite(['test.xlsx'],{'(100,100,100)'});" gives me a line of "-100,100,100" in the output "test.xlsx" file, which is not in accord with the input string. Could anyone tell me why this happens and how to fix it ?
Many thanks !
Best regards,
Gary
0 commentaires
Réponses (1)
dpb
le 3 Août 2015
It's a fignewton of how Excel interprets the string; enclosed in the parentheses it apparently tries to convert to a numeric value and presumes the parens indicate a negative value. As for "how to fix", what do you want the result to be in Excel--that literal string, a negative currency, an array of three integers, ...?
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!