Custom titles for Excel tabs

I suggest to implement the following feature:

The ability to give custom names to tabs when exporting reports to Excel.

A typical use case might be:

When creating a report with multiple tables, the ability to be able to give each tab a meaningful name would be extremely useful. With named tabs, the user can clearly see where each table is situated and can go direct to the information that is important for them.

There’s one option in place for adapting the name (albeit not that flexible):

XLS.WorksheetName: Configures the name of the worksheet(s). You can use the
format identifier “%d” in the name. It will be replaced by the page number at runtime
(ex. “Report page %d”).

We have a multi-table report which exports on to several tabs, ie Stock, Sales, Invoices, Estimates etc., the tabs need to be named something meaningful, not just Sheet 1, Sheet 2 etc. I was expecting the table name to be used for the name of the tab or have an option when you force page break to enter a new name for that page/tab.

1 Like

This feature is on the backlog for LL27. Implementation will most likely be via an alternative, different place holder syntax like

LL.ExportOptions.Add(LlExportOption.XlsWorksheetName, "{ItemName} on Page {PageNumber}");