Loading data from Excel file
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Tino
el 1 de Mayo de 2019
Comentada: Guillaume
el 1 de Mayo de 2019
Hello
Please can anyone assist me on how to load data from excel file using the function load
Thanks in advance
Tino
1 comentario
Guillaume
el 1 de Mayo de 2019
You cannot use the function load to read excel file, and it's puzzling why you think you could. load only works for loading mat files (and a few types of text files that are better read with other functions).
See KSSV's answer for which functions to use.
Respuesta aceptada
Walter Roberson
el 1 de Mayo de 2019
The only kind of "excel file" that you can use with load() is a .csv file. In order to use a .csv file with load(), it must be purely numeric with no headers, and with no text, and with no missing entries.
.xls and .xlsx files can never be used with load(). .csv files with missing entries or with any text anywhere cannot be used with load(). Also, .csv files that use comma as the decimal separator will not be interpreted correctly by load() if they manage to load at all.
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets 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!