how to read the Sheet name present in any Excel file ?

54 visualizaciones (últimos 30 días)
Ajay Pherwani
Ajay Pherwani el 6 de Feb. de 2013
Comentada: Walter Roberson el 8 de Ag. de 2023
I am working on a script , that will read the data present in an excel file. The sheet is an standard template one . There are many Sheets present in a excel file (and will vary depending upon the various products that we have ... and i am trying to make a general script that will work over all excel files).
Is there any way to find out the names of the sheets in the excel file ?
I have tried 'xlsread' , but that didn't help much
is there any command that will help me fetch the total number of sheets and their names ?
Regards, Ajay

Respuesta aceptada

owr
owr el 6 de Feb. de 2013
"xlsfinfo" will get you a list of sheet names.

Más respuestas (2)

Pruthvi G
Pruthvi G el 13 de Abr. de 2020
%%********************************************************************************
% Name : xl_xlsfinfo
% Author : Pruthvi Raj G
% Version : Version 1.0 - 2011b Compactible
% Description : Finds all the sheets in the Excel file (.xls,.xlsm,.xlsx)
% Input : File_Name with path included.
% Date : 11-Feb-2020
%
% Examples : xl_xlsfinfo('D:\Pruthvi\Test_file.xls')
%*********************************************************************************
Use the Below Lines of Code ::
sheets = xl_xlsfinfo('D:\Pruthvi\Test_file.xls')
sheets =
1×5 cell array
{'Sheet1'} {'Sheet2'} {'Sheet3'} {'Sample'} {'Data'}
  3 comentarios
wenchao zhang
wenchao zhang el 8 de Ag. de 2023
[STATUS,SHEETS,FORMAT] = xlsfinfo('D:\MatlabWorkSpace\read_the_Sheet_name\data.xlsx');
Walter Roberson
Walter Roberson el 8 de Ag. de 2023
Or, as @Remy Lassalle-Balier pointed out, these days sheetnames is recommended.

Iniciar sesión para comentar.


Kaiser Ahmed Bhuiyan
Kaiser Ahmed Bhuiyan el 1 de Oct. de 2020
Editada: Kaiser Ahmed Bhuiyan el 1 de Oct. de 2020
The perfect command is : I tried other command mentioned above ..doesn't work anymore.
[status,sheets] = xlsfinfo(filename)
filename should be written within ' ' (single apostrophe)

Community Treasure Hunt

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

Start Hunting!

Translated by