Reading Excel File With Known Folder Path

Hi,

The device I work with give me 2 different excel file after prosess. Name of the first one is '195648762' and the second one is 'Evt195648762'. These two file will be in the same folder on the desktop.

On the interface, user has to select the first file by searching folder. After selection, the code gets the file name, combine it with 'Evt' and gives me the second file name.

I want to read second excel file by using the file path and the second file name. How can I do that?

Thank you.

Answer 1

[Maria]

First, you need to get the file '195648762' by searching it on the interface using 'uigetfile'. Then you storage that filename and path on a string by using [file,path] = uigetfile and then you edit the filename adding the Evt to it. Once you have the filename, just add it to the path and use xlsread.

https://es.mathworks.com/help/matlab/ref/uigetfile.html