ByteScout Data Extraction Suite – VB.NET – Read merged cells with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Read merged cells with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VB-NET-Read-merged-cells-with-spreadsheet-sdk.pdf

How to read merged cells with spreadsheet sdk in VB.NET using ByteScout Data Extraction Suite

Learning is essential in computer world and the tutorial below will demonstrate how to read merged cells with spreadsheet sdk in VB.NET

Every ByteScout tool includes simple example VB.NET source codes that you can get here or in the folder with installed ByteScout product. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK and you can use it to read merged cells with spreadsheet sdk with VB.NET.

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 merged cells with spreadsheet sdk. Follow the instructions from scratch to work and copy the VB.NET code. If you want to use these VB.NET sample examples in one or many applications then they can be used easily.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for VB.NET and other programming languages.

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("Input.xls")

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

        ' Read merged cell
        Dim cell As Cell = worksheet.Cell("C12").MergedWithCell

        ' Read cell value
        Console.WriteLine(cell.Value)

        ' Close document
        document.Close()

    End Sub

End Module