ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Developing an interface between gretl and Excel software

Simon Rupar (2012) Developing an interface between gretl and Excel software. EngD thesis.

Download (2429Kb)


    The main goal of the thesis was to connect the gretl econometric software package with the Microsoft's Excel electronic spreadsheet. By connecting these two applications, the functionality of Excel is extended by econometric and advanced statistical analyses. The aim of the thesis was to demonstrate that a connection between gretl and Excel is possible, and to find the most feasible way to implement it. The solution would enable the wide audience of Excel users to face econometrics and advanced statistics more easily. The thesis first briefly introduces econometrics and the gretl software. Next, the concept and development of application program interface is explained. The Wrapper concept and the Microsoft .NET framework are then described. The development of the Excel add-in, which implements the connection with gretl, is described in detail. The functionality of the pilot add-in is demonstrated. In the conclusion, possibilities for further development are outlined.

    Item Type: Thesis (EngD thesis)
    Keywords: »COM Interop«, »Wrapper«, »COM Interface«, ».NET Framework«, »API«, »Win32 API«, »CLR«, »CLI«, »P/Invoke«, »Microsoft Excel«, »Excel object model«, »Excel Add-in«
    Number of Pages: 55
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    prof. dr. Blaž Zupan106Mentor
    doc. dr. Gaj VidmarComentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=00009078100)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 1654
    Date Deposited: 02 Apr 2012 23:04
    Last Modified: 13 Apr 2012 16:48
    URI: http://eprints.fri.uni-lj.si/id/eprint/1654

    Actions (login required)

    View Item