ExcelExtendReadExcelT(Stream, Boolean, String) Method

讀取Excel文件並轉換為物件

Definition

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

Parameters

stream  Stream
資料流
isOldVersion  Boolean
是否為2003前舊版Excel
sheetName  String
頁籤名稱

Type Parameters

T

Return Value

ListT
List<T>

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type Stream. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Example

C#
using (FileStream fileStream = new FileStream("ExcelHelperTest.xlsx", FileMode.Open))
{
    List<Employee> employees = fileStream.ReadExcel<Employee>(false, "Sheet1");

    // 其它作業
}

Revision History

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

See Also