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

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

Answer 1

[owr]

"xlsfinfo" will get you a list of sheet names.

[Ajay Pherwani]

hey Thanks !!

[Remy Lassalle-Balier]

It seems it is now changed to sheetnames.

Answer 2

[Pruthvi G]

Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file

%%********************************************************************************
%   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'}

[Joy Tonto]

Thanks for the file

[wenchao zhang]

[STATUS,SHEETS,FORMAT] = xlsfinfo('D:\MatlabWorkSpace\read_the_Sheet_name\data.xlsx');

[Walter Roberson]

Or, as @Remy Lassalle-Balier pointed out, these days sheetnames is recommended.

Answer 3

[Kaiser Ahmed Bhuiyan]

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)

[Ishaq Basha]

Thanks Kaiser