xlsfinfo not working but xlsread and xlswrite are working

Hello, xlsfinfo is not working. Looks like this is a persistent issue. I searched on Google and many users have the same problem. But I did not see a solution. The description field returned from xlsfinfo is empty. Here is my session. I have also attached the 2 files referred to below. Please help.

>> [a,descr,fmt]=xlsfinfo('trial.xlsm')

a =

Microsoft Excel Spreadsheet

descr = 

     Empty cell array: 1-by-0

fmt =

xlOpenXMLWorkbookMacroEnabled

>> [a,descr,fmt]=xlsfinfo('trial.xls')

a =

Microsoft Excel Spreadsheet

descr = 

     Empty cell array: 1-by-0

fmt =

xlExcel8

[Muneer Shaik]

Hello Sanjay

Did you get an answer for your question...

Dear Mathworks Can someone respond to sanjay's question as Iam also facing the similar problem..

[Walter Roberson]

Which operating system is involved? If it is MS Windows, then which version of Excel is installed?

The list of sheets shows up fine for me in R2014a for OS-X (which does not talk to Excel to get the information, using internal code instead; that could be important if Excel is the culprit)

[Aniruddh Murali]

Hello, I am facing a similar issue with xlsfinfo, using matlab 2016 a, on Ubuntu. I am able to use read and write function with xls, but xlsfinfo is giving null.

[Jan]

@Aniruddh Murali: Please explain, what "xlsfinfo is giving null" exactly means. The readers cannot guess the details you observe. "Null" what?

[Aniruddh Murali]

So When I Tried checking data from the excel worksheet Run1.xlsx it showed this error. I need to know the number of sheets this excel has. If there is an easier way please let me know.

>> status = xlsfinfo('Run1.xlsx');
>> status

status =

       ''

[Jan]

@Aniruddh Murali: "Showed this error"? Which error?

The documentation of xlsfinfo explains:

If filename is not a file that xlsread can read, then status is empty, ''

Can you open the file with Excel on your computer?

[Image Analyst]

Aniruddh, please attach your 'Run1.xlsx'.