Skip to content
HOW TO

Publish an Interactive Web Report

Goal

Publish an Excel range with HTML and web controls for a web-facing report.

Prerequisites

  • A worksheet range designed as the report layout.
  • Runline web-report support enabled for the target environment.
  • A defined set of accepted control values and validation rules.

Steps

1. Design the workbook range as the canonical report layout.

2. Compose HTML and control metadata in visible cells.

=U.INCLUDE_HTML()

=U.WEB_CONTROL.DROPDOWN(B6,B7:B12)

3. Pass the combined metadata to U.PUBLISH.

4. Parse returned control values with U.PARSE_WEB_CONTROL_VALS before using them in workbook logic.

Result

The published report includes HTML and control metadata, and returned control values can drive validated workbook logic.

Common Variations

  • Publish HTML without interactive controls.
  • Combine button, dropdown, checkbox, date, hyperlink, or text-area controls.
  • Apply U.WEB_STYLE metadata separately from control definitions.

Troubleshooting

  • If raw data publishes without HTML, inspect U.INCLUDE_HTML metadata and its throttle.
  • If controls render but do not affect Excel, inspect the parsing and trigger cells for returned values.
  • Treat returned control values as untrusted input before actions or republication.