Merge/Split-Cells
Command Description
Merge or split the selected cell
Command Prototype
Excel.MergeRange(objExcelWorkBook,sheet,strCell,option,bSave)
Parameter Description
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| objExcelWorkBook | True | expression | objExcelWorkBook | Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel) or the workbook object returned by the command "Bind Excel" (Excel.BindBook)) |
| sheet | True | string | "Sheet1" | The string means sheet name. The number means sheet order(starting from 0) |
| strCell | True | string | "A1:B1" | Two forms of cell are supported: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). It is case-insensitive to use cell names |
| option | True | boolean | True | To merge or split the cell(s). True=merge; False = split |
| bSave | True | boolean | None | Save immediately after the operation |
Demo
/************************Merge or split cells********************** ************
**Input 1:
** objExcelWorkBook -- Excel workbook object (a workbook opened using the "Open Excel" command (Excel.OpenExcel) or a work bound using the "Bind Excel" command (Excel.BindBook) book object).
**Entry 2:
** sheet--If a string is used, it means the name of the specified worksheet; if a number is used, it means the order of the specified worksheet (starting from 0).
**Entry 3:
** strCell--Specified cell, supports two forms of cell name such as "A1" and row and column array such as [row number, column number]. When using the cell name, it is not case-sensitive.
**Entry 4:
** option--Merge cells or unmerge, select Yes to merge cells, select No to split cells. (boolean true/false)
**Entry 5:
** bSave--The operation is completed and saved immediately. (boolean true/false)
**
*********************************************************************/
objExcelWorkBook = Excel.OpenExcel(@res"Test.xlsx",True,"Excel","","")
Excel.MergeRange(objExcelWorkBook,"Sheet1","A20:B20",True,False)
TracePrint "Merge or split cells: cells A20 and B20 of Excel object Sheet1 worksheet are merged"
Excel.CloseExcel(objExcelWorkBook,True)