IMPORTRANGE
Imports a range from another deepcalc workbook, addressed as {namespace}/{name}: e.g. worldbank/gdp. Resolution is journaled, never live-silent: refreshing the workbook's Sources materializes the target values as ordinary ops, so every upstream change arrives as a reviewable diff. Each source can track the latest version or be pinned to a specific one (the Sources panel). Before the first refresh the cell shows #NAME?. The inline form ={ns}/{name}!worksheet!A1:B10 is equivalent.
- Excel: No equivalent
- Google Sheets: Not checked yet
- Returns: Array
Resolved at the workbook layer, not by the engine: values arrive when the
workbook's Sources are refreshed (journaled, reviewable, pin or track per
source); before the first refresh the cell shows #NAME?.
Examples
Live results: the values below were fetched from the public worldbank mirrors when this page rendered; a refresh materializes exactly these values into your workbook.
=IMPORTRANGE("worldbank/gdp", "data!A1:E3") | A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | country_code | country | year | value | is_aggregate |
| 2 | ABW | Aruba | 1986 | 405586592.178771 | false |
| 3 | ABW | Aruba | 1987 | 487709497.206704 | false |
=IMPORTRANGE("worldbank/gdp", "data!D2")/IMPORTRANGE("worldbank/population", "data!D2") Syntax
IMPORTRANGE(workbook, range_string)workbook- text required
range_string- text required