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.

 

[Erel]

Example updated. XLStyle.LinkFont methods was renamed to XLStyle.FontLink in XLUtils v1.04+.

 

[MarrowZero]

@Erel is it possible for this example to be extended to show how to read the Hyperlink value ?

 

[Erel]

XLUtils / jPOI 5 - Read and write MS Excel workbooks

As written here, I plan to make it easier to read and write Excel workbooks. The solution is based on three components: - Apache POI - https://poi.apache.org/ Large open source project that provides APIs for Microsoft documents. Note that the files are accessed directly, it doesn't depend on the...

www.b4x.com