Wiresk

Wiresk

Excel – Worksheets & Table

Estimated reading time: 14 min

What your automation will do…

excel logo Background Removed Excel - Worksheets & Table

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* Search Workbook
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Path*

Specify the folder path or Workbook name to search.

  • Full file URL like: https://{tenant}.sharepoint.com/sites/{site}/Shared%20Documents/Workbook%20sample.xlsx
  • Exact file name with extension (must match exactly).

You can use dynamic values (e.g., from previous steps).

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 
[
  {
    "createdDateTime": "2024-05-13T11:08:50Z",
    "id": "01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD",
    "lastModifiedDateTime": "2025-10-10T04:26:13Z",
    "name": "Workbook sample.xlsx",
    "webUrl": "https://example.sharepoint.com/sites/forms2crm/_layouts/15/Doc.aspx?sourcedoc=%7B71A64B68-DDB2-4257-87BB-D633BAF6E0E3%7D&file=Workbook%20sample.xlsx&action=default&mobileredirect=true&DefaultItemOpen=1",
    "size": 21456,
    "createdBy": {
      "user": {
        "email": "admin@wiresk.com",
        "displayName": "Admin Wiresk"
      }
    },
    "lastModifiedBy": {
      "user": {
        "email": "user@wiresk.com",
        "displayName": "User Wiresk"
      }
    },
    "parentReference": {
      "driveType": "documentLibrary",
      "driveId": "b!odUJ-gA-LkGgraJ0g68QMjqiVwH_spxFgRX8NPryd4fx0qxCBGP2T5Ii-TQQBrUZ",
      "id": "01NMYE6H56Y2GOVW7725BZO354PWSELRRZ",
      "siteId": "fa09d5a1-3e00-412e-a0ad-a27483af1032"
    },
    "file": {
      "mimeType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
      "hashes": []
    },
    "fileSystemInfo": {
      "createdDateTime": "2024-05-13T11:08:50Z",
      "lastModifiedDateTime": "2025-10-10T04:26:13Z"
    },
    "searchResult": []
  }
]

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* List Worksheets
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) you want to list worksheets from.

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

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

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.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7BB53D6A25-4A04-AE40-999F-42F7658B45BC%7D%27)",
    "id": "{B53D6A25-4A04-AE40-999F-42F7658B45BC}",
    "name": "Sheet1",
    "position": 0,
    "visibility": "Visible"
  },
  {
    "@odata.id": "/sites('idcrmltd.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)",
    "id": "{EE668EC1-F3F9-8140-A145-8A8C437FD2A5}",
    "name": "Sheet test",
    "position": 1,
    "visibility": "Visible"
  }
]

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* Create New Sheet
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) you want to add a new worksheet to.

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

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

MAP FIELDS

Worksheet Name

The name of the new worksheet to create. You can use static text or dynamic data from previous steps.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookWorksheet",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B8B29C538-4363-4F0C-84DE-FD10B7415F32%7D%27)",
  "id": "{8B29C538-4363-4F0C-84DE-FD10B7415F32}",
  "name": "new sheet",
  "position": 2,
  "visibility": "Visible"
}

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 Worksheets
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) you want to list worksheets from.

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) you want to get info about.

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

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

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#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B8B29C538-4363-4F0C-84DE-FD10B7415F32%7D%27)",
  "id": "{8B29C538-4363-4F0C-84DE-FD10B7415F32}",
  "name": "new sheet",
  "position": 2,
  "visibility": "Visible"
}

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 Worksheet
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) you want to list worksheets from.

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) you want to update.

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

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

MAP FIELDS

Worksheet Name

Rename the worksheet.

Worksheet Position

Changes the order of the worksheet in the workbook (0 = first position).

Worksheet Visibility

Controls whether the worksheet is visible, hidden, or very hidden.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/worksheets(%27%7B8B29C538-4363-4F0C-84DE-FD10B7415F32%7D%27)",
  "id": "{8B29C538-4363-4F0C-84DE-FD10B7415F32}",
  "name": "updated sheet",
  "position": 0,
  "visibility": "Visible"
}

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 Worksheet
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) you want to list worksheets from.

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) you want to delete.

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

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

