Excel Formulae

As part of a work experience placement with BI:=AI (a Hong Kong based AI firm) I developed a system to convert customers' Excel spreadsheets into MySQL or JSON databases. This allows BI:=AI to perform their proprietary data analysis even on original spreadsheet-stored data.

The important part of the conversion is interpreting Excel formulae so that computed cells can still be accessed. By extending the functionality of the forumlas library, this is possible for the large majority of Excel formulae.

You can view this project on GitHub.