User Guide Tutorials VB6 tutorials How to merge cells in VB6
EasyXLS Excel library can be used to export Excel files in VB6. The library is a COM+ component that works without MS Excel installed.
Step 1: Download and install EasyXLS Excel Library for COM+
To download the trial version of EasyXLS Excel Library, press the below button:
If you already own a license key, you may
login and download EasyXLS from your account. Step 2: Verify if EasyXLS is registered
Check if EasyXLS component is present in Component Services.
Step 3: License file setup
Step required for EasyXLS v9.0 or later.
If you are using a trial, generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days. If you own a license key, you may login to the account that purchased the license and generate the license file from: https://www.easyxls.com/my-orders Setup the license file into your project using these guidelines. Step 4: Run VB6 code that merges cells in Excel sheet
Execute the following VB6 code that exports an Excel file with merge cells.
Begin VB.Form Form1
Caption = "Form1"
ClientHeight = 4590
ClientLeft = 60
ClientTop = 345
ClientWidth = 6885
LinkTopic = "Form1"
ScaleHeight = 4590
ScaleWidth = 6885
StartUpPosition = 3
Begin VB.Label Label1
AutoSize = -1
Height = 100
Left = 120
TabIndex = 0
Top = 120
Width = 100
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
Me.Label1.Caption = "Tutorial 10" & vbCrLf & "---------------" & vbCrLf
Set workbook = CreateObject( "EasyXLS.ExcelDocument")
workbook.easy_addWorksheet_2 ( "Sheet1")
Set xlsTable = workbook.easy_getSheet( "Sheet1").easy_getExcelTable()
xlsTable.easy_mergeCells_2 ( "A1:C3")
Me.Label1.Caption = Me.Label1.Caption & vbCrLf & _
"Writing file C:\Samples\Tutorial10 - merge cells in Excel.xlsx"
workbook.easy_WriteXLSXFile ( "C:\Samples\Tutorial10 - merge cells in Excel.xlsx")
If workbook.easy_getError() = "" Then
Me.Label1.Caption = Me.Label1.Caption & vbCrLf & "File successfully created."
Me.Label1.Caption = Me.Label1.Caption & vbCrLf & "Error: " & workbook.easy_getError()
Overloaded methods For methods with same name but different parameters, only the first method overload retains the original name. Subsequent overloads are uniquely renamed by appending to the method name '_2', '_3', etc (method, method_2, method_3), an integer that corresponds to the order of declaration that can be found in EasyXLS.h, a file that comes with EasyXLS installation.