How to use PHP to convert xlsb to a more readable format like xlsx or csv etc. or read under Linux?

Question:

Googling and did not find a solution to the issue, mostly solutions are offered to use the easyXLS library, but as I understand it, it works through COM and therefore is not suitable for Linux hosting. I found a crutch solution in the form of a python library to run this script from PHP, but it returns some kind of garbage in which the last word of the last cell in each line is normally displayed

The XLSB extension is a binary format spreadsheet file created in Microsoft Excel. XLSB files differ from standard Open XML files (.XLSX) in that they store a table using binary format (BIFF12).

Answer:

There are at least two projects on github . True in python . But who's stopping you from calling them from php via exec ? 🙂

https://github.com/galizin/xlsb2csv

https://github.com/orangethakkali/xlsb2csv

Scroll to Top
AllEscort