Create an *.xlsb in linux

Question

Does anyone know how to create or export data to an xlsb file (Binary File Format) in a Linux OS from any programming language?

My idea is to execute it from R, but any suggestion in Python, Perl or some other language is very appreciated.

Answer 1

You can use the JavaScript library SheetJS. It supports export to Excel 2007+ binary Format.

Answer 2

It looks like there's a way to do it using C++. You might look at the EasyXLS library, there's a free trial but it appears to be $295 for a license, so if it's a personal project it might not be ideal. If it's a project for work, though, you might try it out, because it seems that the library is very easy to use (go figure from the name, I guess), and you can set rows, columns, and even different tabs in the Excel sheet. The link above shows an example of how to use it, I hope this helps.

Edit: C++ appears to be the only language that has a library for this that is compatible with Linux. I found this one here that only works with Windows, and this method only works with VBA, which you could use by running it with Wine, but the first method seems to be the only one that can run natively on Linux without issue.