How to know number of sheets in a workbook?

java excel apache-poi poi-hssf vba
Supereme picture Supereme · Jan 16, 2010 · Viewed 21.2k times · Source

I'm using hssf api for reading data from xls files. But is there any way to get the exact no. of sheets in a workbook containing stored data?

Answer

Narayan picture Narayan · Jan 16, 2010

What does getNumberOfSheets return you?

Related questions

How to get row count in an Excel file using POI library?

Guys I'm currently using the POI 3.9 library to work with excel files. I know of the getLastRowNum() function, which returns a number of rows in an Excel file. The only problem is getLastRowNum() returns a number with the count starting …

Read More
How to insert a row between two rows in an existing excel with HSSF (Apache POI)

Somehow I manage to create new rows between two rows in an existing excel file. The problem is, some of the formatting were not include along the shifting of the rows. One of this, is the row that are hide …

Read More
Java POI: How to find an Excel cell with a string value and get its position (row) to use that position to find another cell

I'm looking for a cell in a spreadsheet that has the string 'Total' and then use the row in which that cell is to find the total value in another cell which is always the same cell/column (the 10th …

Read More