I am reading data from Excel file.The columns in my worksheet contains merged cells. When I read data from merged cells which contains a value, I am getting the value only for first row of the merged region whereas for remaining rows I am getting 0 value.
For example:If my worksheet has a merge region :(A1:A2) with value 54575, Then when I retrieve both rows cells value value using XSSF row.getCell(0).getNumericCellValue(), for 1st row cell i get value as=54575 for 2nd row value=0; wheras what I require is that both 1st and 2nd row cell value should be 54575. Please suggest me some solution? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-in-reading-data-from-merged-cells-in-excel-using-XSSF-tp5512364p5512364.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
