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?

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?

Answer 1

[Konstantinos Sofos]

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?

[SOHAM BANERJEE]

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.