This is the 10th model in a series of tutorial examples. More...

#include "gams.h"
#include <iostream>
#include <vector>
#include <QAxObject>
#include <Windows.h>

Functions
GAMSParameter	sheetToParameter (QAxObject *sheets, string sheetName, GAMSDatabase db, string paramName, string paramText, GAMSSet set)

GAMSParameter	sheetToParameter (QAxObject *sheets, string sheetName, GAMSDatabase db, string paramName, string paramText, GAMSSet set1, GAMSSet set2)

Detailed Description

This is the 10th model in a series of tutorial examples.

Here we show:

How to fill a GAMSDatabase by reading from MS Excel

Definition in file transport10.cpp.

Function Documentation

◆ sheetToParameter() [1/2]

GAMSParameter sheetToParameter	(	QAxObject *	sheets,
		string	sheetName,
		GAMSDatabase	db,
		string	paramName,
		string	paramText,
		GAMSSet	set
	)

Creates an 1 dimensional GAMSParameter and transfers data from an Excel sheet (horizontal ordered)

Parameters

sheets	The sheets object of an open Excel workbook
sheetName	The name of the sheet to be read
db	The GAMSDatabase where the GAMSParameter is created in
paramName	The name of the new GAMSParameter
paramText	The explplanatory text of the new GAMSParameter
set	The GAMSSet for GAMSParameter dimension

Returns: The new GAMSParameter in the GAMSDatabase

Definition at line 105 of file transport10.cpp.

{
     QAxObject* sheet = sheets->querySubObject( "Item( string )", sheetName.c_str() );
     GAMSParameter param = db.addParameter(paramName, paramText, set);
  
     QAxObject* usedrange = sheet->querySubObject( "UsedRange");
     QAxObject * columns = usedrange->querySubObject("Columns");
     int intCols = columns->property("Count").toInt();
  
     for (int i = 1; i <= intCols; i++) {
         std::string name = sheet->querySubObject("Cells( int, int )", 1, i)->dynamicCall("Value()").toString().toStdString();
         double value = sheet->querySubObject("Cells( int, int )", 2, i)->dynamicCall("Value()").toDouble();
         set.addRecord(name);
         GAMSParameterRecord rec = param.addRecord(name);
         rec.setValue(value);
     }
     return param;
 }

◆ sheetToParameter() [2/2]

GAMSParameter sheetToParameter	(	QAxObject *	sheets,
		string	sheetName,
		GAMSDatabase	db,
		string	paramName,
		string	paramText,
		GAMSSet	set1,
		GAMSSet	set2
	)

Creates a 2 dimensional GAMSParameter and transfers data from an Excel sheet

Parameters

sheets	The sheets object of an open Excel workbook
sheetName	The name of the sheet to be read
db	The GAMSDatabase where the GAMSParameter is created in
paramName	The name of the new GAMSParameter
paramText	The explplanatory text of the new GAMSParameter
set1	The GAMSSet for first GAMSParameter dimension
set2	The GAMSSet for second GAMSParameter dimension

Returns: The new GAMSParameter in the GAMSDatabase

Definition at line 136 of file transport10.cpp.

{
     QAxObject* sheet = sheets->querySubObject( "Item( string )", sheetName.c_str() );
     vector<GAMSDomain> sets {set1, set2};
     GAMSParameter param = db.addParameter(paramName, paramText, sets);
  
     QAxObject* usedrange = sheet->querySubObject( "UsedRange");
     QAxObject * columns = usedrange->querySubObject("Columns");
     int intCols = columns->property("Count").toInt();
     QAxObject * rows = usedrange->querySubObject("Rows");
     int intRows = rows->property("Count").toInt();
  
     for (int j = 2; j <= intCols; j++) {
         string namej = sheet->querySubObject("Cells( int, int )", 1, j)->dynamicCall("Value()").toString().toStdString();
         for (int i = 2; i <= intRows; ++i) {
             string namei = sheet->querySubObject("Cells( int, int )", i, 1)->dynamicCall("Value()").toString().toStdString();
             GAMSParameterRecord rec = param.addRecord(namei, namej);
             double value = sheet->querySubObject("Cells( int, int )", i, j)->dynamicCall("Value()").toDouble();
             rec.setValue(value);
         }
     }
     return param;
 }

Functions

Detailed Description

Function Documentation

◆ sheetToParameter() [1/2]

◆ sheetToParameter() [2/2]