Skip to content
HOW TO

Publish Data from Excel

Goal

Publish a value or range from Excel to a named Runline report.

Prerequisites

  • Runline U connected to the target environment.
  • A report group and report name that consumers will use.
  • A non-empty source range containing at least one non-error value.

Steps

1. Put report group and report name in worksheet cells so publishers and subscribers can reuse the same identifiers.

=U.PUBLISH($B$2,$B$3,A6:D25,,FALSE,)

2. Add metadata only when the scenario needs it, such as HTML output, page names, precision control, or report secrets.

3. Confirm the return value changes after recalculation and validate the same topic with U.TOPIC or a subscriber workbook.

Result

The source range is available as a named Runline report, and the publish cell shows the time of the latest publish attempt or a status/error message.

Common Variations

  • Publish multiple pages by passing multiple range references as the report data.
  • Compose metadata with helpers such as U.PAGE_NAMES, U.INCLUDE_HTML, or U.PUB_SECRET.
  • Use the supported block value to require an intentional trigger or to throttle publishes.

Troubleshooting

  • If the result says the publish was blocked or skipped, inspect metadata and the block input before changing the topic.
  • If subscribers see nothing, compare the full topic and environment on both sides.
  • If the source array is empty or all errors, correct the range before retrying.