MATLAB: Importing excel numerical data into menu options

excelimporting excel datamenuurgent

[EDIT: Thu May 12 23:00:29 UTC 2011 Duplicate Removed – MKF]

This is the code that i have for my program. I am trying to import all of the numerical data from the first column of the worksheet into the menu as options, but it is only giving me the very first one. Please help me figure out what I need to do. Thanks!

 %The Excel worksheet 'COST' is inputed into MATLAB.
  [COSTdata,COSTtext]=xlsread('48FF5.xlsx','COST');
%The user is prompted to select the diameter of pipe they wish to use. 
Diameter=menu('Select pipe diameter',COSTdata(1:length(COSTdata)));

Best Answer

t = cellstr(num2str(costdata(:,1)));
Diameter = menu('Select pipe diameter', t{:});

Related Solutions

MATLAB: I have 2 columns and 10 rows of numerical data in the excel file. How to import this data in to MATLAB and then plot it

Importing data from Excel can be done using the “readtable” function.

For example, to read all data from myfile.xls:

T = readtable('myfile.xls')

Or read only a specific range from a specific sheet using:

T = readtable('myfile.xls', 'Sheet',1, 'Range','A1:B10')

Plot the data from the table using a visualization function. For example, use “scatter”:

X = T.Var1; % First column of data
Y = T.Var2; % Second column of data
scatter(X,Y);

For more information, see:

https://www.mathworks.com/help/matlab/ref/readtable.html

MATLAB: Xlsfinfo question

A little bit of clarification needed... From your code it appears that you have m directories; in any given directory there are n files; in any given file there are p worksheets, correct? (Sounds like the old "St Ives" nursery rhyme...) Now, at what level do you want to ask the user for the worksheet name? For every file in every directory (so m*n times in total)? Or will the files have the same worksheets, so that you need only ask at each directory (just m times because all n files have the same p worksheets), or even just once overall (because all m*n files have the same p worksheets)? This will affect your second set of for-loops.

Anyway, that detail aside, the neatest solution is probably to gather the worksheet names into a cell array of strings, then use the menu function:

k = menu('Choose a worksheet',sheetnames);

This will pop up a dinky pushbutton menu and return, in the variable k, the number of the pushbutton that the user clicked.

EDIT TO ADD: Based on your comment, then, I'd do something like this

for i=1:length(ExcelFileName);
  [~,sheetnames] = xlsfinfo((fullfile(pathName,SubFolder{1,i},ExcelFileName{1,i}{1,1})));
  sheetnum = menu('Choose a worksheet',sheetnames);
  for k=1:length(ExcelFileName{1,i});
     % Read in worksheet sheetnum from kth file
  end
end

Gah. Words are indeed terrible for this, sometimes! Maybe you mean that it should ask the user for the sheet of each file (but the sheet names are the same)? If so, slight modification: just move the menu command inside the loop over k.

Best Answer

Related Solutions

MATLAB: I have 2 columns and 10 rows of numerical data in the excel file. How to import this data in to MATLAB and then plot it

MATLAB: Xlsfinfo question

Related Question