Decimal point disappear when i use matlab read xlsx file. Is there anyone know how to solve this problem?
조회 수: 3 (최근 30일)
이전 댓글 표시
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/238120/image.png)
![Unbenannt1.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/238122/Unbenannt1.png)
댓글 수: 3
Stephen23
2019년 9월 13일
편집: Stephen23
2019년 9월 13일
As Walter Roberson wrote, confusion reagrding the decimal radix character is quite likely.
It is also obvious from the Excel screenshot that some of the "numbers" are left-aligned, whereas others "numbers" are right-aligned. That usually indicates that some of the "numbers" are not being stored as numeric values but at text (an incorrect decimal radix character or thousands separator is likely to be the cause).
The solution is to fix your Excel workbook to ensure that numbers are not stored as text.
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!