無需 Interop 即可載入 Excel 檔案

VBC#

using IronXL;
using System;
using System.Linq;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];

// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;

// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;

// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();

// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

Imports IronXL
Imports System
Imports System.Linq

' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Select worksheet at index 0
Dim workSheet As WorkSheet = workBook.WorkSheets(0)

' Get any existing worksheet
Dim firstSheet As WorkSheet = workBook.DefaultWorkSheet

' Select a cell and return the converted value
Dim cellValue As Integer = workSheet("A2").IntValue

' Read from ranges of cells elegantly.
For Each cell In workSheet("A2:A10")
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next

' Calculate aggregate values such as Min, Max and Sum
Dim sum As Decimal = workSheet("A2:A10").Sum()

' Linq compatible
Dim max As Decimal = workSheet("A2:A10").Max(Function(c) c.DecimalValue)

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

無需 Interop 即可載入 Excel 檔案

IronXL中的Load功能使您能輕鬆載入和操作各種格式（XLSX、XLS、CSV等）的現有Excel文件。通過載入WorkSheets和資料，從而使您可以提取數值、遍歷單元格範圍，並進行如求和或最大值等計算。您可以存取特定單元格，將其值轉換為適當的資料型別（例如整數、小數），甚至可以使用LINQ進行高級資料操作。此功能簡化了在.NET中處理Excel資料的過程，使其成為資料分析、報告生成和自動化等任務的理想選擇。