How To Merge Two Columns In Excel Using Java

For what you were trying to do this should work.

How to merge two columns in excel using java. Sheetaddmergedregionnew cellrangeaddressrowno rowno 0 3. Apache poi merging cells example. If you want to merge cells one above another keep column indexes same. In our case to be merged.

If your data starts from 1 st row you need to replace 2 with 1 press enter. We have so far seen how to merge data across columns and how to merge data across rows in excel using java apache poi library. In above sheet real data starts from 2 nd row a2b2c2. The constructor of cellrangeaddress takes 4 params cellrangeaddress int firstrow int lastrow int firstcol int lastcol.

In this case the existing columns that are merged are available alongside the new merged column in the query table. Indexes are zero based. In this tutorial we will discuss how to place your cell data by merging it across rows and columns in poi with examples. To do so it provides methods which takes cell indexes as argument and merge the cells into a single large cell.

In the following example we are creating two cells and merging them into a single cell. To merge column values by inserting a custom column. Type a2b2c2 shows that in above screenshot. If you want to merge cells which are in a single row keep the row indexes same.

Click on e2 cell. You need to merge a2b2 c2 cells. Right click a column header and select change type text. I am going to combine these three columns in to one column column e.

In query editor ensure that the columns that you want to merge are of text data type. We will cover both xls and xlsx version in the final part of this merge discussion series. Cellrangeaddress is the range of the rows and columns that need to be selected. Apache poi merging cells.