ElectroNeek + Microsoft Excel 365

Actions · 33

• Append Row to Worksheet

  Append row of values to a worksheet

• Append Multiple Rows

  Appends multiple row of values to a worksheet.

• Get Worksheets

  Retrieve worksheets from a workbook

• Get Worksheet Rows

  Retrieve rows from a worksheet

• Update Worksheet Rows

  Update a row in a worksheet

• Clear Worksheet

  Clear a worksheet

• Delete Worksheet

  Delete a worksheet in a workbook

• Get Workbooks

  Retrieve a list of workbooks

• Get Worksheet Columns

  List columns of a worksheet.

• Delete Workbook

  Delete a workbook

• Add a Worksheet to a Workbook

  Add a worksheet to a workbook

• Get Table Rows

  List rows of a table in a worksheet

• Get Table Columns

  List columns of a table in a worksheet

• Create Table

  Create a table in a worksheet

• Delete Table

  Delete a table from a worksheet

• Lookup Table Column

  Lookup a value in a table column in a worksheet

• Append Rows to a Table

  Append rows to a table

• Convert to Range

  Converts a table to a range

• Create Workbook

  Create a new workbook at the specified location

• Clear Column by Index

  Clear contents/formatting of a column by its index.

• Clear Cells by Range

  Clear a block of cells (range) content or formatting.

• Clear Row by ID

  Clear contents/formatting of an entire row by its ID.

• Delete Row

  Delete an entire row from a worksheet by its row number.

• Create Worksheet

  Add a new worksheet (tab) to an existing workbook with optional default headers.

• Copy Worksheet

  Duplicate a worksheet into a new worksheet, in the same workbook or a different one. Copies values, formulas, and number formats.

• Find Row

  Locate a row by specifying a lookup column and value (e.g. find a row where “ID” = 123).

• Find Workbook

  Finds an existing workbook by name.

• Find Worksheet

  Finds an existing worksheet by name.

• Get Cells in Range

  Retrieve the values in a given cell range (e.g., “A1:C10”).

• Get Row by ID

  Retrieve the entire content of a row by its row ID.

• Get Worksheet by ID

  Retrieve metadata of a worksheet by its ID.

• Rename Worksheet

  Change the name of an existing worksheet.

• Custom API Call

  Make a custom API call to a specific endpoint

Triggers · 4

• New Row

  Trigger when a new row is added, and it can include existing rows as well.

• New Row in Table

  Fires when a new row is added to a table within a worksheet.

• New Worksheet

  Fires when a new worksheet is created in a workbook.

• Updated Row

  Fires when a row (in a worksheet) is added or updated.