This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
interfaces:interfaces [2011/07/19 06:08] support |
interfaces:interfaces [2020/10/30 20:41] Atharv Bhosekar |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Interfacing GAMS with other Applications ====== | ====== Interfacing GAMS with other Applications ====== | ||
- | * [[Problem opening Excel: Cannot create an instance of Excel]] | + | * [[What is GDX?]] |
* [[I/O error -100059 while using GDX I/O API]] | * [[I/O error -100059 while using GDX I/O API]] | ||
- | * [[GDXXRW error Call was rejected by callee|GDXXRW error: "Exception not caught: Call was rejected by callee"]] | ||
- | * [[How reads gdxxrw Excel data, which is stored as text?]] | ||
- | * [[GDXXRW is slow]] | ||
* [[Set identifier in GDX file name]] | * [[Set identifier in GDX file name]] | ||
- | * [[Writing text files with no modification from Excel]] | ||
* [[MPS Files and cone equations]] | * [[MPS Files and cone equations]] | ||
- | * [[Writing data to a spreadsheet and keeping control over the area used]] | ||
* [[Selective executive_unload]] | * [[Selective executive_unload]] | ||
* [[GDX and Unix?]] | * [[GDX and Unix?]] | ||
* [[How do I import set elements with blanks in the name?]] | * [[How do I import set elements with blanks in the name?]] | ||
- | * [[What is the default layout when exporting an n-dimensional parameter or set from GDX to Excel?]] | ||
* [[How do I import data into a multi-dimensional Table?]] | * [[How do I import data into a multi-dimensional Table?]] | ||
* [[Send model status to a GDX file|Sending the model status to a GDX file]] | * [[Send model status to a GDX file|Sending the model status to a GDX file]] | ||
- | * [[What is GDX?]] | ||
* [[User defined functions or subroutines]] | * [[User defined functions or subroutines]] | ||
* [[Creating a Table from raw data using the Posix tools]] | * [[Creating a Table from raw data using the Posix tools]] | ||
Line 21: | Line 14: | ||
* [[Can I change the decimal symbol from a dot to a comma?]] | * [[Can I change the decimal symbol from a dot to a comma?]] | ||
* [[Dynamic naming for gdx files]] | * [[Dynamic naming for gdx files]] | ||
- | * [[Importing only certain columns from a spreadsheet into GAMS]] | ||
- | * [[How can I split the input line for gdxxrw over several lines?]] | ||
- | * [[Which version of Excel is running on my machine?]] | ||
- | * [[Export of all elements of the solution including zero-elements to gdx and Excel]] | ||
* [[(GDX error message)*** Msg File version not supported]] | * [[(GDX error message)*** Msg File version not supported]] | ||
* [[(Very) old GAMS version and GDX utilities]] | * [[(Very) old GAMS version and GDX utilities]] | ||
- | * [[An example, which demonstrates the use of the merge option of gdxxrw to add solutions to a spreadsheet]] | ||
- | * [[Running gdxxrw only, if a spreadsheet has been changed]] | ||
- | * [[Importing Set Labels into Excel using gdxxrw]] | ||
- | * [[A Loop with GDXXRW.exe]] | ||
* [[Using Savepoints for Data Collection - an Example]] | * [[Using Savepoints for Data Collection - an Example]] | ||
* [[Merging set elements from several GDX-files into one basic set]] | * [[Merging set elements from several GDX-files into one basic set]] | ||
- | * [[Using TortoiseSVN]] | + | * [[How to merge a parameter from two gdx files without increasing the dimension?]] |
- | * //[[How can a GAMS process communicate with another process?]]// | + | * [[How can a GAMS process communicate with another process?]] |
- | * //[[Matlab and GAMS: Interfacing Optimization and Visualization Software via the GDXMRW Utilities]]// | + | * [[Using GAMS with PostgreSQL database system]] |
+ | * **GDXXRW: Interfacing GAMS with MS Excel** | ||
+ | * [[Problem opening Excel: Cannot create an instance of Excel]] | ||
+ | * [[GDXXRW error Call was rejected by callee|GDXXRW error: "Exception not caught: Call was rejected by callee"]] | ||
+ | * [[GDXXRW is slow]] | ||
+ | * [[Writing data to a spreadsheet and keeping control over the area used]] | ||
+ | * [[What is the default layout when exporting an n-dimensional parameter or set from GDX to Excel?]] | ||
+ | * [[Importing only certain columns from a spreadsheet into GAMS]] | ||
+ | * [[How can I split the input line for gdxxrw over several lines?]] | ||
+ | * [[Export of all elements of the solution including zero-elements to gdx and Excel]] | ||
+ | * [[An example, which demonstrates the use of the merge option of gdxxrw to add solutions to a spreadsheet]] | ||
+ | * [[Running gdxxrw only, if a spreadsheet has been changed]] | ||
+ | * [[Importing Set Labels into Excel using gdxxrw]] | ||
+ | * [[A Loop with GDXXRW.exe]] | ||
+ | * [[How reads gdxxrw Excel data, which is stored as text?]] | ||
+ | * [[Writing text files with no modification from Excel]] | ||
+ | * **[[matlab_and_gams:interfacing_optimization_and_visualization_software_via_the_gdxmrw_utilities|Matlab and GAMS: Interfacing Optimization and Visualization Software via the GDXMRW Utilities]]** | ||
+ | * **[[GDXRRW: Interfacing GAMS and R]]** | ||
===== More Resources ===== | ===== More Resources ===== | ||
* [[http://www.gams.com/contrib/contrib.htm|Contributed Software]] | * [[http://www.gams.com/contrib/contrib.htm|Contributed Software]] | ||
- | * [[http://interfaces.gams.com|Interfacing GAMS with other applications]] | + | * [[https://www.gams.com/latest/docs/UG_DataExchange.html|GAMS Data Exchange with other applications]] |
- | * [[http://www.gams.com/docs/excel/|GAMS/Excel Using GDX]] | + | * [[https://www.gams.com/latest/docs/UG_GDX.html|GAMS GDX facilities and tools]] |
- | * [[http://www.gams.com/dd/docs/tools/gdxutils.pdf|GAMS GDX facilities and tools]] | + | * [[https://www.gams.com/latest/docs/API_MAIN.html|GAMS Application Program Interfaces]] |
- | * [[http://www.gams.com/contrib/gbin/gbin.htm|GAMS Posix Utilities]] | + | * [[https://www.gams.com/latest/docs/T_POSIX.html|GAMS Posix Utilities]] |
- | * [[http://www.gams.com/dd/docs/tools/gdxmrw.pdf|GDXMRW: Interfacing GAMS and MATLAB]] | + | * [[https://www.gams.com/latest/docs/T_GDXMRW.html|GDXMRW: Interfacing GAMS and MATLAB]] |
* [[http://www.mpsge.org/inclib/tools.htm|GAMS Programming Utilities by Tom Rutherford]] | * [[http://www.mpsge.org/inclib/tools.htm|GAMS Programming Utilities by Tom Rutherford]] | ||
* [[http://agecon2.tamu.edu/people/faculty/mccarl-bruce/gamsmcc.htm|GAMS Tools by Bruce McCarl]] | * [[http://agecon2.tamu.edu/people/faculty/mccarl-bruce/gamsmcc.htm|GAMS Tools by Bruce McCarl]] | ||