Horizontal & Veritcal Merging of Cells


#1

Does the Aspose Excel Component allow merging of cells in both horizontal and vertical direction? I saw the syntax for “Merge” function of Cells object in Aspose.Excel API Reference section. What do the integers 5,4,2,2 indicate in “cells.Merge(5, 4, 2, 2)”?
Thanks.


#2

Yes, Aspose.Excel supports merging of cells in both horizontal and vertical direction.

cell.Merge(5,4,2,2) means that you want to merge cell E6 to F7 as one cell. The first two parameters indicates the first cell E6 (row index and column index are zero based). The last two parameters indicates the number of rows and columns to be merged following the start cell.