I need to import a database depending on an input argument.
1 view (last 30 days)
Show older comments
If a user chooses 'x' as a parameter being studied, I would like to import the number 'x' is equal to as an excel database which contains the information to be analysed. Is this possible?
In example
How would I implement this to open the 203 database using the Bead1 definition. I have databases for all numbers shown e.g. 203.xlsx etc
% Acquired Bead SSC-H Median Values
Bead1 = 203;
Bead2 = 400;
Bead3 = 707;
Bead4 = 1019;
Bead5 = 1587;
1 Comment
Walter Roberson
on 6 Sep 2016
Should be merged into original question http://www.mathworks.com/matlabcentral/answers/301980-is-it-possible-to-use-an-argument-in-order-to-choose-which-excel-file-should-be-imported
Accepted Answer
KSSV
on 6 Sep 2016
Wit the given input value (Bead1), you make a filename and read it using xlsread.
Bead1 = 203 ;
filename = strcat(num2str(Bead1),'.xlsx') ; % this makes filename with extension .xlsx
data = xlread(filename) ; % read the file
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!