I have few excel program that I needed to be read by MATLAB. Now I want to enter the file name as an input. How do I make Matlab read that input file name?
2 views (last 30 days)
Show older comments
SOHAM BANERJEE
on 31 Oct 2015
Commented: SOHAM BANERJEE
on 31 Oct 2015
I have an excel program which contains different sheets and I need Matlab to read the data in each sheet one by one. I am required to put the file name (excel file) as an input and need Matlab to read the input variable. How do I do it?
0 Comments
Accepted Answer
Konstantinos Sofos
on 31 Oct 2015
Hi,
xlsfinfo will get you a list of sheet names into your Excel file.
[~,sheets] = xlsfinfo(filename);
A more elegant way (that I suggest) is to learn how to use ActiveX to parse data from your Excel e.g.
filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
A good starting point is here as reference Are there any examples that show how to use the ActiveX automation interface to connect MATLAB to Excel?
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!