Open Excel files in Apps Designer

Question

Mo 2022-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1875322-open-excel-files-in-apps-designer

编辑： Voss 2022-12-10

Hi

I created an App in Matlab and the Push button only opens the Excel file that are already created and saved. I want to open any Excel file in future and not only the saved file. This is my push button function in Apps Designer and it only works with the "File.xlsx" that I saved the data before. I want to add new data (new spreadhseet) or select another excel file and run the function. I also have a Drop down button the select the sheet.

% Button pushed function: OpenFileButton
function OpenFileButtonPushed2(app, event)
sheetNames= app.SheetsDropDown.Value;
t=readtable("file.xlsx","Sheet",sheetNames);
app.UITable.Data=t; 
t.Properties.VariableNames{1}='x';
t.Properties.VariableNames{1}='y';

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2022-12-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1875322-open-excel-files-in-apps-designer#answer_1124997

You must pass a vaid file name to readtable. Consider modifying your code to incorporate uigetfile, which will allow your users to interactively select the file to use.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Voss 2022-12-10

在 MATLAB Online 中打开

@Mo: uigetfile returns the name of the selected file. You still have to pass that file name to readtable in order to read the file:

% Button pushed function: OpenFileButton
function OpenFileButtonPushed2(app, event)
    
    [filename,pathname] = uigetfile('*.xlsx');
    
    if isnumeric(filename) % user clicked Cancel
        return
    end
    
    sheetNames = app.SheetsDropDown.Value;
    
    t = readtable(fullfile(pathname,filename),"Sheet",sheetNames);
    
    app.UITable.Data=t; 
    t.Properties.VariableNames{1}='x';
    t.Properties.VariableNames{1}='y';
    % ...
end