I need to import a database depending on an input argument.
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
Walter Roberson
2016-9-6
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
采纳的回答
KSSV
2016-9-6
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!