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?

1 visualización (últimos 30 días)
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?

Respuesta aceptada

Konstantinos Sofos
Konstantinos Sofos el 31 de Oct. de 2015
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();
  1 comentario
SOHAM BANERJEE
SOHAM BANERJEE el 31 de Oct. de 2015
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.

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by