Borrar filtros
Borrar filtros

Importing data from excel

3 visualizaciones (últimos 30 días)
Hazal Eylül
Hazal Eylül el 4 de Abr. de 2023
Editada: Image Analyst el 4 de Abr. de 2023
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 comentarios
Mathieu NOE
Mathieu NOE el 4 de Abr. de 2023
which function do you use to import excel files ?
Hazal Eylül
Hazal Eylül el 4 de Abr. de 2023
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.

Iniciar sesión para comentar.

Respuestas (1)

Image Analyst
Image Analyst el 4 de Abr. de 2023
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 comentarios
Hazal Eylül
Hazal Eylül el 4 de Abr. de 2023
It is not random, I took them from a database, they are real process numbers.
Image Analyst
Image Analyst el 4 de Abr. de 2023
Editada: Image Analyst el 4 de Abr. de 2023
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.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by