清空筛选条件
清空筛选条件

Errors using xlsread to import data from Excel

13 次查看（过去 30 天）
Justin Hayes
Justin Hayes 2020-4-1
评论： Justin Hayes 2020-4-2
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')
>>
  1 个评论
Justin Hayes
Justin Hayes 2020-4-1
This is the code I am running
Solar_Irradiance_Month = xlsread('DATA.xls','irradiance_month','C1:C13')

请先登录，再进行评论。

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

采纳的回答

Jeremy Hughes
Jeremy Hughes 2020-4-1
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 个评论
显示 1更早的评论
Jeremy Hughes
Jeremy Hughes 2020-4-2
编辑：Jeremy Hughes 2020-4-2
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by