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.