Skip to content
EXAMPLE

Interactive Web Report

Summary

Publish a workbook-designed payment calculator whose values can be edited from a browser and reflected back into Excel.

Files Used in This Example

Prerequisites

  • UWeb deployed for the target environment.
  • Publish, view, and interact permissions for the report group.
  • A new or disposable Excel instance if preserving Undo history is critical, because HTML generation can clear it in some environments.

Step 1: Mark the report as interactive HTML

Build the publish metadata in visible cells.

=U.HAS_WEB_CONTROLS(TRUE)

=U.ALLOW_PUBLISH(TRUE)

=U.INCLUDE_HTML()

Step 2: Name the published page

Apply a user-facing page name through metadata.

=U.PAGE_NAMES("Payment Calculator")

Step 3: Define controls and their locations

Keep the control list separate from the report range and point each control to its workbook cell.

=U.WEB_CONTROL_LOCATION($B$20:$C$28,C25)

=U.WEB_CONTROL.DROPDOWN("1,2,4,6,12,24",C25,,E25)

Step 4: Publish and receive changes

Use the two-way report workflow so Excel changes reach the browser and validated browser changes return to the intended input cells.

=U.TWO_WAY_DATA(C11,C12,B20:C28,B15:C18,F21:F26)

Result

The report renders as HTML with interactive controls; changes can flow between the browser and the designated worksheet inputs without replacing calculated output cells.

What’s Happening

What’s happening here?

The report range, metadata range, and control-indicator range have separate responsibilities. Location indicators let UWeb map controls to cells even though control formulas are stored outside the published layout.