How to read a tree based xls using a Java API like Apache POI, etc. I want to read a xls which is in a tree based format i.e the data is grouped.
Asked
Active
Viewed 212 times
1

rkg
- 175
- 3
- 13
-
What happens if you just try to read it as normal? – Gagravarr Jan 18 '15 at 23:24
-
I want that xls to be treated as a tree. – rkg Jan 19 '15 at 03:32
-
It'd probably be best to post a small screenshot of some of the data you have, then describe the kind of Java datastructure you want, and finally what steps you've take so far to generate that – Gagravarr Jan 19 '15 at 10:41
-
@Gagravarr: Can you reply back now? – rkg Jan 22 '15 at 09:19
-
I'm still not seeing what's special about your case? Just read it by row, use the indent level in column A to decide when to nest, pop into your favourite tree-based datastructure in Java, job done! – Gagravarr Jan 22 '15 at 11:17