Copy Values As Table From A Sheet
Last Updated: Sep 13, 2021
Last Updated: Sep 13, 2021
Use this function to copy values (without metadata) from the specified range of the given excel sheet to a data table.
Copy Values As Table From A Sheet (table_definition, range, sheet_name)
| Input Parameter Name | Description |
|---|---|
| table_definition | Name of the table from table definition |
| range | First cell to last cell value separated by : to copy the values |
| sheet_name | Name of the sheet to copy the data |
| Return value | Description |
|---|---|
| Table | Returns the copied data as a table type variable |
Copy Values As Table From A Sheet (EmployeeDetails, A1:A5, ContactDetails)
To view all the Excel functions, click here.