Hi Guys, I have xls spreed sheet with about 500-600 rows in a table (table has three columns). I need to extract value from the 2nd column on each row and at the same time to keep track of current page number. So, as result I want to get hashmap<String, Integer>, where key represents cell value and Integer represents page number where this cell is located.
Unfortunatly, I can't find some standard methods in API to get page number during cells parsing. One possible solution that I found is to cut all sheet into pages and count the number of page breaks and use it further in order to split all rows into ranges and than iterate through them range by range...so, I did it, but it's too complicated...may be there is should be more right way? Thanks! -- Cheers, Nikita.
