Errors using xlsread to import data from Excel
10 views (last 30 days)
Show older comments
Justin Hayes
on 1 Apr 2020
Commented: Justin Hayes
on 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')
>>
Accepted Answer
Jeremy Hughes
on 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 Comments
Jeremy Hughes
on 2 Apr 2020
Edited: Jeremy Hughes
on 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.
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!