Unable to understand how to merge cells in POI

I'm writing a program where I need to merge rows in Excel sheet. Currently, I'm able to merge the starting rows, but when coming to the end, I'm unable to know where it is going wrong. Below is my code. import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import ja

Unable to understand how to merge Rows in POI

Hi, I'm writing a program where I need to merge rows in Excel sheet. Currently, I'm able to merge the starting rows, but when coming to the end, I'm unable to know where it is going wrong. Below is my code. import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; impo

RE: Unable to understand how to merge Rows in POI

Thanks Sir , this worked -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-understand-how-to-merge-Rows-in-POI-tp5723107p5723119.html Sent from the POI - User mailing list archive at Nabble.com. -

confusion with merge using POI

I'm writing a program in POI to merge cells and I'm able to merge them. there is a column with number content, and when I merge this column and when I open my sheet and select this column to my surprise this shows the count and sum as if it is not merged. Below is my Excel.