使用 IronXL.Excel 在 C# 中讀取 Excel 檔案的最佳方法

class Program
{
    public static void Main(string[] args)
    {
        // Load an Excel workbook from file
        WorkBook workbook = WorkBook.Load("financial_report.xlsx");
        // Access the first worksheet by index
        WorkSheet worksheet = workbook.WorkSheets[0];
        // Or get a specific sheet by name
        WorkSheet dataSheet = workbook.GetWorkSheet("Expenses");
        Console.WriteLine($"Loaded workbook with {workbook.WorkSheets.Count} sheets");
    }
}

Option Strict On



Class Program
    Public Shared Sub Main(ByVal args As String())
        ' Load an Excel workbook from file
        Dim workbook As WorkBook = WorkBook.Load("financial_report.xlsx")
        ' Access the first worksheet by index
        Dim worksheet As WorkSheet = workbook.WorkSheets(0)
        ' Or get a specific sheet by name
        Dim dataSheet As WorkSheet = workbook.GetWorkSheet("Expenses")
        Console.WriteLine($"Loaded workbook with {workbook.WorkSheets.Count} sheets")
    End Sub
End Class

using IronXL;
using System;
WorkBook workbook = WorkBook.Load("Products.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Read individual cell values with type conversion
string productName = sheet["A2"].StringValue;
int quantity = sheet["B2"].IntValue;
decimal price = sheet["C2"].DecimalValue;
// Check for null or empty cells before processing
var cell = sheet["D2"];
if (cell.Value != null)
{
    Console.WriteLine($"Product: {productName}, Qty: {quantity}, Price: {price}");
}
// Access cells using row and column index (zero-based)
int columnIndex = 0;
var firstCell = sheet.Rows[1].Columns[columnIndex];

Imports IronXL
Imports System

Dim workbook As WorkBook = WorkBook.Load("Products.xlsx")
Dim sheet As WorkSheet = workbook.DefaultWorkSheet
' Read individual cell values with type conversion
Dim productName As String = sheet("A2").StringValue
Dim quantity As Integer = sheet("B2").IntValue
Dim price As Decimal = sheet("C2").DecimalValue
' Check for null or empty cells before processing
Dim cell = sheet("D2")
If cell.Value IsNot Nothing Then
    Console.WriteLine($"Product: {productName}, Qty: {quantity}, Price: {price}")
End If
' Access cells using row and column index (zero-based)
Dim columnIndex As Integer = 0
Dim firstCell = sheet.Rows(1).Columns(columnIndex)

using IronXL;
using System;
 WorkBook workbook = WorkBook.Load(@"financial_report.xlsx");
 WorkSheet sheet = workbook.WorkSheets[0];
 // Skip column headers in first row, process data rows
 foreach (var row in sheet["A2:D7"])
 {
     Console.WriteLine($"Cell {row.AddressString}: {row.Text}");
 }
 // Iterate through specific row range
 for (int i = 1; i < sheet.Rows.Length; i++)
 {
     var currentRow = sheet.Rows[i];
     // Access each column in the row
     foreach (var cell in currentRow)
     {
         if (cell.Value != null)
         {
             Console.Write($"{cell.StringValue}\t");
         }
     }
     Console.WriteLine();
 }

Imports IronXL
Imports System

Dim workbook As WorkBook = WorkBook.Load("financial_report.xlsx")
Dim sheet As WorkSheet = workbook.WorkSheets(0)

' Skip column headers in first row, process data rows
For Each row In sheet("A2:D7")
    Console.WriteLine($"Cell {row.AddressString}: {row.Text}")
Next

' Iterate through specific row range
For i As Integer = 1 To sheet.Rows.Length - 1
    Dim currentRow = sheet.Rows(i)
    ' Access each column in the row
    For Each cell In currentRow
        If cell.Value IsNot Nothing Then
            Console.Write($"{cell.StringValue}" & vbTab)
        End If
    Next
    Console.WriteLine()
Next

using IronXL;
// Load different format types - the API remains consistent
WorkBook xlsxBook = WorkBook.Load("Modern.xlsx");
WorkBook xlsBook = WorkBook.Load("Legacy.xls");
WorkBook csvBook = WorkBook.Load("Data.csv");
// All workbooks expose identical worksheet access
WorkSheet sheet1 = xlsxBook.DefaultWorkSheet;
WorkSheet sheet2 = xlsBook.DefaultWorkSheet;
WorkSheet sheet3 = csvBook.DefaultWorkSheet;
// Write to different formats
xlsxBook.SaveAs("Output.csv");
csvBook.SaveAs("Converted.xlsx");

Imports IronXL

' Load different format types - the API remains consistent
Dim xlsxBook As WorkBook = WorkBook.Load("Modern.xlsx")
Dim xlsBook As WorkBook = WorkBook.Load("Legacy.xls")
Dim csvBook As WorkBook = WorkBook.Load("Data.csv")

' All workbooks expose identical worksheet access
Dim sheet1 As WorkSheet = xlsxBook.DefaultWorkSheet
Dim sheet2 As WorkSheet = xlsBook.DefaultWorkSheet
Dim sheet3 As WorkSheet = csvBook.DefaultWorkSheet

' Write to different formats
xlsxBook.SaveAs("Output.csv")
csvBook.SaveAs("Converted.xlsx")

using IronXL;
using System;
using System.Linq;
WorkBook workbook = WorkBook.Load("Financials.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Calculate sum of values in a range
decimal totalSales = sheet["B2:B50"].Sum();
// Use LINQ for advanced queries
decimal maxValue = sheet["C2:C50"].Max(c => c.DecimalValue);
var highValues = sheet["C2:C50"].Where(c => c.DecimalValue > 1000);
// Create instance of calculated results
Console.WriteLine($"Total: {totalSales}, Maximum: {maxValue}");
// Modify and save changes
sheet["D2"].Value = totalSales;
workbook.Save();

Imports IronXL
Imports System
Imports System.Linq

Dim workbook As WorkBook = WorkBook.Load("Financials.xlsx")
Dim sheet As WorkSheet = workbook.DefaultWorkSheet
' Calculate sum of values in a range
Dim totalSales As Decimal = sheet("B2:B50").Sum()
' Use LINQ for advanced queries
Dim maxValue As Decimal = sheet("C2:C50").Max(Function(c) c.DecimalValue)
Dim highValues = sheet("C2:C50").Where(Function(c) c.DecimalValue > 1000)
' Create instance of calculated results
Console.WriteLine($"Total: {totalSales}, Maximum: {maxValue}")
' Modify and save changes
sheet("D2").Value = totalSales
workbook.Save()