Importing data from excel

2023 4 4
1 个回答
更新时间：2023 4 4
4 次查看（30 天）

0 个投票

When I try to import data from excel decimal numbers are shown with / not . or , For example in my excel decimal number is 567,45 matlab shows 567/45. How can I change it?

2 个评论
显示 无 隐藏 无

Mathieu NOE
Mathieu NOE 2023-4-4
which function do you use to import excel files ?
Hazal Eylül
Hazal Eylül 2023-4-4
I used readmatrix, I think matlab shows me the numbers as division. When i divide numbers next to /, I got the values in my excel.

请先登录，再进行评论。

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

回答（1 个）

Image Analyst
Image Analyst 2023-4-4

0 个投票

What country is your operating system setup for? Is it a country that uses comma instead of period for the decimal point? Otherwise there could be a mismatch perhaps between how the workbook was created and your operating system. Did you create it, or did some other computer create it? Can you attach it?

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Hazal Eylül
Hazal Eylül 2023-4-4
I'm not sure but I think it is Turkey. In Turkey comma is used for decimal numbers. In my excel whether it is comma or period it shows as division. I created excel sheet myself and I can not share it since it is confidential.
Image Analyst
Image Analyst 2023-4-4
If you created one with just random numbers, that would not be confidential.
Hazal Eylül
Hazal Eylül 2023-4-4
It is not random, I took them from a database, they are real process numbers.
Image Analyst
Image Analyst 2023-4-4
编辑：Image Analyst 2023-4-4
I know that of course. But I'm saying that if you don't want to share a workbook with your "real" numbers and strings, then just make up a "fake" workbook with fake, made-up numbers and strings and upload the fake workbook.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by