Beyond Excel's (BXL's) Function:

Get Name Value

Name: fncGetNameValue()

Use:

Get parameters from Excel for queries.

Description:

This returns a named range or named formula's value.

Parameters

This function has one parameter: NamedObject. NamedObject is Excel's name for a named range or named formula.

Example:

let

RowCount = fncGetNameValue("Periods"),

DynTbl = fncCrtTblRows(RowCount, "Prd")

in

DynTbl

Code:

/* Name: fncGetNameValue

Description:Get a named range or named formula's value

Requisites: Name must exist in current workbook

Inputs: NameObject: Named range or named formula in Excel

Outputs: NameVal: Named range or formula's value

Date Ini Description

04/04/18 CWH Original Development

*/

(NameObject as text) =>

let

WrkBook = Excel.CurrentWorkbook(), /* Get list of names, sheets & tables from Workbook */

NameObj = WrkBook{[Name=NameObject]}, /* Select named object matching NameObject parameter */

NameCnt = NameObj[Content], /* Get named object's contents as a table */

NameVal = NameCnt{0}[Column1] /* Convert table's first cell to a value */

in

NameVal