Wiresk

Wiresk

Excel – Table Range & Ranges

Estimated reading time: 39 min

What your automation will do…

excel logo Background Removed Excel - Table Range & Ranges

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Table Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/range()",
  "address": "'Sheet test'!A15:D17",
  "addressLocal": "'Sheet test'!A15:D17",
  "columnCount": 4,
  "cellCount": 12,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Column1": "General",
      "Column2": "General",
      "Column3": "General",
      "Column4": "0%"
    },
    {
      "Column1": "General",
      "Column2": "General",
      "Column3": "General",
      "Column4": "0%"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulas": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulasLocal": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulasR1C1": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "hidden": false,
  "rowCount": 3,
  "rowIndex": 14,
  "valueTypes": [
    {
      "Column1": "String",
      "Column2": "String",
      "Column3": "String",
      "Column4": "String"
    },
    {
      "Column1": "String",
      "Column2": "String",
      "Column3": "String",
      "Column4": "String"
    }
  ],
  "values": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Row Header Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/headerRowRange()",
  "address": "'Sheet test'!A15:D15",
  "addressLocal": "'Sheet test'!A15:D15",
  "columnCount": 4,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    [
      "General",
      "General",
      "General",
      "0%"
    ]
  ],
  "columnIndex": 0,
  "text": [
    [
      "Column1",
      "Column2",
      "Column3",
      "Column4"
    ]
  ],
  "formulas": [
    [
      "Column1",
      "Column2",
      "Column3",
      "Column4"
    ]
  ],
  "formulasLocal": [
    [
      "Column1",
      "Column2",
      "Column3",
      "Column4"
    ]
  ],
  "formulasR1C1": [
    [
      "Column1",
      "Column2",
      "Column3",
      "Column4"
    ]
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 14,
  "valueTypes": [
    [
      "String",
      "String",
      "String",
      "String"
    ]
  ],
  "values": [
    [
      "Column1",
      "Column2",
      "Column3",
      "Column4"
    ]
  ]
}

