ExcelHelperWriteExcelT(Stream, ListT) Method
將物件寫入Excel文件
Namespace: eBizprise.UtilityAssembly: eBizprise.Utility.ExcelHelper (in eBizprise.Utility.ExcelHelper.dll) Version: 25.0.1.0+9af286275430f5cdff066120a88db0d7edbaef7c
public static bool WriteExcel<T>(
Stream stream,
List<T> datas
)
- stream Stream
- 資料流
- datas ListT
- 資料
- T
- 物件
Booleanbool
List<Employee> writeEmployees = new List<Employee>();
writeEmployees.Add(new Employee() { Account = "TestAccount1", EffectiveDate = DateTime.Now, EmployeeId = Guid.NewGuid(), EmployeeNo = "99999" });
writeEmployees.Add(new Employee() { Account = "TestAccount2", EffectiveDate = DateTime.Now, EmployeeId = Guid.NewGuid(), EmployeeNo = "99998" });
using (FileStream fileStream = new FileStream("ExcelHelperTest.xlsx", FileMode.OpenOrCreate))
ExcelHelper.WriteExcel(fileStream, writeEmployees);
| Date | Version | Description |
|---|
| 2020/02/07 | 1.0.0.0 | 初版 |
| 2025/09/19 | 25.0.0.0 | 彙整2025年度初版 |