capabilities.work

Write Through a Named Range

A 4-step recipe with Microsoft Excel. We can help you get access.

Recipe · 4 steps

Write Through a Named Range

with Microsoft Excel

Write into a workbook range addressed by its defined name rather than a fixed coordinate.

  1. Open a persisting session so values written through the named range are saved.
  2. List the workbook's named items. Each carries the formula or range reference it points at, which is what the caller checks the target address against before writing anything.
  3. Read the range the name resolves to, capturing its current values and dimensions so the caller can confirm the payload matches the shape.
  4. Write the values through the resolved address. Because the address came from the named item, the integration keeps working when the owner moves the data and updates the name.
What you'll need to have ready
  • itemId: The drive item id of the workbook file.
  • worksheetIdOrName: The worksheet the named range lives on.
  • address: The A1-notation address the named item resolves to on that worksheet, confirmed against the named item list this flow reads (e.g. "A1:D3").
  • values: A two-dimensional array of values shaped to the named range.
For your developer

Arazzo workflow microsoft-excel:named-range-write, 4 operations: createWorkbookSession → listNamedItems → getRange → updateRange. Specs on APIs.io.

More recipes with Microsoft Excel

Append a Row to a TableBuild a Chart from a Data RangeFlatten a Table into a Plain RangeCreate a Worksheet and Seed It with DataDiscover Workbook StructureSort, Filter, and Total a Table for ReportingDelete a Table Row by IndexRead, Write, and Verify a Cell RangeAdd and Retire a Table ColumnCalculate with a Workbook Function and Write the Result