How to display Date as output in Appdesigner?

5 次查看（过去 30 天）
Raja Suriyan
Raja Suriyan 2022-4-5
评论： Raja Suriyan 2022-4-5
Hi I am trying to find the earliest start date and the latest finish date for activities.
I have received inputs from user and stored it in an excel file.
Now how to find the earliest start date and the latest finish date and also display it to the user. Also calculate the total cost ie. sum of variable values when the update button is pushed.
% Button pushed function: SaveButton_2
function SaveButton_2Pushed(app, event)
n = app.EnterTotalNoofActivitiesEditField.Value;
% Create table array
sz = [n 4];
varTypes = {'string','datetime','datetime','single'};
varNames = {'Activity','Start Date','End Date','Planned Value'};
t = table('Size',sz,'VariableTypes',varTypes,'VariableNames',varNames);
% Create table UI component
uit = uitable(app.UIFigure);
uit.Data = t;
uit.ColumnEditable = true;
uit.Position(3) = 310;
end
% Button pushed function: RollupButton
function RollupButtonPushed(app, event)
uit = findobj(app.UIFigure,'Type','uitable');
sheet = 'Budget';
writetable(uit.Data,'EVM.xls','Sheet',sheet);
end
% Button pushed function: ExporttoExcelButton_2
function ExporttoExcelButton_2Pushed(app, event)
winopen('EVM.xls');
end
% Button pushed function: UpdateButton
function UpdateButtonPushed(app, event)
end

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

回答（1 个）

Walter Roberson
Walter Roberson 2022-4-5
If you are using datetime() objects, then min() and max() are available for those.
You can set the Format property of a datetime object and then string() the object to get text.
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2022-4-5
The first output of xlsread() is never a datetime object. It might be a serial date number, but datetime() applied to serial date numbers requires a "convertfrom" option.
You should consider switching to readtable()
Raja Suriyan
Raja Suriyan 2022-4-5
I tried read table also...read table is not reading datetime I guess.
Any way to rectify it?
Error: Error using min
Invalid data type. First argument must be numeric or logical.
% Button pushed function: Button
function ButtonPushed(app, event)
c=readtable('EVM.xls','Sheet','Budget','Range','B2');
c=min(c);
c=string(c);
app.DateEditField.Value=c;
end
end

请先登录，再进行评论。

类别

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

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by