
How to Update EPPlus
====================

We use the EPPlus library to read MS Office Open XML (OOXML) files. 
This includes both MS Excel files and Google Sheets exported in MS Office Open XML format.
We do this both when the user "adds" a new Excel or Google worksheet through the Editor, and when the user "regenerates" a table in the Editor.
Using EPPlus allows us to use the same complex "type inference" code for both Excel and Google Sheets.
When a Google Sheet is being used, we ask Google Sheets to export the workbook and all of its worksheets as an Excel document.

We obtained the EPPlus library from http://epplus.codeplex.com/ .

The source code for EPPlus is checked in to Git. 
It is located in folder GitHub\EPPlus.
 
The branches are described here https://github.com/afader/EPPlus

The following branches are present:
1.	Official – The EPPlus source code we are currently using as the base source code.
2.	AppSheet – The Official version with our changes applied.
3.	MergeEPPlus20160719 – The EPPlus source code from 07/19/2016 with our changes applied.

To change EPPlus, do the following:

1.	CD to folder GitHub\EPPlus.
2.	Use Git to checkout branch AppSheet.
3.	Change the appropriate source code files.
4.	Checkin the changes to Git. Use the git push command: "git push origin HEAD:refs/for/main"
5.	Build the EPPlus solution using Visual Studio 2017.
6.	Copy the EPPlus.dll file produced by the build from folder Documents\GitHub\EPPlus\EPPlus\bin\Debug to folder Documents\GitHub\Jeenee\lib.
7.	CD to folder Documents\GitHub\Jeenee.
8.	"git add" the EPPlus.dll file.
9.	"git Commit" and "git push" the changes to EPPlus.dll.