Search

Copy Values As Table From A Sheet

Articles

Use this function to copy values (without metadata) from the specified range of the given excel sheet to a data table.

Syntax

Copy Values As Table From A Sheet (table_definition, range, sheet_name)

Parameters

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

Returns

Return value Description
Table Returns the copied data as a table type variable

Sample

Copy Values As Table From A Sheet (EmployeeDetails, A1:A5, ContactDetails)

  • Copies the data present in the range A1:A5 from the ContactDetails to table EmployeeDetails.

To view all the Excel functions, click here.

Did you find what you were looking for?