Error with reading excel file

9 次查看（过去 30 天）
Anders Vigen
Anders Vigen 2021-2-19
回答： Anders Vigen 2021-2-23
start_date = datetime(2020,1,2,0,0,0);
end_date = datetime(2020,1,3,0,0,0);
demand = load_demand('Demand_timeseries_1hourResolution.xlsx',start_date,end_date);
figure (21)
plot(demand.Time, demand.Values)
xlabel('Time');
ylabel('Demand [MW]');
title('Demand')
I'm having bit of a frustrating issue with my scrript. I wantto read excel file in the same folder where I have my matlab file, however it keeps giving me the same error
'Unrecognized function or variable 'load_demand''
The script works for everybody else but me, so I can't find the problem.
I hope somebody can help me
  13 个评论
显示 11更早的评论
Anders Vigen
Anders Vigen 2021-2-20
It gives me
built-in (C:\Program Files\MATLAB\R2020b\toolbox\matlab\general\which)
'load_demand' not found.
Unrecognized function or variable 'load_demand'.
Error in main_2 (line 136)
demand = load_demand('Demand_timeseries_1hourResolution.xlsx',start_date,end_date);
And this was the script I put in
builtin('which', 'which')
which load_demand
demand = load_demand('Demand_timeseries_1hourResolution.xlsx',start_date,end_date);
Walter Roberson
Walter Roberson 2021-2-20
Okay, and what about on your colleague's computer? What shows up on there?
At this point, I can pretty much predict an implimentation of the function:
function demand = load_demand(filename, start_date, end_date)
T = readtable(filename);
mask = isbetween(T{:,1}, start_date, end_date);
demand = T(mask,:);
end

请先登录，再进行评论。

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

采纳的回答

Anders Vigen
Anders Vigen 2021-2-23

更多回答（1 个）

Ani Singh
Ani Singh 2021-2-21
From the error "'Unrecognized function or variable 'load_demand" looks like you do not have "load_demand" user-defined function implementation(which is not function provided by MathWorks).
Please get the "load_demand" file from your colleague's system or write implementation your function.
Example:
function demand = load_demand(fileName, startDate, endDate)
excelOutput = readtable(fileName);
query = isbetween(excelOutput{:,1}, startDate, endDate);
demand = excelOutput(query,:);
end
  1 个评论
Walter Roberson
Walter Roberson 2021-2-22
According to other posts by the same user, the file turns out to have a date column and an hours column, but the hours problem had text such as '00-01' and '07-08'

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by