Add ReadMe_UpdatingEPPlus.txt
diff --git a/ReadMe_UpdatingEPPlus.txt b/ReadMe_UpdatingEPPlus.txt new file mode 100644 index 0000000..1c7524d --- /dev/null +++ b/ReadMe_UpdatingEPPlus.txt
@@ -0,0 +1,33 @@ + +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. +5. Build the EPPlus solution. +6. Copy the EPPlus.dll and EPPlus.pdb files 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 and EPPlus.pdb files. +9. "git Commit" and "git push" the changes to EPPlus.dll and EPPlus.pdb.