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.

score 4 · Accepted Answer · answered Jan 20 '19 at 10:07

4

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

answered Jan 20 '19 at 10:07

Artee

824
9
19

Thank you very much, your solution is very good and I will consider it for other projects, but in this case it does not allow me to work with large files. – Juan Antonio Roldán Díaz Jan 22 '19 at 14:49
~30 Mb, 15 columns and 140.000 rows, but I am trying with 50.000 rows and it does not work either. However, with small files it works very well. – Juan Antonio Roldán Díaz Jan 22 '19 at 15:05

AndreasKralj · Answer 2 · 2019-01-18T21:47:43.600

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.

You can use EasyXLS with Java and Python. It does not work with C++ in Linux. — alex.pulver, Jan 21 '19 at 06:39
Thank you very much, EasyXLS + Java look nice but I need to find a free solution. — Juan Antonio Roldán Díaz, Jan 22 '19 at 14:52

score 2 · Answer 3 · answered Jan 23 '19 at 15:48

You may want to look at this: How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office? You could just use the library through Mono and, depending on what you are doing, you could write some kind of shell utility or possibly link your program to Mono and make some type of wrappers. It really seems that, for this particular application, something in .NET is probably where you will find the most complete solution, and then it should work through Mono on linux.

Create an *.xlsb in linux

3 Answers3