MATLAB: Get selected range in Excel file using MATLAB

excelrange cells

Hello,

I have seen a MATLAB GUI program that is able to open the Excel file and get the range of the cells that the user have selected. This value is returned to MATLAB.

I have no idea how it is possible since the Excel file is normal without any macro. Additionally, when MATLAB opens an Excel file, it does not run anymore so how possible can we obtain anything from Excel ?

Thank you very much in advance.

Best Answer

The function is probably uiimport. Type uiimport in Command Window to start.

You can also use xlsread(). Type help xlsread to find out.

Related Solutions

MATLAB: Problem in runnning .m file

I believe MATLAB is getting confused because when it first examines the file, your "data" symbol does not appear to be a variable. Try something like this:

s = uiimport
plot(s.data(:,1),s.data(:,2))

Here "s" is obviously a variable, and "data" becomes a field of that variable as a result of the uiimport.

MATLAB: Xlsread with sheet selection and xlRange

Looks like your excel file has nothing but string data, hence the 1st output of xlsread will give you empty (no numeric data to show). Here's more info on xlsread .

Try the following, and use the data you need:

[NumData, TextData, AllData] = xlsread(filename, sheet, xlRange)

Also, A1:B1 will only select the 1st row of A to B. Use xlRange = 'A:B' to select the A and B columns instead.

Best Answer

Related Solutions

MATLAB: Problem in runnning .m file

MATLAB: Xlsread with sheet selection and xlRange

Related Question