ExcelHelperWriteExcelT(Stream, ListT, String, Boolean, Boolean) 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,
	string sheetName,
	bool isOldVersion,
	bool includeHeader
)

Parameters

stream  Stream
資料流
datas  ListT
資料
sheetName  String
頁籤名稱
isOldVersion  Boolean
是否為2003前舊版Excel
includeHeader  Boolean
是否包含標題列

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, "Sheet1", false, true);

Revision History

DateVersionDescription
2020/02/071.0.0.0初版
2025/08/062.2.5.0調整寫入Excel時的欄位樣式
2025/09/1925.0.0.0彙整2025年度初版

See Also