diff options
| author | montezdesousa <79287829+montezdesousa@users.noreply.github.com> | 2024-02-28 22:09:11 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-02-28 22:09:11 +0000 |
| commit | b60d90875fb3ea71006ed3129bb4a4278c2fdac6 (patch) | |
| tree | 63e0d0857e8f341bd15e032c9e09b119a74fe49d | |
| parent | 830acd99a42d100e1fabee1e95a4b3cb060c7182 (diff) | |
Docs/update xl docs (#6145)
* remove print
* update obb.get docs
* example
* md lint
| -rw-r--r-- | website/content/excel/data-slicer.md | 4 | ||||
| -rw-r--r-- | website/content/excel/functions.json | 8 | ||||
| -rw-r--r-- | website/generate_excel_markdown.py | 3 |
3 files changed, 8 insertions, 7 deletions
diff --git a/website/content/excel/data-slicer.md b/website/content/excel/data-slicer.md index a1cc27ba7fd..564d890dcaa 100644 --- a/website/content/excel/data-slicer.md +++ b/website/content/excel/data-slicer.md @@ -50,6 +50,10 @@ When passing date labels make sure to use the format `YYYY/MM/DD` or refer to a =OBB.GET(A1:D3,2,3) ``` +:::tip +To slice the from the last row use negative numbers. For example, `=OBB.GET(A1:D3,-1,-2)` will return the last row and the second to last column. +::: + - Slicing multiple rows and columns: ```excel diff --git a/website/content/excel/functions.json b/website/content/excel/functions.json index 57fdf5336bd..e4f8c0506ab 100644 --- a/website/content/excel/functions.json +++ b/website/content/excel/functions.json @@ -7,22 +7,22 @@ "name": "GET", "parameters": [ { - "description": "Data to slice.", + "description": "Array to slice.", "dimensionality": "matrix", - "name": "data", + "name": "array", "type": "any" }, { "description": "Range of row labels or indices.", "dimensionality": "matrix", - "name": "row", + "name": "rows", "optional": true, "type": "any" }, { "description": "Range of column labels or indices.", "dimensionality": "matrix", - "name": "column", + "name": "columns", "optional": true, "type": "any" } diff --git a/website/generate_excel_markdown.py b/website/generate_excel_markdown.py index 25fef26d726..9a99cf55a76 100644 --- a/website/generate_excel_markdown.py +++ b/website/generate_excel_markdown.py @@ -269,9 +269,6 @@ class CommandLib: sig = signature_.split("(")[0] + "(" category = signature_.split(".")[1].lower() - if cmd == "/economy/fred_regional": - print(cmd) - def get_p_value(cmd, p_name) -> str: if cmd in self.EXAMPLE_PARAMS: return self.EXAMPLE_PARAMS[cmd].get(p_name, "") |