<< Click to Display Table of Contents >> Navigation:  Details > Gekcel

Gekcel is a component that makes it possible to run Gekko commands from within Microsoft Excel. Gekcel can also show Gekko results (for instance a print of a timeseries) in an Excel worksheet, and transfer data from an Excel worksheet back to Gekko. Among other things, Gekcel also makes it easy to interact with Gekko databanks (.gbk) from within Excel.

 

When using Gekcel, the Gekko main window is not shown at all, and Gekko is in that sense "hidden".

 

The Gekcel source code files are in a separate Visual Studio solution, and in a programming sense, Gekcel is not an integrated part of Gekko, since Gekko is compiled without knowledge of the existence of Gekcel. Therefore, it is Gekcel that uses Gekko (the Gekko project), not the other way around. And Gekcel basically only uses the Gekko "engine", not its graphical user interface.

 

Because of time restraints, and because Gekcel is only recently released (February 2021), Gekcel is not yet explained in depth in the current source code documentation. But the basic idea is that Gekko has some "hooks" that Gekcel can attach to, for instance the global Gekko variables Globals.excelDna, Globals.excelDna2, and Globals.excelDnaPath. As the names indicate, Gekcel uses an external component called Excel-DNA to make Excel capable of talking to a .NET program.

 

More info on Gekcel will be available here, when Gekcel and its source code has matured some more.

 

You can finde Gekcel on GitHub here.