“ LoadFromCollection< T（IEnumerable< T&gt ;、布尔值，TableStyles，BindingFlags，MemberInfo []）的Epplus示例”

问题描述

使用Epplus ExcelPackage时，通常使用基本的 LoadFromCollection 函数填充工作表，如下所示：

  worksheet.Cells [1，1] .LoadFromCollection（Collection：data，PrintHeaders：true）; 
  

在

When using Epplus ExcelPackage, I typically use a basic LoadFromCollection function to populate a Worksheet, like in this manner:

worksheet.Cells[1, 1].LoadFromCollection(Collection:data, PrintHeaders:true);

On this site, I see the listing of other overloads of that function, but no specific examples. This one looks interesting. Can someone provide a basic example of this function overload in use?

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

I can see by clicking through the API that "TableStyles" is an enum that can be assigned like so:

TableStyles TableStyle = OfficeOpenXml.Table.TableStyles.Medium1;

The memberFlags and Members parameters remain a mystery to me.

解决方案

LoadFromCollection basically allow you to use Generics as the source Collection that implements IEnumerable<T> and the function will use the T type from that collection. So, say, a List of thingy objects can be consumed by it. Here is a thread that demonstrates it:

EPPlus - LoadFromCollection - Text converted to number

The collection datalist is

var datalist = new List<TestObject>();

is passed into the function

worksheet.Cells.LoadFromCollection(datalist);

As for the overloads, the longest one (the one you show) takes the MemberInfo's of the T object as the last parameter. If Members is null (via the other overloads) it simply does

Members = type.GetProperties(memberFlags);

where type is

var type = typeof(T);

You can supply your own but it is rarely necessary unless you are doing some very specific. The above memberFlags is the typical Public and Instance property types (again not usually necessary to supply your own).

If you want to get a better idea of this you can checkout the source doe here:

http://epplus.codeplex.com/SourceControl/latest#EPPlus/ExcelRangeBase.cs

RESPONSE TO COMMENTS

Here is a proper example relevant to the question:

public class TestObject
{
    public int Col1 { get; set; }
    public int Col2 { get; set; }
    public string Col3 { get; set; }
    public DateTime Col4 { get; set; }
}

[TestMethod]
public void LoadFromCollection_MemberList_Test()
{
    //https://stackoverflow.com/questions/32587834/epplus-loadfromcollection-text-converted-to-number/32590626#32590626

    var TestObjectList = new List<TestObject>();
    for (var i = 0; i < 10; i++)
        TestObjectList.Add(new TestObject {Col1 = i, Col2 = i*10, Col3 = (i*10) + "E4"});

    //Create a test file
    var fi = new FileInfo(@"c:\temp\LoadFromCollection_MemberList_Test.xlsx");
    if (fi.Exists)
        fi.Delete();

    using (var pck = new ExcelPackage(fi))
    {
        //Do NOT include Col1
        var mi = typeof (TestObject)
            .GetProperties()
            .Where(pi => pi.Name != "Col1")
            .Select(pi => (MemberInfo)pi)
            .ToArray();

        var worksheet = pck.Workbook.Worksheets.Add("Sheet1");
        worksheet.Cells.LoadFromCollection(
            TestObjectList
            , true
            , TableStyles.Dark1
            , BindingFlags.Public| BindingFlags.Instance
            , mi);

        pck.Save();
    }
}

Notice that Col1 is NOT in the output:

这篇关于“ LoadFromCollection< T（IEnumerable< T&gt ;、布尔值，TableStyles，BindingFlags，MemberInfo []）的Epplus示例”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！