Readtable cannnot read xlsb file

The command Data=readtable('Filename.xlsb') throws back an error message "Error using readtable (line 197) The 'XLSB' format is not supported with this plugin." Can anyone help with this? I have restarted everything and even reinstalled Matlab. No luck.

I presume the problem may be with an excel plugin. I have Excel 2010 with the following standard plugins: Analysis Toolpak, Analysis Toolpak-VBA, Custom XML Data, Euro Currency Tools,Headers and Footers, Hidden Rows and Columns, Hidden Worksheets, Invisible Content, Microsoft Actions Pane 3, Solver Add-in. No COM Add-ins.

Any help will be appreciated. Thanks

[Walter Roberson]

Note that .xlsm and .ods files would not be supported on Linux or Mac, or on Windows if it is not able to find Excel. (But from your Excel version number we can tell you are on Windows.)

[dpb]

What happens if you try

 [n,t,raw]=xlsread('Filename.xlsb');

???

Which release of ML are you using?

Seems to work with the combination of Excel 2016/ML R2016b; perhaps there an earlier release issue.

You might make a small sample WB that has the problem and attach it and see if there's something about the file itself or at least see what releases/combinations do work.

[AK]

Thanks Walter Roberson and dpb. Followed suggestion to make a test file and worked it out from there. Eventually re-saved original files with different names (still .xlsb). New files are read by readtable. Suppose there was a problem with the original xlsb file which I still can't identify but at least I can move forward now. Appreciate the responses. Thank you.

[dpb]

Thanks for letting us know the result...Excel gets "lost" quite often it seems with newer releases--ime at least Office 2016 is very buggy besides being a major step back in user interface...thank goodness there's still something like ML for sanity! :)

Answer 1

[Alex B]

I get this error when I set the wrong directory, matlab version R2017B. After correcting the path to the file it does read the file. So instead of showing "The 'XLSB' format is not supported with this plugin." it should say "file could not be found".