Microsoft Excel 365 + Nerve

Get Worksheets

Get Worksheets. Retrieve worksheets from a workbook

Get Worksheet Rows

Get Worksheet Rows. Retrieve rows from a worksheet

Get Workbooks

Get Workbooks. Retrieve a list of workbooks

Get Worksheet Columns

Get Worksheet Columns. List columns of a worksheet

Get Table Rows

Get Table Rows. List rows of a table in a worksheet

Get Table Columns

Get Table Columns. List columns of a table in a worksheet

Lookup Table Column

Lookup Table Column. Lookup a value in a table column in a worksheet

Convert to Range

Convert to Range. Converts a table to a range

Find Row

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

Find Workbook

Find Workbook. Finds an existing workbook by name

Find Worksheet

Find Worksheet. Finds an existing worksheet by name

Get Cells in Range

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

Append Row to Worksheet

Append Row to Worksheet. Append row of values to a worksheet

Append Multiple Rows

Append Multiple Rows. Appends multiple row of values to a worksheet

Update Worksheet Rows

Update Worksheet Rows. Update a row in a worksheet

Clear Worksheet

Clear Worksheet. Clear a worksheet

Delete Worksheet

Delete Worksheet. Delete a worksheet in a workbook

Delete Workbook

Delete Workbook. Delete a workbook

Add a Worksheet to a Workbook

Add a Worksheet to a Workbook. Add a worksheet to a workbook

Create Table

Create Table. Create a table in a worksheet

Delete Table

Delete Table. Delete a table from a worksheet

Append Rows to a Table

Append Rows to a Table. Append rows to a table

Create Workbook

Create Workbook. Create a new workbook at the specified location

Clear Column by Index

Clear Column by Index. Clear contents/formatting of a column by its index