Category Archives: XL Plugin

XL Plugin version 3.0 released

Posted on by

Today we are announcing the release of XL Plugin version 3.0. The latest version offers a ton of new features, making it the most advanced 4D plugin for reading and writing Microsoft Excel files.

XL Plugin 3.0 introduces over 120 new features, making it one of the most comprehensive updates to date. The release focuses on improving performance, expanding compatibility, and providing developers with greater control over Excel document manipulation.

Key new features include:

  • Support for loading password-protected (encrypted) Excel documents
  • Ability to get and set core document properties
  • Support for conditional formatting
  • Reading and writing Excel tables
  • Working with form controls
  • Options for getting and setting default column and row formats
  • Improved support for working with merged cells
  • Finding the first and last filled row and column numbers.
  • Reading print settings of a sheet like print area and print repeated rows/columns
  • Ability to get and set the tab color of a sheet
  • Easily add borders around a range of cells
  • Diagonal border styles
  • Support for getting and setting the active cell or selected range
  • Functionality to get and set default row height
  • Improved support for 4D v20 and v21

In addition to these technical enhancements, the demo database has been extensively updated with many new examples, helping users quickly explore and implement the plugin’s capabilities.

More details can be found in the section Version history of the documentation.

More information on XL Plugin

XL Plugin version 2.1.0 released

Posted on by

XL Plugin has been updated to version 2.1. This maintenance release includes a few bug fixes and minor improvements.

  • Updated LibXL to version 4.3.0 which includes many bug fixes.

For details see the section Version history of the documentation.

More information on XL Plugin

XL Plugin version 2.0 released

Posted on by

XL Plugin has been updated to version 2.0.6. This version includes many new features:

  • Added support for pre-emptive multi-threading.
  • Added support for Apple Silicon (M1) based Macs.
  • Added new commands xlSheetRangeToCollection and xlSheetCollectionToRange.
  • Added new commands xlBookGetSheetName, xlBookMoveSheet.
  • Added support for Excel templates, see xlBookGetTemplate, xlBookSetTemplate.
  • Added support for built-in Excel cell styles, see xlBookAddFormat.
  • Added new command xlBookGetVersion.
  • Added new command xlSheetSetRangeFormat for setting the format for a range of cells.
  • Added support for working with column width and row height in pixels, see xlSheetSetColumnWidth, xlSheetGetColumnWidth, xlSheetSetRowHeight and xlSheetGetRowHeight.
  • Added support for picture links, see xlBookAddPictureAsLink.
  • Added offset parameter to xlSheetGetPicture and xlSheetSetPicture.
  • Added support for data validation, see xlSheetAddDataValidation, xlSheetRemoveDataValidation and xlSheetAddIgnoredError.
  • Added xlSheetRemoveCellComment.
  • Added xlSheetIsDate to easily test if a cell contains a date value.
  • Added support for hyperlinks, see xlSheetHyperlinkCount, xlSheetGetHyperlink, xlSheetSetHyperlink and xlSheetRemoveHyperlink.
  • Added xlSheetSetAutoFitArea, xlSheetGetSplit, xlSheetSetTabColor.
  • Added support for auto filters, see xlSheetGetAutoFilter, xlSheetApplyAutoFilter, xlSheetRemoveAutoFilter, xlAutoFilterGetRange, xlAutoFilterSetRange, xlAutoFilterCountColumns, xlAutoFilterGetColumnByIndex, xlAutoFilterGetSortRange, xlAutoFilterGetSort, xlAutoFilterSetSort, xlAutoFilterAddSort, xlFilterColumnGetIndex, xlFilterColumnGetType, xlFilterColumnCount, xlFilterColumnGetFilter, xlFilterColumnAddFilter, xlFilterColumnGetTop10, xlFilterColumnSetTop10, xlFilterColumnGetCustomFilter, xlFilterColumnSetCustomFilter, xlFilterColumnClear.
  • Added new command xlSheetGetTables.

For details see the section Version history of the documentation.

More information on XL Plugin