Merge Cells in Column using OPEN XML

5.00/5 (1 vote)

See more:

Hi,

I have a List<row> which consists of rows in an excel sheet, using those rows I need to merge cells column wise.
For example, In List<row> I have A,B,C,D columns in each row and List<row> count is 26. I need to merge cells from A6 to A10 and A11 to A15.

I have tried in google also I couldn't get the solution. Please help me in getting a solution.

Posted 26-Jun-13 3:41am

sri4dotnet

Add a Solution

Comments

Member 9581488 26-Jun-13 16:17pm

http://msdn.microsoft.com/en-us/library/office/cc880096.aspx Please refer this link. It has mergeCell function. Might give you an idea

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Member 12760369	25
Herman<T>.Instance	20
Mircea Neacsu	10
spyke1	10
Dave Kreskowiak	10

Pete O'Hanlon	230
Richard Deeming	230
Richard MacCutchan	130
OriginalGriff	130
M-Badger	56

Merge Cells in Column using OPEN XML

Add your solution here

Preview 0

Merge Cells in Column using OPEN XML

Add your solution here

Preview 0

Existing Members

...or Join us