RANGE Subcommand (GET TRANSLATE command)

RANGE translates a specified set of cells from a spreadsheet file.

• RANGE cannot be used for translating database files.
• For 1-2-3 or Symphony, specify the beginning of the range with a column letter and row number followed by two periods and the end of the range with a column letter and row number, as in A1..K14.
• For Multiplan spreadsheets, specify the beginning and ending cells of the range separated by a colon, as in R1C1:R14C11.
• For Excel files, specify the beginning column letter and row number, a colon, and the ending column letter and row number, as in A1:K14.
• You can also specify the range using range names supplied in Symphony, 1-2-3, or Multiplan.
• If you specify FIELDNAMES with RANGE, the first row of the range must contain field names.

Example

GET TRANSLATE FILE='PROJECT.WKS' /FIELDNAMES /RANGE=D3..J279.

• GET TRANSLATE creates an active dataset from the 1-2-3 Release 1A file PROJECT.WKS.
• The field names in the first row of the range (row 3) are used as variable names.
• Data from cells D4 through J279 are transferred to the active dataset.