Sample response 
{
  "message": "Worksheet deleted successfully."
}
excel logo Background Removed Excel - Worksheets & Table

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* List Tables Within a 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“.

MAP FIELDS

Limit

Maximum number of tables to return.

Offset

Number of items to skip before listing (useful for pagination when dealing with many tables).

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.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7BFFFC1909-B418-467A-89C0-B0961CE13DA2%7D%27)",
    "highlightLastColumn": false,
    "highlightFirstColumn": false,
    "showFilterButton": true,
    "id": "{FFFC1909-B418-467A-89C0-B0961CE13DA2}",
    "showBandedColumns": false,
    "legacyId": "3",
    "style": "TableStyleMedium2",
    "name": "Table3",
    "showBandedRows": true,
    "showHeaders": true,
    "showTotals": false
  },
  {
    "@odata.id": "/sites('idcrmltd.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)",
    "highlightLastColumn": false,
    "highlightFirstColumn": false,
    "showFilterButton": true,
    "id": "{3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6}",
    "showBandedColumns": false,
    "legacyId": "1",
    "style": "TableStyleMedium2",
    "name": "Table1",
    "showBandedRows": true,
    "showHeaders": true,
    "showTotals": false
  },
  {
    "@odata.id": "/sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB%7D%27)",
    "highlightLastColumn": false,
    "highlightFirstColumn": false,
    "showFilterButton": true,
    "id": "{6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB}",
    "showBandedColumns": false,
    "legacyId": "2",
    "style": "TableStyleMedium2",
    "name": "Table13",
    "showBandedRows": true,
    "showHeaders": true,
    "showTotals": false
  }
]

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* List Tables Within a Worksheet
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) where you want to find tables.

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

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

MAP FIELDS

Limit

Maximum number of tables to return.

Offset

Number of items to skip before listing (useful for pagination when dealing with many tables).

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.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)",
    "highlightLastColumn": false,
    "highlightFirstColumn": false,
    "showFilterButton": true,
    "id": "{3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6}",
    "showBandedColumns": false,
    "legacyId": "1",
    "style": "TableStyleMedium2",
    "name": "Table1",
    "showBandedRows": true,
    "showHeaders": true,
    "showTotals": false
  },
  {
    "@odata.id": "/sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB%7D%27)",
    "highlightLastColumn": false,
    "highlightFirstColumn": false,
    "showFilterButton": true,
    "id": "{6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB}",
    "showBandedColumns": false,
    "legacyId": "2",
    "style": "TableStyleMedium2",
    "name": "Table13",
    "showBandedRows": true,
    "showHeaders": true,
    "showTotals": false
  }
]

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* Add a New Table
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 range where the table starts.
Example: A1

End Range

The bottom-right cell that defines the end of the table range.
Example: C10

Table Header

Indicates whether the first row contains headers.
Options:

  • True: Treats the first row as column headers.
  • False: Creates the table without headers.
Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTable",
  "@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)/tables(%27%7B594A1F3E-3F87-493C-BE16-9524BF6A55C4%7D%27)",
  "highlightLastColumn": false,
  "highlightFirstColumn": false,
  "showFilterButton": true,
  "id": "{594A1F3E-3F87-493C-BE16-9524BF6A55C4}",
  "showBandedColumns": false,
  "legacyId": "5",
  "style": "TableStyleMedium2",
  "name": "Table5",
  "showBandedRows": true,
  "showHeaders": true,
  "showTotals": false
}

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 a Table
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 retrieve.

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#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB%7D%27)",
  "highlightLastColumn": false,
  "highlightFirstColumn": false,
  "showFilterButton": true,
  "id": "{6B6C85BE-7B82-4F5E-8BBA-8630D3995DDB}",
  "showBandedColumns": false,
  "legacyId": "2",
  "style": "TableStyleMedium2",
  "name": "Table13",
  "showBandedRows": true,
  "showHeaders": true,
  "showTotals": false
}

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 Table
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 update.

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

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

