ExcelHelperWriteExcelT(Stream, ListT) Method

將物件寫入Excel文件

Definition

Namespace: eBizprise.Utility
Assembly: eBizprise.Utility.ExcelHelper (in eBizprise.Utility.ExcelHelper.dll) Version: 25.0.1.0+9af286275430f5cdff066120a88db0d7edbaef7c
C#
public static bool WriteExcel<T>(
	Stream stream,
	List<T> datas
)

Parameters

stream  Stream
資料流
datas  ListT
資料

Type Parameters

T
物件

Return Value

Boolean
bool

Example

C#
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);

Revision History

DateVersionDescription
2020/02/071.0.0.0初版
2025/09/1925.0.0.0彙整2025年度初版

See Also