0

I need to extract data from an Excel sheet in Java which is generally not a problem. I have a special case for which I couldn't find a good page.

I have a single value, yet this value is in 4 rows. For example, value = 25, but A1, A2, A3 and A4 together display that value.

The Apache POI version is 3.6. I couldn't find a good method to do this. Could someone someone point me in the right direction. Obviously row.hasNext() will not work in this.

Is there a method or an approach?

centic
  • 15,565
  • 9
  • 68
  • 125
user3210297
  • 1
  • 2
  • 6
    Do you mean you have a merged cell? if so, just read A1 –  Nov 18 '15 at 16:47
  • Maybe related: http://stackoverflow.com/questions/29664977/how-to-read-from-merged-cells-of-excel-in-java-using-apache-poi –  Nov 18 '15 at 16:48

1 Answers1

1

For merged cells, the value is stored in the top left cell.

For example, if the cells A1, A2, B1 and B2 are merged, the value is present in the cell A1.

winklerrr
  • 13,026
  • 8
  • 71
  • 88