Writing Text and Links

GDXXRW allows one to write text or hyperlinks into a spreadsheet

This is done using the syntax

 Text = "String of characters" Range=place

or

 Text = "String of characters" Range=place Link=Address

or

 Text = "String of characters" Range=place LinkID=gamsitem

where        the text encased between the " marks is written to the specified range

 if link=address is specified then the text is made a hyperlink referring to the location address

           if linkid=gamsitem is specified then the link points to the upper left hand corner of the place where that item is located in a GDXXRW instruction that is in same GDXXRW execution

Example:

(gdxxrwwrite.gms)

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls text="This is the link dictionary" rng=linkdictionary!a1  '

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls text="This is the twodim parameter" rng=output!a1  '

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls par=twodim rng=output!b2 text="Link to twodim" rng=linkdictionary!a2 linkid=twodim  '

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls text="This is the threedim parameter" rng=output!a10  '

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls par=threedim rng=output!a12 text="Link to threedim" rng=linkdictionary!a3 linkid=threedim'

execute 'gdxxrw gdxxrwwrite.gdx o=gdxxrwss.xls text="Link to threedim second variant" rng=linkdictionary!a4 link=output!a33'

This labels items in the spreadsheetgdxxrwss.xls some with pure text and insetrts three hyperlinks.on a sheet called dictionary.

Notes: