Hi In my project I have to parse a xlsm file which contains more than 1 million rows (separated in multiple sheets each containing 1 million rows at maximum), and do some validations on the cells.
I've tried so many examples provided by Apache POI and StackOverFlow but still couldn't manage to find a proper way to parse starting the first row/cell to the last one. P.S: I need the blank cells to be also included in the parsing section. I used *FromHowTo * example but using sharedStringsData is ignores the blank cells. If I want to open the file normal way I will definitely have a memory issue. Any help is highly appreciated. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-xlsm-file-with-more-than-1-millions-of-rows-tp5722413.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