Get Table Body Range Copy Link

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Table Body Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/dataBodyRange()",
  "address": "'Sheet test'!A16:D17",
  "addressLocal": "'Sheet test'!A16:D17",
  "columnCount": 4,
  "cellCount": 8,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Column1": "General",
      "Column2": "General",
      "Column3": "General",
      "Column4": "0%"
    },
    {
      "Column1": "General",
      "Column2": "General",
      "Column3": "General",
      "Column4": "0%"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulas": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulasLocal": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "formulasR1C1": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ],
  "hidden": false,
  "rowCount": 2,
  "rowIndex": 15,
  "valueTypes": [
    {
      "Column1": "String",
      "Column2": "String",
      "Column3": "String",
      "Column4": "String"
    },
    {
      "Column1": "String",
      "Column2": "String",
      "Column3": "String",
      "Column4": "String"
    }
  ],
  "values": [
    {
      "Column1": "test1",
      "Column2": "test2",
      "Column3": "test3",
      "Column4": "test4"
    },
    {
      "Column1": "test1-2",
      "Column2": "test2-2",
      "Column3": "test3-2",
      "Column4": "test4-2"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Total Row Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/totalRowRange()",
  "address": "'Sheet test'!A18:D18",
  "addressLocal": "'Sheet test'!A18:D18",
  "columnCount": 4,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Column1": "General",
      "Column2": "General",
      "Column3": "General",
      "Column4": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "Column1": "Total",
      "Column2": "",
      "Column3": "",
      "Column4": "2"
    }
  ],
  "formulas": [
    {
      "Column1": "Total",
      "Column2": "",
      "Column3": "",
      "Column4": "=SUBTOTAL(103,[Column4])"
    }
  ],
  "formulasLocal": [
    {
      "Column1": "Total",
      "Column2": "",
      "Column3": "",
      "Column4": "=SUBTOTAL(103,[Column4])"
    }
  ],
  "formulasR1C1": [
    {
      "Column1": "Total",
      "Column2": "",
      "Column3": "",
      "Column4": "=SUBTOTAL(103,[Column4])"
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 17,
  "valueTypes": [
    {
      "Column1": "String",
      "Column2": "Empty",
      "Column3": "Empty",
      "Column4": "Double"
    }
  ],
  "values": [
    {
      "Column1": "Total",
      "Column2": "",
      "Column3": "",
      "Column4": 2
    }
  ]
}
excel logo Background Removed Excel - Table Range & Ranges

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Range in Workbook
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Start Range*

The top-left cell of the target range. Combined with the End Range, it defines the area to inspect.

Example: B1

End Range*

The bottom-right cell of the range.

Example: C13, The range B1:C13 represents the full area that Wiresk can inspect.

Header row*

Defines whether the range includes headers or where the header row starts.
Example: 1 (indicating that row 1 contains headers).

When headers are included, Wiresk labels the returned JSON keys using those header values.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27A1:b13%27)",
  "address": "'Sheet test'!A1:B13",
  "addressLocal": "'Sheet test'!A1:B13",
  "columnCount": 2,
  "cellCount": 26,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    },
    {
      "A": "General",
      "B": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "A": "Pheng huot",
      "B": "Month"
    },
    {
      "A": "",
      "B": "1"
    },
    {
      "A": "",
      "B": "2"
    },
    {
      "A": "",
      "B": "3"
    },
    {
      "A": "",
      "B": "4"
    },
    {
      "A": "",
      "B": "5"
    },
    {
      "A": "",
      "B": "6"
    },
    {
      "A": "",
      "B": "7"
    },
    {
      "A": "",
      "B": "8"
    },
    {
      "A": "",
      "B": "9"
    },
    {
      "A": "",
      "B": "10"
    },
    {
      "A": "",
      "B": "11"
    },
    {
      "A": "",
      "B": "12"
    }
  ],
  "formulas": [
    {
      "A": "Pheng huot",
      "B": "Month"
    },
    {
      "A": "",
      "B": 1
    },
    {
      "A": "",
      "B": 2
    },
    {
      "A": "",
      "B": 3
    },
    {
      "A": "",
      "B": 4
    },
    {
      "A": "",
      "B": 5
    },
    {
      "A": "",
      "B": 6
    },
    {
      "A": "",
      "B": 7
    },
    {
      "A": "",
      "B": 8
    },
    {
      "A": "",
      "B": 9
    },
    {
      "A": "",
      "B": 10
    },
    {
      "A": "",
      "B": 11
    },
    {
      "A": "",
      "B": 12
    }
  ],
  "formulasLocal": [
    {
      "A": "Pheng huot",
      "B": "Month"
    },
    {
      "A": "",
      "B": 1
    },
    {
      "A": "",
      "B": 2
    },
    {
      "A": "",
      "B": 3
    },
    {
      "A": "",
      "B": 4
    },
    {
      "A": "",
      "B": 5
    },
    {
      "A": "",
      "B": 6
    },
    {
      "A": "",
      "B": 7
    },
    {
      "A": "",
      "B": 8
    },
    {
      "A": "",
      "B": 9
    },
    {
      "A": "",
      "B": 10
    },
    {
      "A": "",
      "B": 11
    },
    {
      "A": "",
      "B": 12
    }
  ],
  "formulasR1C1": [
    {
      "A": "Pheng huot",
      "B": "Month"
    },
    {
      "A": "",
      "B": 1
    },
    {
      "A": "",
      "B": 2
    },
    {
      "A": "",
      "B": 3
    },
    {
      "A": "",
      "B": 4
    },
    {
      "A": "",
      "B": 5
    },
    {
      "A": "",
      "B": 6
    },
    {
      "A": "",
      "B": 7
    },
    {
      "A": "",
      "B": 8
    },
    {
      "A": "",
      "B": 9
    },
    {
      "A": "",
      "B": 10
    },
    {
      "A": "",
      "B": 11
    },
    {
      "A": "",
      "B": 12
    }
  ],
  "hidden": false,
  "rowCount": 13,
  "rowIndex": 0,
  "valueTypes": [
    {
      "A": "String",
      "B": "String"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    },
    {
      "A": "Empty",
      "B": "Double"
    }
  ],
  "values": [
    {
      "A": "Pheng huot",
      "B": "Month"
    },
    {
      "A": "",
      "B": 1
    },
    {
      "A": "",
      "B": 2
    },
    {
      "A": "",
      "B": 3
    },
    {
      "A": "",
      "B": 4
    },
    {
      "A": "",
      "B": 5
    },
    {
      "A": "",
      "B": 6
    },
    {
      "A": "",
      "B": 7
    },
    {
      "A": "",
      "B": 8
    },
    {
      "A": "",
      "B": 9
    },
    {
      "A": "",
      "B": 10
    },
    {
      "A": "",
      "B": 11
    },
    {
      "A": "",
      "B": 12
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Update Range in Workbook
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Start Range*

The first cell in the range you want to update (e.g., A1).
This marks the top-left corner of the update area.

End Range*

The last cell in the range (e.g., C5).
Combined with Start Range, it forms the rectangular block of cells to update.

Row Position*

Row Position
Indicates the row index within the defined range where the update starts.
Example: entering Row 2 means the update begins at the second row inside your Start–End range.

Header row*

Defines whether the range includes a header row.
If the range contains headers, Wiresk will treat that row as the key names for mapping JSON input values.
If not, select No header

Data*

The new cell values that will fill each column.
Each field corresponds to one column header in the table.

If a column value is left blank, the corresponding cell remains unchanged.

Example setup:

HeaderValue
Header0value1
Header1value2
Header2value3
Header3value4

You can use static text, mapped data from another app, or dynamic values retrieved from a Trigger or previous Method.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27A16:C16%27)",
  "address": "'Sheet test'!A16:C16",
  "addressLocal": "'Sheet test'!A16:C16",
  "columnCount": 3,
  "cellCount": 3,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Header0": "General",
      "Header1": "General",
      "Header2": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "Header0": "new value 1",
      "Header1": "new value 2",
      "Header2": "new value 3"
    }
  ],
  "formulas": [
    {
      "Header0": "new value 1",
      "Header1": "new value 2",
      "Header2": "new value 3"
    }
  ],
  "formulasLocal": [
    {
      "Header0": "new value 1",
      "Header1": "new value 2",
      "Header2": "new value 3"
    }
  ],
  "formulasR1C1": [
    {
      "Header0": "new value 1",
      "Header1": "new value 2",
      "Header2": "new value 3"
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 15,
  "valueTypes": [
    {
      "Header0": "String",
      "Header1": "String",
      "Header2": "String"
    }
  ],
  "values": [
    {
      "Header0": "new value 1",
      "Header1": "new value 2",
      "Header2": "new value 3"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Delete Cell
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Start Range*

The cell reference to delete, e.g. C29.
If used alone, deletes that single cell.

End Range

If provided, defines a rectangular range to delete (for example, C29:D30).
If omitted, only the Start Range cell is deleted.

Shift Direction*

Determines how the surrounding cells adjust after deletion:

  • Move cells up – shifts the cells below upward to fill the deleted range.
  • Move columns left – shifts the cells on the right to the left (default in Excel).

Shifting deletions can’t cross or align with a table’s rows/columns. Use table-specific deletes or clear values in those cases.

Sample response 
{
  "message": "Ranges deleted successfully."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Clear Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Start Range*

Defines the first cell of the range to clear, e.g. C29.
If used alone, clears that single cell.

End Range

If provided, clears all cells from Start Range through End Range inclusively, e.g. C29:E29.
If omitted, only the Start Range cell is cleared.

Apply to

Determines what to clear.

  • Clear values and formatting – removes both content and styles. Equivalent to applyTo: "All".
  • Clear formatting only – removes colors, borders, and text styles, keeping the values. Equivalent to applyTo: "Formats".
  • Clear values only – deletes text or numbers, keeping cell formatting. Equivalent to applyTo: "Contents".
Sample response 
{
  "message": "The selected cells have been cleared."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get BoundingRect
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Primary Start Range*

The first cell of the main range (e.g. A1).

Primary End Range*

Defines the end cell of the main range (e.g. C3).
Together with Primary Start Range, this creates the first rectangular block.

Secondary Start Range*

Start cell of the second range (e.g. E2).

Secondary End Range*

End cell of the second range (e.g. G5).
Together with Secondary Start Range, this defines the second block.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Csite-id%2Clibrary-id')/drive/items('file-id')/workbook/worksheets('{worksheet-guid}')/range(address='A1:B4')/boundingRect(anotherRange='C2:D6')",
  "address": "'Sheet1'!A1:D6",
  "addressLocal": "'Sheet1'!A1:D6",
  "columnCount": 4,
  "cellCount": 24,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "0%"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "A": "Employee Name",
      "B": "Month",
      "C": "Number of Merchants",
      "D": "% Tenant Commission"
    },
    {
      "A": "",
      "B": "1 update",
      "C": "200 update",
      "D": "10%"
    },
    {
      "A": "",
      "B": "2",
      "C": "200",
      "D": "10%"
    },
    {
      "A": "",
      "B": "3",
      "C": "200",
      "D": "10%"
    },
    {
      "A": "",
      "B": "4",
      "C": "200",
      "D": "10%"
    },
    {
      "A": "",
      "B": "5",
      "C": "200",
      "D": "10%"
    }
  ],
  "formulas": [
    {
      "A": "Employee Name",
      "B": "Month",
      "C": "Number of Merchants",
      "D": "% Tenant Commission"
    },
    {
      "A": "",
      "B": "1 update",
      "C": "200 update",
      "D": 0.1
    },
    {
      "A": "",
      "B": 2,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 3,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 4,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 5,
      "C": 200,
      "D": 0.1
    }
  ],
  "formulasLocal": [
    {
      "A": "Employee Name",
      "B": "Month",
      "C": "Number of Merchants",
      "D": "% Tenant Commission"
    },
    {
      "A": "",
      "B": "1 update",
      "C": "200 update",
      "D": 0.1
    },
    {
      "A": "",
      "B": 2,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 3,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 4,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 5,
      "C": 200,
      "D": 0.1
    }
  ],
  "formulasR1C1": [
    {
      "A": "Employee Name",
      "B": "Month",
      "C": "Number of Merchants",
      "D": "% Tenant Commission"
    },
    {
      "A": "",
      "B": "1 update",
      "C": "200 update",
      "D": 0.1
    },
    {
      "A": "",
      "B": 2,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 3,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 4,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 5,
      "C": 200,
      "D": 0.1
    }
  ],
  "hidden": false,
  "rowCount": 6,
  "rowIndex": 0,
  "valueTypes": [
    {
      "A": "String",
      "B": "String",
      "C": "String",
      "D": "String"
    },
    {
      "A": "Empty",
      "B": "String",
      "C": "String",
      "D": "Double"
    },
    {
      "A": "Empty",
      "B": "Double",
      "C": "Double",
      "D": "Double"
    },
    {
      "A": "Empty",
      "B": "Double",
      "C": "Double",
      "D": "Double"
    },
    {
      "A": "Empty",
      "B": "Double",
      "C": "Double",
      "D": "Double"
    },
    {
      "A": "Empty",
      "B": "Double",
      "C": "Double",
      "D": "Double"
    }
  ],
  "values": [
    {
      "A": "Employee Name",
      "B": "Month",
      "C": "Number of Merchants",
      "D": "% Tenant Commission"
    },
    {
      "A": "",
      "B": "1 update",
      "C": "200 update",
      "D": 0.1
    },
    {
      "A": "",
      "B": 2,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 3,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 4,
      "C": 200,
      "D": 0.1
    },
    {
      "A": "",
      "B": 5,
      "C": 200,
      "D": 0.1
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Cell
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Starting Cell*

Defines the reference cell (e.g. A1). This acts as the origin when specifying relative positions.

Row*

Numeric row index, starting at 0 (e.g. 2 for the third row). Determines which row to retrieve from.

Column*

Numeric column index, starting at 0 (e.g. 1 for column B). Together with Row, this defines the exact cell location.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27A1%27)/cell(row=28,column=2)",
  "address": "'Sheet test'!C29",
  "addressLocal": "'Sheet test'!C29",
  "columnCount": 1,
  "cellCount": 1,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": {
    "C": "General"
  },
  "columnIndex": 2,
  "text": {
    "C": ""
  },
  "formulas": {
    "C": ""
  },
  "formulasLocal": {
    "C": ""
  },
  "formulasR1C1": {
    "C": ""
  },
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 28,
  "valueTypes": {
    "C": "Empty"
  },
  "values": {
    "C": ""
  }
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Within Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

MAP FIELDS

Select By*

Choose how you want to locate the range:

Define the range manually (e.g., A1:D20).

Address:

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

Start Range*

The first cell in the range (e.g., A1).

End Range

The last cell in the range.

Column Position*

The specific column index (e.g., 0 for the first column).

Header Row*

Indicates if the range includes a header row.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for range address 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27D24:D27%27)/column(column=0)",
  "address": "'Sheet test'!D24:D27",
  "addressLocal": "'Sheet test'!D24:D27",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "QTY": "General"
    },
    {
      "QTY": "General"
    },
    {
      "QTY": "General"
    }
  ],
  "columnIndex": 3,
  "text": [
    {
      "QTY": "1"
    },
    {
      "QTY": "2"
    },
    {
      "QTY": "3"
    }
  ],
  "formulas": [
    {
      "QTY": 1
    },
    {
      "QTY": 2
    },
    {
      "QTY": 3
    }
  ],
  "formulasLocal": [
    {
      "QTY": 1
    },
    {
      "QTY": 2
    },
    {
      "QTY": 3
    }
  ],
  "formulasR1C1": [
    {
      "QTY": 1
    },
    {
      "QTY": 2
    },
    {
      "QTY": 3
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": [
    {
      "QTY": "Double"
    },
    {
      "QTY": "Double"
    },
    {
      "QTY": "Double"
    }
  ],
  "values": [
    {
      "QTY": 1
    },
    {
      "QTY": 2
    },
    {
      "QTY": 3
    }
  ]
}

Select a named range defined in Excel.

Range Name*

The named range created in Excel (e.g., SalesReportData).

Column Position*

Column index to extract within the named range (e.g., 0 for the first column).

Header Row*

Indicates if the range includes a header row.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for range name 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27Salary%27)/range()/column(column=0)",
  "address": "'Sheet test'!C24:C27",
  "addressLocal": "'Sheet test'!C24:C27",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Salary": "General"
    },
    {
      "Salary": "General"
    },
    {
      "Salary": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "Salary": "300"
    },
    {
      "Salary": "500"
    },
    {
      "Salary": "400"
    }
  ],
  "formulas": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "formulasLocal": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "formulasR1C1": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": [
    {
      "Salary": "Double"
    },
    {
      "Salary": "Double"
    },
    {
      "Salary": "Double"
    }
  ],
  "values": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Before
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Range Address*

