使用 IRONXL

如何在 VB.NET 中打开 Excel 文件

已发布:九月 29, 2025

If you’ve ever tried opening Excel files in VB.NET, you know how tricky it can be without Microsoft Office installed. Traditional Interop methods rely on Excel itself, require complex COM references, and often cause version conflicts—especially on servers or cloud environments.

That’s where IronXL comes in. It’s a modern .NET library that lets you read XLSX, XLS, CSV, and TSV files directly, without requiring an Office installation. With IronXL, you can write cleaner, more reliable VB.NET code, process Excel files anywhere (Windows, Linux, or the cloud), and skip all the headaches of Interop. In this guide, we’ll show you how to get started and start working with Excel files effortlessly.

How do I install IronXL in my VB.NET project?

Getting started with IronXL takes just seconds. Open Visual Studio 2022, navigate to your VB.NET project, and use the Package Manager Console:

Install-Package IronXL.Excel

Alternatively, right-click your project, select "Manage NuGet Packages," search for "IronXL," and click Install.

How to Open an Excel File in VB.NET: Figure 1 - IronXL NuGet Installation

Once installed, add this single import statement to your VB.NET file:

Imports IronXL

Imports IronXL

VB .NET

That's it. No complex COM references, no Office dependencies, no version-specific assemblies. Your VB.NET Excel file reader is ready to work on any machine. For detailed setup instructions, check our VB.NET Excel files tutorial.

Simple Code Example: Reading an Excel Document with IronXL

Here's a complete working example to open an Excel workbook in VB.NET and read the data:

Imports IronXL
Module Program
    Sub Main()
        ' Load any Excel file - XLSX, XLS, CSV, or TSV
        Dim workbook As WorkBook = WorkBook.Load("example.xlsx")
        ' Access the worksheet with our sales data (the second sheet)
        Dim worksheet As WorkSheet = workbook.WorkSheets(1)
        ' Read a specific cell value
        Dim revenue As Decimal = worksheet("E2").DecimalValue
        Console.WriteLine($"Order Total: {revenue}")
        ' Read a range of cells
        For Each cell In worksheet("C2:C6")
            Console.WriteLine($"Product: {cell.Text}")
        Next
    End Sub
End Module

Imports IronXL
Module Program
    Sub Main()
        ' Load any Excel file - XLSX, XLS, CSV, or TSV
        Dim workbook As WorkBook = WorkBook.Load("example.xlsx")
        ' Access the worksheet with our sales data (the second sheet)
        Dim worksheet As WorkSheet = workbook.WorkSheets(1)
        ' Read a specific cell value
        Dim revenue As Decimal = worksheet("E2").DecimalValue
        Console.WriteLine($"Order Total: {revenue}")
        ' Read a range of cells
        For Each cell In worksheet("C2:C6")
            Console.WriteLine($"Product: {cell.Text}")
        Next
    End Sub
End Module

VB .NET

The WorkBook.The Load() method automatically detects the file format; there is no need to specify whether it is in XLS or XLSX format. Access Excel worksheets by index or file name using workbook.GetWorkSheet("Sheet1"). Each cell returns typed values through properties like IntValue, DecimalValue, DateTimeValue, or the universal Text property. For more complex scenarios, explore our Excel formulas documentation.

As you can see here, IronXL successfully opened the file and read the total of the order we requested it to read. It has also been able to read and extract information from each product sold across all orders.

How to Open an Excel File in VB.NET: Figure 2 - Sample output for reading Excel files

How can I read different types of Excel data?

IronXL handles all Excel data types intelligently when you read Excel VB.NET files. Here's how to work with various data scenarios:

