Copies a portion of the table to the specified location in another table.
Syntax
table_name.copyrange(options) s1 s2 destname d1
table_name.copyrange(options) sr1 sc1 sr2 sc2 destname dr1 dc1
Options
Options are specified in parentheses after the keyword and are used to specify the format of the data in the destination table.
t | Places a transpose of the selected data into the destination area. The default is not transposed. |
The copyrange command can be specified either using coordinates where columns are signified with a letter, and rows by a number (for example “A3” represents the first column, third row), or by row number and column number.
The first syntax represents coordinate form, where s1 specifies the upper-left coordinate portion of the section of the source table to be copied, s2 specifies the bottom-right coordinate, destname specifies the name of the table to copy to, and d1 specifies the upper-left coordinate of the destination table.
The second syntax represents the row/column number form, where sr1 specifies the source table upper row number, sc1 specifies the source table left most column number, sr2 specifies the source table bottom row number, sc2 specifies the source table right most column number. destname specifies the name of the table to copy to, and dr1 and dr2 specify the upper and left most row and column of the destination table, respectively.
Examples
table1.copyrange B2 D4 table2 A1
places a copy of the data from cell range B2 to D4 in TABLE1 to TABLE2 at cell A1
table1.copyrange(t) 1 1 1 5 table2 1 3
copies 5 rows of data in the first column of data in table1 and places a transpose of the data at the top of the 3rd column of TABLE2.
Cross-references
For additional discussion of table commands see
“Working with Tables and Spreadsheets”.
See also
“Table and Text Objects” for a discussion and examples of table formatting in EViews.