The cell range that acts as the reference point (for example, C24:C271).
The Method retrieves the column(s) immediately before this range.

Count of Columns

Defines how many columns to retrieve before the given range.
If not specified, the Method defaults to returning 1 column.

  • Example: If the Range Address is C5:D10 and Count of Columns = 1, the Method returns column B.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27E24:E27%27)/columnsBefore(count=2)",
  "address": "'Sheet test'!C24:D27",
  "addressLocal": "'Sheet test'!C24:D27",
  "columnCount": 2,
  "cellCount": 8,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": {
    "C": "General",
    "D": "0%"
  },
  "columnIndex": 2,
  "text": {
    "C": "Salary",
    "D": "QTY"
  },
  "formulas": {
    "C": "Salary",
    "D": "QTY"
  },
  "formulasLocal": {
    "C": "Salary",
    "D": "QTY"
  },
  "formulasR1C1": {
    "C": "Salary",
    "D": "QTY"
  },
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": {
    "C": "String",
    "D": "String"
  },
  "values": {
    "C": "Salary",
    "D": "QTY"
  }
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column After
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Range Address*

The cell range that acts as the reference point (for example, C24:C27).
The Method retrieves one or more columns located immediately after this range.

Count of Columns

Indicates how many columns to retrieve.
If left empty, Wiresk automatically returns 1 column after the specified range.

  • Example: If the Range Address is C5:D10 and Count of Columns = 1, the Method returns column E.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27B24:B27%27)/columnsAfter(count=1)",
  "address": "'Sheet test'!C24:C27",
  "addressLocal": "'Sheet test'!C24:C27",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": {
    "C": "General"
  },
  "columnIndex": 2,
  "text": {
    "C": "Salary"
  },
  "formulas": {
    "C": "Salary"
  },
  "formulasLocal": {
    "C": "Salary"
  },
  "formulasR1C1": {
    "C": "Salary"
  },
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": {
    "C": "String"
  },
  "values": {
    "C": "Salary"
  }
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Entire Row or Column
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Range Type*

