browse for an excel file and save the data as a matrix

I want to create a function to browse for an excel file and save the data as a matrix. I have only been able to find ways to import data when I already know the name of the file. I used the funtcion generator to create a funtion to do it but it doesn't include code to save the matrix. I would think you could do something like this: datafile1 = uiimport('-file'); xlsread(datafile) but that doesn't work. I'm sure this is a simple task but I can't find any forums or demos that explain hot to do this. The excel file I will use will have two columns one with date and time and the other with a number value and there are no headers in the file. I want to be able to select a different file everytime and have it save as a matrix.

Answer 1

[Geoff]

Use the function uigetfile to browse for a filename, then pass that name to xlsread.

Answer 2

[Matthew]

I tried this but it only returned the data from the second column and did not do the date and time conversion

datafile1 = uigetfile; xlsread(datafile1,'Sheet1','','',@convertSpreadsheetDates);

Answer 3

[Matthew]

I got it figured out thanks