<div>
This is a VBA function but should be easily transferable to VB.Net. It uses the FindFormat method to locate any merged cells in the specified worksheet and returns True or False depending on whether any are found.<br />
<br />

<pre><code id="code-20-41091507-1">Function ContainsMergedCells(ws As Worksheet) As Boolean
    Dim MergedCells As Range
    Application.FindFormat.MergeCells = True
    Set MergedCells = ws.Cells.Find(What:=&quot;&quot;, SearchFormat:=True)
    If MergedCells Is Nothing Then
        ContainsMergedCells = False
    Else
        ContainsMergedCells = True
    End If
End Function</code></pre>
</div>


This is a VBA function but should be easily transferable to VB.Net. It uses the FindFormat method to locate any merged cells in the specified worksheet and returns True or False depending on whether any are found.



Function ContainsMergedCells(ws As Worksheet) As Boolean
    Dim MergedCells As Range
    Application.FindFormat.MergeCells = True
    Set MergedCells = ws.Cells.Find(What:="", SearchFormat:=True)
    If MergedCells Is Nothing Then
        ContainsMergedCells = False
    Else
        ContainsMergedCells = True
    End If
End Function

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to make sure a spreadsheet that I want to import into a database does not contain any merged cells within a specified area. Is there a way to identify merged cells using VB.Net?
</div>
</div>


Hello,

I'm trying to make sure a spreadsheet that I want to import into a database does not contain any merged cells within a specified area. Is there a way to identify merged cells using VB.Net?

How can I use VB.Net to identify merged cells within an xlsx file?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.