ByteScout Data Extraction Suite – VB.NET – Read xlsx (office 2007) files with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Read xlsx (office 2007) files with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VB-NET-Read-xlsx-(office-2007)-files-with-spreadsheet-sdk.pdf

How to read xlsx (office 2007) files with spreadsheet sdk in VB.NET and ByteScout Data Extraction Suite

Learning is essential in computer world and the tutorial below will demonstrate how to read xlsx (office 2007) files with spreadsheet sdk in VB.NET

Sample source code below will display you how to manage a complex task like read xlsx (office 2007) files with spreadsheet sdk in VB.NET. Want to read xlsx (office 2007) files with spreadsheet sdk in your VB.NET app? ByteScout Data Extraction Suite is designed for it. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.

Want to quickly learn? This fast application programming interfaces of ByteScout Data Extraction Suite for VB.NET plus the guidelines and the code below will help you quickly learn how to read xlsx (office 2007) files with spreadsheet sdk. IF you want to implement the functionality, just copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

Trial version of ByteScout Data Extraction Suite is available for free. Source code samples are included to help you with your VB.NET app.

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