Errors using xlsread to import data from Excel
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Justin Hayes
am 1 Apr. 2020
Kommentiert: Justin Hayes
am 2 Apr. 2020
I am trying to pull data from Excel. I was able to do this up until today. I did update my Matlab license and am wondering if this has anything to do with the problems I am having below. Any suggestions?
Warning: Range cannot be used in 'basic' mode. The entire sheet will be loaded.
> In xlsread (line 208)
In untitled123123 (line 3)
Error using xlsread (line 257)
XLSREAD unable to read sheet 'irradiance_month'.
File contains unexpected record length. Try saving as Excel 98.
Error in untitled123123 (line 3)
Solar_Irradiance_Month = xlsread('DATA.xls','irradiance_month','C1:C13')
>>
Akzeptierte Antwort
Jeremy Hughes
am 1 Apr. 2020
Sometimes the Excel instalation can break xlsread, there shouldn't be a reason MATLAB install changed anything for you. It might be an update, or just something out of sync.
I'd suggest you port this to readcell:
Solar_Irradiance_Month = readcell('DATA.xls','Sheet','irradiance_month','Range','C1:C13')
3 Kommentare
Jeremy Hughes
am 2 Apr. 2020
Bearbeitet: Jeremy Hughes
am 2 Apr. 2020
Actaully, if you know the data is all numeric, you can use readmatrix instead:
Solar_Irradiance_Month = readmatrix('DATA.xls','Sheet','irradiance_month','Range','C1:C13')
The indexing would then be the same as what you'd use with xlsread's results.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!