清空筛选条件
清空筛选条件

Decimal point disappear when i use matlab read xlsx file. Is there anyone know how to solve this problem?

3 次查看（过去 30 天）
Sam
Sam 2019-9-12
评论： Sam 2019-9-13
Unbenannt1.png
  3 个评论
显示 1更早的评论
Stephen23
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 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by