Defines whether the Method retrieves rows or columns.

  • Entire Row → Returns all cells in the specified row(s).
  • Entire Column → Returns all cells in the specified column(s).

Range Address*

A reference address (e.g., A1:B5 or 16:18).
Wiresk uses this to determine which full row(s) or column(s) to return.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response from Entire Row 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%2716:17%27)/entireRow()",
  "address": "'Sheet test'!16:17",
  "addressLocal": "'Sheet test'!16:17",
  "columnCount": 16384,
  "cellCount": 32768,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": null,
  "columnIndex": 0,
  "text": null,
  "formulas": null,
  "formulasLocal": null,
  "formulasR1C1": null,
  "hidden": false,
  "rowCount": 2,
  "rowIndex": 15,
  "valueTypes": null,
  "values": null
}
Sample response from Entire Column 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BEE668EC1-F3F9-8140-A145-8A8C437FD2A5%7D%27)/range(address=%27A1:B5%27)/entireColumn()",
  "address": "'Sheet test'!A:B",
  "addressLocal": "'Sheet test'!A:B",
  "columnCount": 2,
  "cellCount": 2097152,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": null,
  "columnIndex": 0,
  "text": null,
  "formulas": null,
  "formulasLocal": null,
  "formulasR1C1": null,
  "hidden": false,
  "rowCount": 1048576,
  "rowIndex": 0,
  "valueTypes": null,
  "values": null
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Find Last Cell, Row, or Column
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

