Last Updated: May 10, 2022
Use this function to copy values (without metadata) to a Data Table from the specified range of the currently active excel sheet.
Copy Values As Table (table_definition, range)
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 |
Return value | Description |
---|---|
Table | Returns the copied data as a table type variable |
Copy Values As Table (EmployeeDetails, A1:A5)
To view all the Excel functions, click here.