MAP FIELDS

Table Name

Renames the table.

Important rules for names:

  • Use valid characters — Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name.Exceptions: You can’t use “C”, “c”, “R”, or “r” for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box.
  • Don’t use cell references— Names can’t be the same as a cell reference, such as Z$100 or R1C1.
  • Don’t use a space to separate words— Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter.
  • Maximum 255 characters—A table name can have up to 255 characters.
  • Use unique table names— Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES” in the same workbook, you’ll be prompted to choose a unique name.

For more details, see Rename an Excel table.

Headers

Controls whether to show or hide the header row.
Options:

  • True: Displays the header row.
  • False: Hides the header row.

Totals

Controls whether to show or hide the totals row.
Options:

  • True: Displays the totals row at the bottom.
  • False: Hides the totals row.

Table Style

Changes the table’s visual design using Excel’s built-in style names.

Styles Light → Medium → Dark correspond roughly to low, moderate, and high color contrast.

Possible Choices:

TableStyleLight (1–21)

These are flat / subtle color palettes — light backgrounds with thin borders.

Style NameColor Theme
TableStyleLight1White (default Excel table)
TableStyleLight2Light gray
TableStyleLight3Pale blue
TableStyleLight4Very light orange
TableStyleLight5Light yellow
TableStyleLight6Soft green
TableStyleLight7Light green
TableStyleLight8Light turquoise
TableStyleLight9Sky blue
TableStyleLight10Light purple
TableStyleLight11Lavender
TableStyleLight12Light teal
TableStyleLight13Soft cyan
TableStyleLight14Beige
TableStyleLight15Pale brown
TableStyleLight16Pale orange
TableStyleLight17Light olive green
TableStyleLight18Light blue-gray
TableStyleLight19Blue outline with white fill
TableStyleLight20White with subtle horizontal stripes
TableStyleLight21Light red

TableStyleMedium (1–28)

Medium contrast with alternating row shades — these are Excel’s most common default styles.

Style NameColor Theme
TableStyleMedium1Gray gradient
TableStyleMedium2Blue gradient
TableStyleMedium3Teal
TableStyleMedium4Light orange
TableStyleMedium5Orange
TableStyleMedium6Gold
TableStyleMedium7Olive green
TableStyleMedium8Green
TableStyleMedium9Dark green
TableStyleMedium10Aqua
TableStyleMedium11Light blue
TableStyleMedium12Blue
TableStyleMedium13Dark blue
TableStyleMedium14Indigo
TableStyleMedium15Purple
TableStyleMedium16Violet
TableStyleMedium17Pink
TableStyleMedium18Red
TableStyleMedium19Dark red
TableStyleMedium20Brown
TableStyleMedium21Gray-blue
TableStyleMedium22Black outline with gray fill
TableStyleMedium23Blue outline with white fill
TableStyleMedium24Orange outline with white fill
TableStyleMedium25Green outline with white fill
TableStyleMedium26Aqua outline with white fill
TableStyleMedium27Blue-gray stripes
TableStyleMedium28Light red stripes

TableStyleDark (1–11)

High-contrast styles — dark background with white or bright text.

Style NameColor Theme
TableStyleDark1Black with white text
TableStyleDark2Charcoal gray
TableStyleDark3Dark blue
TableStyleDark4Navy blue
TableStyleDark5Teal
TableStyleDark6Forest green
TableStyleDark7Dark green (Excel’s classic “Dark 7”)
TableStyleDark8Brown
TableStyleDark9Burgundy red
TableStyleDark10Dark purple
TableStyleDark11Black with accent border
Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables/$entity",
  "@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)",
  "highlightLastColumn": false,
  "highlightFirstColumn": false,
  "showFilterButton": false,
  "id": "{3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6}",
  "showBandedColumns": false,
  "legacyId": "1",
  "style": "TableStyleLight11",
  "name": "UpdatedTable01",
  "showBandedRows": true,
  "showHeaders": false,
  "showTotals": false
}

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 Table
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 delete.

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

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

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

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 - Worksheets & Table

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.