Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 19 in printed book and digital formats -- plus a one-year subscription (beginning with 20.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 20.5 ('Xojo Workflows')
Instant purchase and download via GumRoad!

COLUMN

Create and Read Excel Spreadsheets

Using LibXL with Xojo

Issue: 20.5 (September/October 2022)
Author: Stefanie Juchmes
Author Bio: Stefanie studied computer science at the university in Bonn. She came in touch with Xojo due to the work of her brother-in-law and got a junior developer position in early 2019 at Monkeybread Software.
Article Description: No description available.
Article Length (in bytes): 9,074
Starting Page Number: 72
Article Number: 20509
Related Link(s): None

Excerpt of article text...

Did you know that with the MBS Xojo plugins and a LibXL license you can read and create Microsoft Excel documents without having Excel installed on your computer? I will show you a small example in this article (see Figure 1).

Initialize LibXL

If you want to use LibXL, you have to initialize it first. For this we use the method SetKeyGlobal from the class XLBookMBS. In the parameters of this method you specify your name and the appropriate license key for the suitable OS version.

XLBookMBS.SetKeyGlobal "your name", "Operating system matching key"

...End of Excerpt. Please purchase the magazine to read the full article.