public void Test_CanGenerate() { var testData = new List <TestClass> { new TestClass { name = "a", id = 1, amount = 12.20M }, new TestClass { name = "b", id = 2, amount = 2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M }, new TestClass { name = "c", id = 5, amount = 10.2M } }; var excel = new Workbook(ExcelType.XSSF); var book1 = excel.AddSheet <TestClass>("testSheet") .IsFreezeTitle(false); book1.AddColumn("固定值列") .Value("hhh") .HasCellType(CellType.String); book1.AddColumn("id列") .Value(i => i.id) .HasFormat("0"); book1.AddColumn("计算列") .Value(i => $"name: {i.name}, amount: {i.amount}") .HasWidth(20); book1.AddColumn("金额列") .Value(i => i.amount); book1.AddColumn("名称列") .Value(i => i.name) .HasIndex(1); book1.Fill(testData); var d = excel.Build(); using (Stream file = new FileStream(Path.Combine(Environment.CurrentDirectory, "test.xlsx"), FileMode.Create, FileAccess.Write)) { excel.Build().Write(file); } }