MAP FIELDS

Range Type*

Determines what kind of position the Method should return:

  • Last Cell – Retrieves the final used cell inside the specified range.
  • Last Row – Retrieves the last row containing data.
  • Last Column – Retrieves the last column containing data.

Range Name*

Refers to a named range in the workbook.
The search for the last position occurs within this named range.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response from Range Type = Last Cell 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27Salary%27)/range()/lastCell()",
  "address": "'Sheet test'!C27",
  "addressLocal": "'Sheet test'!C27",
  "columnCount": 1,
  "cellCount": 1,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "C": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "C": "400"
    }
  ],
  "formulas": [
    {
      "C": 400
    }
  ],
  "formulasLocal": [
    {
      "C": 400
    }
  ],
  "formulasR1C1": [
    {
      "C": 400
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 26,
  "valueTypes": [
    {
      "C": "Double"
    }
  ],
  "values": [
    {
      "C": 400
    }
  ]
}
Sample response from Range Type = Last Row 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27NamedRange%27)/range()/lastRow()",
  "address": "'Sheet test'!C27:D27",
  "addressLocal": "'Sheet test'!C27:D27",
  "columnCount": 2,
  "cellCount": 2,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "C": "General",
      "D": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "C": "400",
      "D": "3"
    }
  ],
  "formulas": [
    {
      "C": 400,
      "D": 3
    }
  ],
  "formulasLocal": [
    {
      "C": 400,
      "D": 3
    }
  ],
  "formulasR1C1": [
    {
      "C": 400,
      "D": 3
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 26,
  "valueTypes": [
    {
      "C": "Double",
      "D": "Double"
    }
  ],
  "values": [
    {
      "C": 400,
      "D": 3
    }
  ]
}
Sample response from Range Type = Last Column 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27NamedRange%27)/range()/lastColumn()",
  "address": "'Sheet test'!D24:D27",
  "addressLocal": "'Sheet test'!D24:D27",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "D": "0%"
    },
    {
      "D": "General"
    },
    {
      "D": "General"
    },
    {
      "D": "General"
    }
  ],
  "columnIndex": 3,
  "text": [
    {
      "D": "QTY"
    },
    {
      "D": "1"
    },
    {
      "D": "2"
    },
    {
      "D": "3"
    }
  ],
  "formulas": [
    {
      "D": "QTY"
    },
    {
      "D": 1
    },
    {
      "D": 2
    },
    {
      "D": 3
    }
  ],
  "formulasLocal": [
    {
      "D": "QTY"
    },
    {
      "D": 1
    },
    {
      "D": 2
    },
    {
      "D": 3
    }
  ],
  "formulasR1C1": [
    {
      "D": "QTY"
    },
    {
      "D": 1
    },
    {
      "D": 2
    },
    {
      "D": 3
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": [
    {
      "D": "String"
    },
    {
      "D": "Double"
    },
    {
      "D": "Double"
    },
    {
      "D": "Double"
    }
  ],
  "values": [
    {
      "D": "QTY"
    },
    {
      "D": 1
    },
    {
      "D": 2
    },
    {
      "D": 3
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Find Used Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

ValuesOnly

Choose whether to include only filled cells or also formatted ones.

Default: false

  • If false returns the entire used rectangle, counting cells that are “used” because of either data or formatting.
  • If true returns the smallest rectangle that contains actual data only (ignores formatting).

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response with ValuesOnly = false 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B54361455-74D9-4F8C-A0B6-B2FBEBF4C504%7D%27)/usedRange(valuesOnly=false)",
  "address": "'Sheet test 2'!A1:F4",
  "addressLocal": "'Sheet test 2'!A1:F4",
  "columnCount": 6,
  "cellCount": 24,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "m/d/yyyy",
      "E": "General",
      "F": "General"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "_([$$-en-US]* #,##0.00_);_([$$-en-US]* (#,##0.00);_([$$-en-US]* \"-\"??_);_(@_)",
      "E": "General",
      "F": "General"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "General",
      "E": "General",
      "F": "General"
    },
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "General",
      "E": "General",
      "F": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "A": "Header 1",
      "B": "Header 2",
      "C": "Header 3",
      "D": "1/1/2025",
      "E": "header 5",
      "F": ""
    },
    {
      "A": "1",
      "B": "1",
      "C": "1",
      "D": "",
      "E": "3",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    }
  ],
  "formulas": [
    {
      "A": "Header 1",
      "B": "Header 2",
      "C": "Header 3",
      "D": "=DATE(2025,1,1)",
      "E": "header 5",
      "F": ""
    },
    {
      "A": 1,
      "B": 1,
      "C": 1,
      "D": "",
      "E": "=SUM(A2:D2)",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    }
  ],
  "formulasLocal": [
    {
      "A": "Header 1",
      "B": "Header 2",
      "C": "Header 3",
      "D": "=DATE(2025,1,1)",
      "E": "header 5",
      "F": ""
    },
    {
      "A": 1,
      "B": 1,
      "C": 1,
      "D": "",
      "E": "=SUM(A2:D2)",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    }
  ],
  "formulasR1C1": [
    {
      "A": "Header 1",
      "B": "Header 2",
      "C": "Header 3",
      "D": "=DATE(2025,1,1)",
      "E": "header 5",
      "F": ""
    },
    {
      "A": 1,
      "B": 1,
      "C": 1,
      "D": "",
      "E": "=SUM(RC[-4]:RC[-1])",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 0,
  "valueTypes": [
    {
      "A": "String",
      "B": "String",
      "C": "String",
      "D": "Double",
      "E": "String",
      "F": "Empty"
    },
    {
      "A": "Double",
      "B": "Double",
      "C": "Double",
      "D": "Empty",
      "E": "Double",
      "F": "Empty"
    },
    {
      "A": "Empty",
      "B": "Empty",
      "C": "Empty",
      "D": "Empty",
      "E": "Empty",
      "F": "Empty"
    },
    {
      "A": "Empty",
      "B": "Empty",
      "C": "Empty",
      "D": "Empty",
      "E": "Empty",
      "F": "Empty"
    }
  ],
  "values": [
    {
      "A": "Header 1",
      "B": "Header 2",
      "C": "Header 3",
      "D": 45658,
      "E": "header 5",
      "F": ""
    },
    {
      "A": 1,
      "B": 1,
      "C": 1,
      "D": "",
      "E": 3,
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    },
    {
      "A": "",
      "B": "",
      "C": "",
      "D": "",
      "E": "",
      "F": ""
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Row Within Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

MAP FIELDS

Select By*

Choose how you want to locate the range:

Manually enter start and end cell references

Address:

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

Start Range*

The first cell in the range (e.g., A1).

End Range

The last cell in the range.

Row Position*

Indicates the row position within the specified range that you want to retrieve. (e.g., 0 for the first row).

Header Row*

Indicates if the range includes a header row.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for range address 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B54361455-74D9-4F8C-A0B6-B2FBEBF4C504%7D%27)/range(address=%27A1:E2%27)/row(row=1)",
  "address": "'Sheet test 2'!A2:E2",
  "addressLocal": "'Sheet test 2'!A2:E2",
  "columnCount": 5,
  "cellCount": 5,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "A": "General",
      "B": "General",
      "C": "General",
      "D": "General",
      "E": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "A": "Value 1",
      "B": "Value 2",
      "C": "Value 3",
      "D": "Value 4",
      "E": "Value 5"
    }
  ],
  "formulas": [
    {
      "A": "Value 1",
      "B": "Value 2",
      "C": "Value 3",
      "D": "Value 4",
      "E": "Value 5"
    }
  ],
  "formulasLocal": [
    {
      "A": "Value 1",
      "B": "Value 2",
      "C": "Value 3",
      "D": "Value 4",
      "E": "Value 5"
    }
  ],
  "formulasR1C1": [
    {
      "A": "Value 1",
      "B": "Value 2",
      "C": "Value 3",
      "D": "Value 4",
      "E": "Value 5"
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 1,
  "valueTypes": [
    {
      "A": "String",
      "B": "String",
      "C": "String",
      "D": "String",
      "E": "String"
    }
  ],
  "values": [
    {
      "A": "Value 1",
      "B": "Value 2",
      "C": "Value 3",
      "D": "Value 4",
      "E": "Value 5"
    }
  ]
}

Use a defined named range in the workbook.

Range Name*

The named range created in Excel (e.g., SalesReportData).

Row Position*

Indicates the row position within the specified range that you want to retrieve. (e.g., 0 for the first row).

Header Row*

Indicates if the range includes a header row.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for range name 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27Salary%27)/range()/column(column=0)",
  "address": "'Sheet test'!C24:C27",
  "addressLocal": "'Sheet test'!C24:C27",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Salary": "General"
    },
    {
      "Salary": "General"
    },
    {
      "Salary": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "Salary": "300"
    },
    {
      "Salary": "500"
    },
    {
      "Salary": "400"
    }
  ],
  "formulas": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "formulasLocal": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "formulasR1C1": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 23,
  "valueTypes": [
    {
      "Salary": "Double"
    },
    {
      "Salary": "Double"
    },
    {
      "Salary": "Double"
    }
  ],
  "values": [
    {
      "Salary": 300
    },
    {
      "Salary": 500
    },
    {
      "Salary": 400
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Merge Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Start Range*

Defines the starting cell of the range to merge (for example, A6).

End Range*

Defines the last cell in the range to merge (for example, E7).

The combined range from Start Range to End Range determines the full merge area.

Merge by Row

Specifies whether the merge should be applied row by row within the selected range.

  • True: merges cells horizontally within each row of the range.
  • False: merges all selected cells into a single cell spanning multiple rows and columns.
Sample response 
{
  "message": "Range merged successfully."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Unmerge Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Merged Range Address*

Indicates the starting address of the merged cell range to unmerge.

For instance, if cells A6:E7 were previously merged, providing A6 as the address will unmerge that entire merged block.

Sample response 
{
  "message": "Range unmerged successfully."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Insert New Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

MAP FIELDS

Select By*

Defines how the range is identified:

Manually enter start and end cell references (e.g., A1 or A3:C5).

Address:

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

Start Range*

The first cell in the range (e.g., A1).

End Range

The last cell in the range.

Shift Direction*

Specifies how existing cells should move when the new range is inserted. Options include:

  • Shift Down – inserts new rows, shifting existing rows downward.
  • Shift Right – inserts new columns, shifting existing columns to the right.
Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B54361455-74D9-4F8C-A0B6-B2FBEBF4C504%7D%27)/range(address=%27A2:E2%27)/insert()",
  "address": "'Sheet test 2'!A2:E2",
  "addressLocal": "'Sheet test 2'!A2:E2",
  "columnCount": 5,
  "cellCount": 5,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    [
      "General",
      "General",
      "General",
      "General",
      "General"
    ]
  ],
  "columnIndex": 0,
  "text": [
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulas": [
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulasLocal": [
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulasR1C1": [
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 1,
  "valueTypes": [
    [
      "Empty",
      "Empty",
      "Empty",
      "Empty",
      "Empty"
    ]
  ],
  "values": [
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ]
}

Use a defined named range in the workbook.

Range Name*

The named range created in Excel (e.g., SalesReportData).

Shift Direction*

Specifies how existing cells should move when the new range is inserted. Options include:

  • Shift Down – inserts new rows, shifting existing rows downward.
  • Shift Right – inserts new columns, shifting existing columns to the right.
Sample response for range name 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27NamedRange2%27)/range()/insert()",
  "address": "'Sheet test 2'!A1:E3",
  "addressLocal": "'Sheet test 2'!A1:E3",
  "columnCount": 5,
  "cellCount": 15,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    [
      "General",
      "General",
      "General",
      "General",
      "General"
    ],
    [
      "General",
      "General",
      "General",
      "General",
      "General"
    ],
    [
      "General",
      "General",
      "General",
      "General",
      "General"
    ]
  ],
  "columnIndex": 0,
  "text": [
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulas": [
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulasLocal": [
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "formulasR1C1": [
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ],
  "hidden": false,
  "rowCount": 3,
  "rowIndex": 0,
  "valueTypes": [
    [
      "Empty",
      "Empty",
      "Empty",
      "Empty",
      "Empty"
    ],
    [
      "Empty",
      "Empty",
      "Empty",
      "Empty",
      "Empty"
    ],
    [
      "Empty",
      "Empty",
      "Empty",
      "Empty",
      "Empty"
    ]
  ],
  "values": [
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ],
    [
      "",
      "",
      "",
      "",
      ""
    ]
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Rows Above Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Range Name*

Defines the named range or reference point from which the system determines which rows are “above.”

Header Row*

Specifies whether the first row of the retrieved range should be treated as a header.

  • Use “Header” when the top row contains field names.
  • Use “No Header” if all rows contain data.

Count of Rows

Specify how many row you want to retrieve above the named range.

For example, if the named range “DataStart” refers to row 6, and you request 3 rows above, the Method retrieves rows 3, 4 and 5.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for Count of Rows = 3 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27NamedRange2%27)/range()/rowsAbove(count=3)",
  "address": "'Sheet test 2'!A1:E3",
  "addressLocal": "'Sheet test 2'!A1:E3",
  "columnCount": 5,
  "cellCount": 15,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "45658": "General",
      "Header 1": "General",
      "Header 2": "General",
      "Header 3": "General",
      "header 5": "General"
    },
    {
      "45658": "General",
      "Header 1": "General",
      "Header 2": "General",
      "Header 3": "General",
      "header 5": "General"
    },
    {
      "45658": "General",
      "Header 1": "General",
      "Header 2": "General",
      "Header 3": "General",
      "header 5": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "45658": "sample 4",
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "header 5": "sample 5"
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    }
  ],
  "formulas": [
    {
      "45658": "sample 4",
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "header 5": "sample 5"
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    }
  ],
  "formulasLocal": [
    {
      "45658": "sample 4",
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "header 5": "sample 5"
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    }
  ],
  "formulasR1C1": [
    {
      "45658": "sample 4",
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "header 5": "sample 5"
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    }
  ],
  "hidden": false,
  "rowCount": 3,
  "rowIndex": 0,
  "valueTypes": [
    {
      "45658": "String",
      "Header 1": "String",
      "Header 2": "String",
      "Header 3": "String",
      "header 5": "String"
    },
    {
      "45658": "Empty",
      "Header 1": "Empty",
      "Header 2": "Empty",
      "Header 3": "Empty",
      "header 5": "Empty"
    },
    {
      "45658": "Empty",
      "Header 1": "Empty",
      "Header 2": "Empty",
      "Header 3": "Empty",
      "header 5": "Empty"
    }
  ],
  "values": [
    {
      "45658": "sample 4",
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "header 5": "sample 5"
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    },
    {
      "45658": "",
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "header 5": ""
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Rows Below Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Worksheet ID*

Choose the worksheet (tab).

Wiresk lists available worksheet once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Worksheets“.

MAP FIELDS

Range Name*

Indicates the name of the defined range used as the reference point. The system will start counting rows below this range.

Header Row*

Specifies whether the first row of the retrieved range should be treated as a header.

  • Use “Header” when the top row contains field names.
  • Use “No Header” if all rows contain data.

Count of Rows

Determines how many rows below the specified range should be returned.
If you enter 2, Wiresk retrieves two rows immediately below the reference range.

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response for Count of Rows = 2 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/names(%27NamedRange2%27)/range()/rowsBelow(count=2)",
  "address": "'Sheet test 2'!A7:E8",
  "addressLocal": "'Sheet test 2'!A7:E8",
  "columnCount": 5,
  "cellCount": 10,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Header 1": "General",
      "Header 2": "General",
      "Header 3": "General",
      "Header 4": "General",
      "header 5": "General"
    },
    {
      "Header 1": "General",
      "Header 2": "General",
      "Header 3": "General",
      "Header 4": "General",
      "header 5": "General"
    }
  ],
  "columnIndex": 0,
  "text": [
    {
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "Header 4": "",
      "header 5": ""
    },
    {
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "Header 4": "sample 4",
      "header 5": "sample 5"
    }
  ],
  "formulas": [
    {
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "Header 4": "",
      "header 5": ""
    },
    {
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "Header 4": "sample 4",
      "header 5": "sample 5"
    }
  ],
  "formulasLocal": [
    {
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "Header 4": "",
      "header 5": ""
    },
    {
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "Header 4": "sample 4",
      "header 5": "sample 5"
    }
  ],
  "formulasR1C1": [
    {
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "Header 4": "",
      "header 5": ""
    },
    {
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "Header 4": "sample 4",
      "header 5": "sample 5"
    }
  ],
  "hidden": false,
  "rowCount": 2,
  "rowIndex": 6,
  "valueTypes": [
    {
      "Header 1": "Empty",
      "Header 2": "Empty",
      "Header 3": "Empty",
      "Header 4": "Empty",
      "header 5": "Empty"
    },
    {
      "Header 1": "String",
      "Header 2": "String",
      "Header 3": "String",
      "Header 4": "String",
      "header 5": "String"
    }
  ],
  "values": [
    {
      "Header 1": "",
      "Header 2": "",
      "Header 3": "",
      "Header 4": "",
      "header 5": ""
    },
    {
      "Header 1": "sample 1",
      "Header 2": "sample 2",
      "Header 3": "sample 3",
      "Header 4": "sample 4",
      "header 5": "sample 5"
    }
  ]
}

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

  • Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
  • Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

  • Activate or deactivate Triggers
  • Force-run the scheduler
  • Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.

Important 01 Excel - Table Range & Ranges

Going further Copy Link

See related Microsoft apps.

Explore the full Wiresk User Guide to learn more.

Looking for an integration that’s not yet available? Submit a request to our team, we’ll do our best to support your needs.