ArrayReference()

ArrayReference(ExcelCell cell) 
defines a reference to a Wolfram API result.

Details

  • The ArrayReference function is designed to be used in an Excel spreadsheet.
  • ArrayReference takes an ExcelCell, which can be the top-left cell of any Wolfram API function.
  • The ArrayReference function only works with Wolfram API functions.

Examples

Basic Examples  (1)

  • A Wolfram API that contains two Parameter values, one of which references an Excel cell:
  • =WolframAPI("/Documentation/Example/GridOfData", Parameter("nrows", "A1"),Parameter("ncols", "1"))
  • A Wolfram API that contains a Parameter of ArrayReference, referencing the top-left cell of the preceding API:
  • =WolframAPI("/Documentation/Example/PlotNumbers", Parameter("x", ArrayReference("B1")))
    Wolfram Research (2018), ArrayReference(), Wolfram Language function, https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html.

    Text

    Wolfram Research (2018), ArrayReference(), Wolfram Language function, https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html.

    BibTeX

    @misc{reference.wolfram_2021_arrayreference(), author="Wolfram Research", title="{ArrayReference()}", year="2018", howpublished="\url{https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html}", note=[Accessed: 23-October-2021 ]}

    BibLaTeX

    @online{reference.wolfram_2021_arrayreference(), organization={Wolfram Research}, title={ArrayReference()}, year={2018}, url={https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html}, note=[Accessed: 23-October-2021 ]}

    CMS

    Wolfram Language. 2018. "ArrayReference()." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html.

    APA

    Wolfram Language. (2018). ArrayReference(). Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/CloudConnectorForExcel/ref/excelfunction/Parameter.html