export to Excel from a list with EPPLUS

by

What version of EPPlus are you using? I ask because I am surprised it does not throw an error as it does with 4.1.0 which is currently the latest. Maybe an older version is more forgiving.

But to answer you question, if you look at the signature of the final overload of LoadFromCollection that is eventually called you will see this:

public ExcelRangeBase LoadFromCollection<T>(IEnumerable<T> Collection, bool PrintHeaders, TableStyles TableStyle, BindingFlags memberFlags, MemberInfo[] Members)

Notice that Epplus is only looking at MemberInfos and not a Fields which is what you object is using. If you change Stock object to this:

class Stock
{
    public string Nif { get; set; }
    public string Proveedor { get; set; }
    public string Coodigo { get; set; }
    public string descripcion { get; set; }
    public string Catalogo { get; set; }
    public string Estadistico { get; set; }
    public decimal StockOn { get; set; }
}

You should see results.

More Related Contents:

  1. Format excel column to decimal doing export from c#
  2. Export DataTable to Excel with EPPlus
  3. Excel to DataTable using EPPlus – excel locked for editing
  4. C# create/modify/read .xlsx files
  5. EPPlus number format
  6. EPPlus Large Dataset Issue with Out of Memory Exception
  7. EPPlus – LoadFromCollection – Text converted to number
  8. I want to insert a record in DB and then need to return a row
  9. How to detect installed version of MS-Office?
  10. Excel Interop – Efficiency and performance
  11. Adding items to a LIST of objects results in duplicate Objects when using a NEW in a Loop
  12. Is there a performance impact when calling ToList()?
  13. Is it worthwhile to initialize the collection size of a List if it’s size reasonably known?
  14. How can I find a specific element in a List?
  15. Fastest way to interface between live (unsaved) Excel data and C# objects
  16. Get list of threads
  17. How to pass User Defined Table Type as Stored Procedured parameter in C#
  18. Adding images into Excel using EPPlus
  19. Compare two Lists for differences
  20. How to read single Excel cell value
  21. Get instance of Excel application with C# by Handle
  22. LINQ to find series of consecutive numbers
  23. convert List to IList
  24. List size limitation in C#
  25. how to check if List element contains an item with a Particular Property Value
  26. Cast IList to List
  27. openxml spreadsheat save-as
  28. Scientific notation when importing from Excel in .Net
  29. Accessing an open Excel Workbook in C#
  30. Import Excel to Datagridview

Leave a Comment