Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners how to count no.of sheets in excel through POI jar as well as through Java?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Mallesham
how to count no.of sheets in excel through POI jar as well as through Java?
2 Answer(s)      3 years and 9 months ago
Posted in : Java Beginners


I have an excel file, it contains 'n' no.of sheets(the no.of sheets will be dynamic ) .I want to read all sheets one by one in java by using POI jar. I am able to read one sheet at a time by using POI jar(workbook.getSheetAt(0)). But I am not able to read multiple sheets one by one. Could you please let me know the method to count the no.of sheets in excel through POI jar or else java.


Advertisement
View Answers

April 2, 2011 at 10:34 AM


Use the method getNumberOfSheets()of HSSFWorkBook class to count the number of sheets in an excel file.



April 4, 2011 at 2:32 PM


thank you Deepak....



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com