I have above application which reads excel file and prints the content on the console. It is only printing sheet1. I have about 50 sheets. How to print all the 50 sheets on to console.
Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
What line of that code gets the first sheet from the workbook? How might it be changed to get, I dunno, the second worksheet from the workbook? What methods are available on the API to get the number of worksheets from a workbook?
Listen, I know you have a lot of questions, but as I told you before, 99% of them are answerable if you look at the POI API. There really is good documentation there.