Data specification

 Top  Previous  Next

Data items can be read from the spreadsheet in the form of set elements, set explanatory text, parameters and data for variables or equations.  Such entries have both general and specific requirements.  In general the commands are of the form

 

DataType=ItemName Rng=DataRange Dimensions SymbolOptions

 

where

DataTypeidentifies the type of item and is one of the symbols: Par, Set, Dset, Equ, Text, or Var as discussed below.
Itemname identifies the name of the item in the GDX file.  These should follow the GAMS item naming rules as discussed in the Rules for Item Names, Element Names and Explanatory Text chapter.
Rng=Datarangeis an optional specification of the range where the item is to be placed or withdrawn from following the practices above where if omitted is cell A1 of the first sheet in the workbook.
Dimensionsis an optional specification of item dimensions following the dimension identification practices identified in the section just above.
SymbolOptionsare optional and controls read or write specific options.

 

There are multiple forms of this command and each will be discussed separately.