Ask Your Question

Why no save as xlsb? [closed]

asked 2012-10-12 23:03:23 +0200

DGPickett gravatar image

updated 2020-08-02 17:24:13 +0200

Alex Kemp gravatar image

Spreadsheets can be read from xlsb, but not rewritten. If we know how to read one, we should know how to write one.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:57:00.499236


For reference, an XLSB file is apparently an "Excel Binary Workbook File" and supports the same feature set as XLSX, but the binary-encoded file can be saved/opened much more quickly. more here

qubit gravatar imagequbit ( 2012-12-23 14:04:09 +0200 )edit

not quite. It's lots of hacking, as there is no open documentation. You may have known an epopee with NTFS support in Linux. In short: they learned to read it quite long ago, but writing corrupted filesystem till NTFS-3G in ~2007. Same with xlsb: they can write it, but they must write it so Excel would read it back, which is way harder and requires lots of trial and error.

LogicDaemon gravatar imageLogicDaemon ( 2015-01-16 23:23:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-12-23 14:08:49 +0200

qubit gravatar image

updated 2012-12-23 14:09:50 +0200

Feel free to submit a feature request for XLSB export. Is there a specific task in which you need this export functionality?

As XLSX and XLSB both seem to support the same featureset, would it be possible for you to save changes in the XLSX format?

edit flag offensive delete link more

Question Tools


Asked: 2012-10-12 23:03:23 +0200

Seen: 1,521 times

Last updated: Dec 23 '12