User Tools

Site Tools


interfaces:importing_set_labels_into_excel_using_gdxxrw

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

interfaces:importing_set_labels_into_excel_using_gdxxrw [2007/09/20 20:59] (current)
Line 1: Line 1:
 +====== Importing Set Labels into Excel using gdxxrw ======
  
 +Below is an example, which shows how to import set labels in Excel using gdxxrw.
 +<​code>​
 +set i /i1 one
 +       i2 two
 +       i3 three
 +       i4 four/;
 +
 +$gdxout test.gdx
 +$unload i
 +$gdxout
 +
 +$onecho > task.txt
 +set=i rng=sheet1!a1 values=YN
 +set=i rng=sheet2!a1 values=NoData
 +set=i rng=sheet3!a1 values=String
 +$offecho
 +
 +$call gdxxrw test.gdx @task.txt
 +
 +$call shellexecute test.xls
 +</​code>​
 +
 +You may also check this example (contributed by Tom Rutherford):​ http://​www.mpsge.org/​exceltable.html
IMPRESSUM / LEGAL NOTICEPRIVACY POLICY interfaces/importing_set_labels_into_excel_using_gdxxrw.txt ยท Last modified: 2007/09/20 20:59 (external edit)