' Open workbook from any location using the filename and path
Dim wb As WorkBook = WorkBook.Load("C:\Data\Inventory.xlsx")
Dim ws As WorkSheet = wb.GetWorkSheet("Products")
' Read different data types safely
Dim productName As String = ws("A2").StringValue
Dim quantity As Integer = ws("B2").IntValue  
Dim price As Decimal = ws("C2").DecimalValue
Dim lastUpdated As DateTime = ws("D2").DateTimeValue
' Process entire columns efficiently
Dim totalStock As Decimal = ws("B2:B100").Sum()
Dim maxPrice As Decimal = ws("C2:C100").Max()
' Iterate through all used cells starting at row index 1 to skip header (zero-based index)
 For i As Integer = 1 To ws.Rows.Count - 1
    Dim row = ws.Rows(i)
    ' Stop at first completely empty row
    If row.Columns(0).Value Is Nothing AndAlso row.Columns(1).Value Is Nothing AndAlso
       row.Columns(2).Value Is Nothing AndAlso row.Columns(3).Value Is Nothing Then Exit For
    ' Read values safely
    Dim sku As String = If(row.Columns(0).Value IsNot Nothing, row.Columns(0).StringValue, "")
    Dim stock As Integer = If(row.Columns(1).Value IsNot Nothing, row.Columns(1).IntValue, 0)
    Dim priceVal As Decimal = If(row.Columns(2).Value IsNot Nothing, row.Columns(2).DecimalValue, 0D)
    Dim rwLastUpdated As DateTime? = If(row.Columns(3).Value IsNot Nothing, row.Columns(3).DateTimeValue, Nothing)
    ' Format date
    Dim lastUpdatedStr As String = If(rwLastUpdated.HasValue, rwLastUpdated.Value.ToString("dd/MM/yyyy"), "")
    ' Print only rows with data
    If sku <> "" OrElse stock <> 0 OrElse priceVal <> 0D OrElse lastUpdatedStr <> "" Then
        Console.WriteLine($"SKU: {sku}, Stock: {stock}, Price: {priceVal:C}, Last Updated: {lastUpdatedStr}")
    End If
Next

' Open workbook from any location using the filename and path
Dim wb As WorkBook = WorkBook.Load("C:\Data\Inventory.xlsx")
Dim ws As WorkSheet = wb.GetWorkSheet("Products")
' Read different data types safely
Dim productName As String = ws("A2").StringValue
Dim quantity As Integer = ws("B2").IntValue  
Dim price As Decimal = ws("C2").DecimalValue
Dim lastUpdated As DateTime = ws("D2").DateTimeValue
' Process entire columns efficiently
Dim totalStock As Decimal = ws("B2:B100").Sum()
Dim maxPrice As Decimal = ws("C2:C100").Max()
' Iterate through all used cells starting at row index 1 to skip header (zero-based index)
 For i As Integer = 1 To ws.Rows.Count - 1
    Dim row = ws.Rows(i)
    ' Stop at first completely empty row
    If row.Columns(0).Value Is Nothing AndAlso row.Columns(1).Value Is Nothing AndAlso
       row.Columns(2).Value Is Nothing AndAlso row.Columns(3).Value Is Nothing Then Exit For
    ' Read values safely
    Dim sku As String = If(row.Columns(0).Value IsNot Nothing, row.Columns(0).StringValue, "")
    Dim stock As Integer = If(row.Columns(1).Value IsNot Nothing, row.Columns(1).IntValue, 0)
    Dim priceVal As Decimal = If(row.Columns(2).Value IsNot Nothing, row.Columns(2).DecimalValue, 0D)
    Dim rwLastUpdated As DateTime? = If(row.Columns(3).Value IsNot Nothing, row.Columns(3).DateTimeValue, Nothing)
    ' Format date
    Dim lastUpdatedStr As String = If(rwLastUpdated.HasValue, rwLastUpdated.Value.ToString("dd/MM/yyyy"), "")
    ' Print only rows with data
    If sku <> "" OrElse stock <> 0 OrElse priceVal <> 0D OrElse lastUpdatedStr <> "" Then
        Console.WriteLine($"SKU: {sku}, Stock: {stock}, Price: {priceVal:C}, Last Updated: {lastUpdatedStr}")
    End If
