"xlswrite" Generates A Negative Number for This Line

Question

Gary Leung 2015-8-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/232093-xlswrite-generates-a-negative-number-for-this-line

评论： Walter Roberson 2015-8-4

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2015-8-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/232093-xlswrite-generates-a-negative-number-for-this-line#answer_188041

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, ...?