ByteScout Spreadsheet SDK – VB.NET – Read XLSX (Office 2007) Files

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Read XLSX (Office 2007) Files

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Read-XLSX-(Office-2007)-Files.pdf

How to read XLSX (office 2007) files in VB.NET with ByteScout Spreadsheet SDK

How to code in VB.NET to read XLSX (office 2007) files with this step-by-step tutorial

Read XLSX (office 2007) files is easy to implement in VB.NET if you use these source codes below. What is ByteScout Spreadsheet SDK? It is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays. It can help you to read XLSX (office 2007) files in your VB.NET application.

VB.NET code samples for VB.NET developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. This VB.NET sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Use of ByteScout Spreadsheet SDK in VB.NET is also explained in the documentation included along with the product.

Free trial version of ByteScout Spreadsheet SDK is available on our website. Documentation and source code samples are included.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Module1.vb

      Imports Bytescout.Spreadsheet
Imports System.IO

Module Module1

    Sub Main()
        ' Create new Spreadsheet
        Dim document As New Spreadsheet()
        document.LoadFromFile("Hello_world.xlsx")

        ' Get worksheet
        Dim worksheet As Worksheet = document.Workbook.Worksheets.ByName("Sheet1")

        ' Read cell value
        Console.WriteLine("Cell (0,0) value: {0}", worksheet.Cell(0, 0).Value)

        ' Write message
        Console.Write("Press any key to continue...")

        ' Wait user input
        Console.ReadKey()
    End Sub

End Module