Run script | Middle | Run Office scripts stored in Excel. |
Create table | Low | Create a new table by specifying a cell range. |
Get tables | Middle | Get information on all tables existing in the book. |
Add a row into a table | High | Add a new row to the table. |
Get a row | High | Specify search conditions and retrieve one row of data from the table. |
Update a row | High | Specify search conditions and update one row of data from the table. |
Add a key column to a table | Middle | Add a single column item to the table. |
Delete a row | High | Specify search conditions and dedate one row of data from the table. |
List rows present in a table | High | Get all rows of data in table. |
Create worksheet | Low | Create a new worksheet. |
Get worksheets | Low | Get information on all worksheets existing in the book. |