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?

2015 10 31
1 个回答
回答已采纳
更新时间：2015 10 31
10 次查看（30 天）

0 个投票

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?

请先登录，再回答此问题。

 采纳的回答

Konstantinos Sofos
Konstantinos Sofos 2015-10-31

0 个投票

Hi,
xlsfinfo will get you a list of sheet names into your Excel file.
[~,sheets] = xlsfinfo(filename);
Then you can use xlsread to read data from each specific sheet.
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?

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

SOHAM BANERJEE
SOHAM BANERJEE 2015-10-31
I was using A=xlsread('NSKapkot.xlsx','20080819','B3561:B3961') command. But I want to input all those within the inverted comma in a variable. Like while running the program it would ask me the name of the file, sheet no , column & row and after providing those it will be able to read the file accordingly.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by