Bulk Copy To Table
Last Updated: Dec 1, 2020
Last Updated: Dec 1, 2020
Use this function to copy values (without metadata) to a data table from the specified range of the currently active excel sheet. This function is useful to copy the data faster when the data is huge.
Bulk Copy To Table With Sheet Name (table_name, range_value, sheet_name)
| Input Parameter Name | Description |
|---|---|
| table_name | Name of the table from table definition |
| range_value | Two cell values (first cell and last cell) separated by ‘:’ to copy the values |
':' is used as separator between the cells.
| Return value | Description |
|---|---|
| Table | Returns the copied data as a table type variable |
Bulk Copy To Table With Sheet Name (Table1, A1:A5)
To view all the Excel functions, click here.