ExcelHelperReadExcelT(Stream, Boolean, String) Method
讀取Excel文件並轉換為物件
Namespace: eBizprise.UtilityAssembly: eBizprise.Utility.ExcelHelper (in eBizprise.Utility.ExcelHelper.dll) Version: 25.0.1.0+9af286275430f5cdff066120a88db0d7edbaef7c
public static List<T> ReadExcel<T>(
Stream stream,
bool isOldVersion,
string sheetName
)
- stream Stream
- 資料流
- isOldVersion Boolean
- 是否為2003前舊版Excel
- sheetName String
- 頁籤名稱
- T
ListTList<T>
using (FileStream fileStream = new FileStream("ExcelHelperTest.xlsx", FileMode.Open))
{
List<Employee> employees = ExcelHelper.ReadExcel<Employee>(fileStream, false, "Sheet1");
// 其它作業
}
| Date | Version | Description |
|---|
| 2020/02/07 | 1.0.0.0 | 初版 |
| 2025/09/19 | 25.0.0.0 | 彙整2025年度初版 |