Get all cells in an Excel tab
Get all cells in an Excel tab
Gets the values of every filled cell in an Excel tab, returning the data as a list of rows and columns.
Options
Tab name
Enter the name of the tab whose cells will be read.
Returns
- Worksheet rows — Returns a list with the values of each row.
- Number of lines — Returns the total number of filled rows.
- Number of columns — Returns the number of columns.
Rules and Conditions
- Every field is required.
- Only filled cells are returned.