当使用LoadFromCollection时,我遇到了“列超出范围”的错误-以下是代码。插入到EPPlus附带的SampleApp中以复制。
我做错了什么,还是这是一个错误?或者是我没有设置的配置设置?
public class tst
{
public string Name;
[Description("Created Time")]
public DateTime Created_time;
}
var pck = new ExcelPackage();
var kpcollection = new List<tst>();
for (var i = 1; i <= 10; i++)
{
kpcollection.Add(new tst
{
Name = "line" + i.ToString(),
Created_time = DateTime.Now
});
}
var wsenum = pck.Workbook.Worksheets.Add("KPTest");
//Load the collection starting from cell A1...
wsenum.Cells["A1"].LoadFromCollection(kpcollection, true, TableStyles.Medium9);