B4J Tutorial [XLUtils] Hyperlinks and Outlining / Grouping

XLUtils v1.03 adds support for grouping rows and columns and for adding links.


Grouping is done with XLSheetWriter.GroupRows / Columns.
By default the expand button is positioned at the bottom.
You can move it to the top using a template. Choose Data - Outline settings and uncheck "summary rows below detail":


Adding links is done with XLSheetWriter.CreateHyperlink:
Dim LinkStyle As XLStyle = workbook.CreateStyle.FontLink(11).HorizontalAlignment("CENTER")
Sheet.PutString(xl.AddressName("A1"), "Data source - https://ourworldindata.org")
Sheet.CreateHyperlink(Sheet.LastAccessed, "URL", "https://ourworldindata.org/coronavirus-source-data")

There are four types of links:
URL - web link
DOCUMENT - location in the workbook - Country!A13
EMAIL - mailto:[email protected]?subject=Hyperlinks
FILE - path to file

Example project is attached. The data file is excluded due to its size. Download it: https://covid.ourworldindata.org/data/owid-covid-data.csv and put it in the Files folder.


  • CovidDataOutlining.zip
    9.9 KB · Views: 228
Last edited:


B4X founder
Staff member
Licensed User
Longtime User