how to count no.of sheets in excel through POI jar as well as through Java?

View Latest Questions and Answers|Ask Questions?|Tutorials

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

Login

QuestionAsk Questions?

Mallesham

how to count no.of sheets in excel through POI jar as well as through Java?
2 Answer(s) 2 years and 2 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.

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 Pages:

how to count no.of sheets in excel through POI jar as well as through Java?

about java1

how to read data from excel file through browse and insert into oracle database using jsp or oracle???

counting identifiers,no.of inputs and outputs - Java Magazine

Creating Excel sheets - Java Beginners

Create and Save Excel File in JSP

How to Create Excel Page Using JSP

Access Excel file through JDBC

How to use Apache POI?

Drawing a Shape in Excel Sheet

Delete row and column from table through java code

Java through Exel - Java Beginners

Error in POI - Java Beginners

Hi.. how to write more than one sheets in a excel file... pls anybody help me....

Create Excel(.xlsx) document using Apache POI

Read Excel(.xlsx) document using Apache POI

Overview of Networking through JAVA

Overview of Networking through JAVA

Overview of Networking through JAVA

java.lang.NoClassDefFoundError: javax/transaction/UserTransaction????? - Struts

jar file

javac complier not found - JSP-Servlet

Overview of Networking through JAVA

javaa swings - IDE Questions

Create Simple Excel(.xls) document using Apache POI

Apache POI Excel creation - Development process

Apache POI Excel Maximum Row - JSP-Servlet

Read Simple Excel(.xls) document using Apache POI

How to Create New Excel Sheet Using JSP

Excel Created using POI and HSSF - Development process

Java Count Vowels

Convert the excel sheet data into oracle table through java or jsp

create folders and sub folders based on excel data

difference between java5 and java6 - Java Beginners

How to set background of an excel sheet using POI - Java Magazine

html5 through escenic cms

javas - JSP-Servlet

how to store the REsult Set values in array and loop through it in java?

how to store the REsult Set values in array and loop through it in java?

how to connect the database using hibernet through servlet/jsp through form

excel

Java sdk/java poi hssf code to creat excel with folder structure,( i,e folders, subfolders and childrens )

database through jsp

Java2

Creating a JAR file in Java

run a batch file through javascript

Need to remove duplicated rows from excel using apache POI API

How we can create a table through procedure ?

how to connect two databse through HibernateFramework

Overview of Networking through JAVA,How to retrieve URL information

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics