MATLAB: How to open a generic (not defined) EXCEL file

actxserverexcel

Hello,
the procedure to access a spreadsheet data from MATLAB running an Excel application in an Automation server is well known and explained at the matlab documentation. At the Matlab documentation can be seen something like this:
exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open([docroot '/techdoc/matlab_external/examples/input_resp_data.xls']);
I am writing a code at GUIDe and I haven't found the code to load a generic excel file at a programm function ( something like winopen(cd) at the Command Window). There are other matlab functions like uiopen('-file'), but they dont load the file. Open does also not work because the file in that case has to be defined by the programmer. I need the file to be choosed by the end user.
Thank you.

Best Answer

Is this what you want to do? Have user select an excel file, and then open the excel file with MS Office, or whatever application is set to open this file?
[FileName, FilePath] = uigetfile('*.xls*', 'Open Excel File');
winopen(fullfile(FilePath, FileName));
Related Question