Thesis reads Excel files and builds a graph-based model to generate structured code from the procedures contained in each cell's formula. Right now, generating code in C# is supported. This project is written in C# / WPF.
Features include:
- "Intelligent" variable name generation from labels positioned inside the spreadsheet
- Support for empty cells
- Partial support for expressions that are not type-safe
- Ranges (such as A1:C3)
- Names
- References to other worksheets
- Functions
- Arithmetic: SUM, MIN, MAX, COUNT, AVERAGE, ROUND, ROUNDUP, ROUNDDOWN
- Logical: IF, NOT, AND, OR, XOR
- Reference: VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX
- The code is structured in a way that makes implementation of other functions easy.
This application was created as part of a Bachelor's thesis at the Technical University of Munich. It is not in active development anymore.
The thesis is included in the file Thesis.pdf and includes the ideas behind this project and some implementation details.
I recommend using Visual Studio and NuGet.
- .NET Framework >= 4.7.2
- Windows 7 or higher (for WPF)
This project uses proprietary components by Syncfusion:
- SfSpreadsheet is used to load, display and retrieve data from Excel spreadsheets.
- SfDiagram is used to draw the spreadsheet as a graph.
To use those components for free, you can potentially obtain a Community license, which as of now is eligible for companies and individuals with less than $1 million USD in annual gross revenue and 5 or fewer developers.
Once you have obtained a license key, put it inside the Resources/SyncfusionLicenseKey.txt file.
- Clone the project.
- Load the required packages via NuGet.
- Put your license inside the
Resources/SyncfusionLicenseKey.txtfile. Do not commit this file! - Ready!
This project is licensed under the GNU General Public License, Version 3. See the LICENSE file for more details.
Components used include:
- AvalonEdit, a text box with syntax highlighting (MIT License)
- Costura.Fody, to include all libraries into the output .exe (MIT License)
- FontAwesome, for the button icons (CC BY 4.0 / MIT License)
- MahApps.Metro, a WPF UI toolkit (MIT License)
- Roslyn, for automated testing (Apache License 2.0)
- XLParser, an Excel formula parser (Mozilla Public License 2.0)
The icon was made by Freepik from www.flaticon.com.
There is a second branch "ObjectOrientedApproach", which is an implementation of the Object-Oriented Approach as described in the thesis. It has since been superseded by the Function-based Approach, which is now the Master branch.
The Object-Oriented Approach contains an automated tester, which tests the generated code against the actual values as evaluated by the spreadsheet's formula engine (using the Roslyn Scripting API). This has not been implemented for the Master branch yet.