This project has moved and is read-only. For the latest updates, please go here.

How do I use EPPlus? Poor documentation!

Jan 6, 2013 at 3:52 AM

I'm new to C# and I'm trying to write a windows form project, where I am creating a log book of running (jogging) "start time" and "stop time", subtract the difference and tell me the "total run time"...  all of this works... I am looking for help! I want to hit the save button and utilize EPPlus to write the three textbox.text information to an excel file. After the file is written after the first time... obviously I don't want to create a file again, just add the next entries just below the last entry and so on...

 

Any advice would be greatly appreciated!

Jan 8, 2013 at 1:30 PM
Edited Jan 8, 2013 at 1:32 PM

This is basic programming, and nothing to do with EPPluss documentation.  Epplus is pretty easy to use and doesn't need much more documentation than the examples, especially if you are used to Excel COM.

When creating the fileinfo object to pass into the package object, do something like this.

using(var fi = File.Open(myfile, FileMode.OpenOrCreate))

{

      using(var package = new ExcelPackage(fi))

    {
    } 

}