Developing an interface between gretl and Excel software

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

Preview

Abstract

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:

Language of Content:

Slovenian

Mentor / Comentors:

Name and Surname	ID	Function
prof. dr. Blaž Zupan	106	Mentor
doc. dr. Gaj Vidmar		Comentor

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