Next

VB .NET

IronXL automatically handles empty cells, merged cells, and formulas. The VB.NET Excel library recalculates formulas when you read them, ensuring you always get current values. For large datasets, use aggregate functions like Sum(), Average(), Min(), and Max() for optimal performance. Need to export data? Learn how to convert Excel to CSV.

How to Open an Excel File in VB.NET: Figure 3 - Reading and displaying data within the used cells

What's a practical example for production use?

Let's build a real inventory checker that processes multiple Excel sheets using VB.NET to open Excel files:

Imports IronXL
Imports System.IO
Public Class ExcelInventoryReader
    Public Function CheckLowStock(filePath As String) As List(Of String)
        Dim lowStockItems As New List(Of String)
        Try
            Dim workbook As WorkBook = WorkBook.Load(filePath)
            ' Process all worksheets in the workbook
            For Each sheet As WorkSheet In workbook.WorkSheets
                Console.WriteLine($"Checking {sheet.Name}...")
                ' Find items with stock below 10 units
                For rowIndex As Integer = 2 To sheet.RowCount
                    Dim itemName As String = sheet($"A{rowIndex}").StringValue
                    Dim stockLevel As Integer = sheet($"B{rowIndex}").IntValue
                    If stockLevel < 10 AndAlso Not String.IsNullOrEmpty(itemName) Then
                        lowStockItems.Add($"{itemName} - {stockLevel} units ({sheet.Name})")
                    End If
                Next
            Next
        Catch ex As Exception
            Console.WriteLine($"Error reading Excel file: {ex.Message}")
        End Try
        Return lowStockItems
    End Function
End Class

Imports IronXL
Imports System.IO
Public Class ExcelInventoryReader
    Public Function CheckLowStock(filePath As String) As List(Of String)
        Dim lowStockItems As New List(Of String)
        Try
            Dim workbook As WorkBook = WorkBook.Load(filePath)
            ' Process all worksheets in the workbook
            For Each sheet As WorkSheet In workbook.WorkSheets
                Console.WriteLine($"Checking {sheet.Name}...")
                ' Find items with stock below 10 units
                For rowIndex As Integer = 2 To sheet.RowCount
                    Dim itemName As String = sheet($"A{rowIndex}").StringValue
                    Dim stockLevel As Integer = sheet($"B{rowIndex}").IntValue
                    If stockLevel < 10 AndAlso Not String.IsNullOrEmpty(itemName) Then
                        lowStockItems.Add($"{itemName} - {stockLevel} units ({sheet.Name})")
                    End If
                Next
            Next
        Catch ex As Exception
            Console.WriteLine($"Error reading Excel file: {ex.Message}")
        End Try
        Return lowStockItems
    End Function
End Class

VB .NET

This production-ready VB.NET code demonstrates error handling, multi-sheet processing, and practical business logic. IronXL handles files up to 10MB efficiently in memory. For larger files, consider processing in chunks using specific range selections. Common issues, such as file permissions, are covered in our troubleshooting guides. For discussions about VB.NET Excel automation, the Microsoft Q&A forums provide community support.

Conclusion

With IronXL, reading and processing Excel files in VB.NET has never been easier — and you don’t need Microsoft Office installed. From safely reading multiple data types, iterating over large worksheets, handling formulas and empty cells, to processing multi-sheet workbooks, IronXL simplifies every aspect of Excel automation.

This modern .NET library eliminates Interop complexity, avoids version conflicts, and works seamlessly on Windows, Linux, and cloud environments. Whether you’re building a small inventory checker or processing enterprise-scale Excel data, IronXL provides reliable performance, concise code, and robust error handling.

Ready to streamline your VB.NET Excel workflows? Start your free IronXL trial today and experience a faster, cleaner, and fully Office-independent way to work with Excel files. Explore our documentation and tutorials to unlock the full power of IronXL in your applications.

立即开始使用 IronXL。