"xlswrite" Generates A Negative Number for This Line
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
dpb
2015년 8월 3일
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, ...?
댓글 수: 2
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!