ByteScout Spreadsheet SDK – VB.NET – Read Merged Cells

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Read Merged Cells

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Read-Merged-Cells.pdf

How to read merged cells in VB.NET and ByteScout Spreadsheet SDK

This tutorial will show how to read merged cells in VB.NET

The coding tutorials are designed to help you test the features without need to write your own code. Want to read merged cells in your VB.NET app? ByteScout Spreadsheet SDK is designed for it. ByteScout Spreadsheet SDK is the SDK that can write and read, modify and calculate Excel and CSV spreadsheets. Most popular formulas are supported. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays.

VB.NET code samples for VB.NET developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. Just copy and paste the code into your VB.NET application’s code and follow the instruction. Enjoy writing a code with ready-to-use sample VB.NET codes.

You can download free trial version of ByteScout Spreadsheet SDK from our website to see and try many others source code samples for VB.NET.

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