XLSX Lib – A Bonus Library Included with Excel Library in the MegaBundle Offer

I recently finished the last touches on a new solution around spreadsheets.

Excel Library is already capable of great things with Excel such as creating new workbooks, worksheets, charts or defining a complex pivot table directly from LiveCode. The drawback is, it requires MS Excel on the device to work.

Not any more!

This is where the XLSX Lib comes in. It creates new xlsx files from scratch, which can be opened and used by MS Excel, Open Office, Google Sheets and even Numbers as well. If it can open xlsx files, it will be able to handle the files generated by XLSX Lib.

It is also capable of importing data and styles from existing xlsx files. Are you excited yet?

What can it do?

With less features than in its big brother Excel Library (no Charts or Pivot table available), it  can nevertheless be a grand help.

• You need to create a workbook with a large amount of rows? The XLSX Lib is here!
• Need to give it a looking professional style? XLSX Lib can do it.
• Want formulae? XLSX Lib!
• Freeze Pane? Yes!
• Auto filter? Of course!
• Customizable number format? Yes we can!
• Feed the dog? Not right away, but maybe, we’re working on it, who knows?

Are there Docs?

Certainly there are docs. Better than just documentation, this addon library even comes with functional examples from which you can copy the code.

How to get it? 

The XLSX Library is a free addon for Excel Library, and included in the current Summer Megabundle.