Readtable cannnot read xlsb file
10 views (last 30 days)
Show older comments
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
4 Comments
dpb
on 5 Aug 2018
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! :)
Answers (1)
Alex B
on 12 Sep 2018
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".
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!