Excel File Connector

MCWLibXL is an Omnis Studio external object that wraps the LibXL library, providing a straightforward interface for reading and writing Excel files (.xls and .xlsx) directly from Omnis applications.

!Requirement for a one time purchase perpetual licence (LibXL!) https://www.libxl.com/home.html

MCWLibXL

MCWLibXL is an Omnis Studio external object that wraps the LibXL library, providing a straightforward interface for reading and writing Excel files (.xls and .xlsx) directly from Omnis applications.

Original Project
https://github.com/javlacerda/mcwlibxl

Features

• Create and save Excel workbooks in XLS and XLSX formats
• Read existing Excel files
• Read and write strings, numbers, booleans, dates, times, and date/times
• Write formulas to cells
• Manage multiple sheets (add, select by name or index, list all)
• Insert rows and columns
• Full cell formatting support: fonts, colours, alignment, borders, fill patterns
• Control gridlines display and text rotation
• Navigate data ranges (first/last row and column)