CODEWITHSUNDEEP
excelmatlab
2one
2one

Reputation: 1085

matlab: Issue reading excel binary (.xlsb) file

I am trying to read in (MATLAB 7.14.0.739 (R2012a), Ubuntu 12.04, filesize ~2MB) a binary excel file containing multiple sheets but get the following error:

[status,sheets,xlFormat] = xlsfinfo('633933_2014-07-04_11-34-27.xlsb')

status =

 ''

sheets =

Unreadable Excel file: File contains unexpected record length. Try saving as Excel 98.

xlFormat =

 ''

I have a large number of these binary files so I don't want to have to resave them to another format if possible.

Upvotes: 0

Views: 686

Answers (1)

Daniel
Daniel

Reputation: 36710

The documentation clearly states that the support for xlsb is limited to windows systems having excel installed.

You may try to find some 3rd party so, python or java library which can read xlsb but I am not aware of any. Otherwise you have to switch to a different format.

Upvotes: 1

Related Questions