How to get the position/index of a Sheet object in Java Apache POI

java apache apache-poi xssf
Saikat picture Saikat · Mar 18, 2017 · Viewed 8.4k times · Source

In a Java method I am using an Apache POI Sheet (from XSSFWorkbook). I can read the sheet name using getSheetName() method. But is there any way to find the sheet position in the workbook. I don't see any methods like getSheetIndex() in the Sheet interface.

Answer

user5741800 picture user5741800 · Mar 18, 2017

Not in Sheet interface but Workbook has one method to do that :

Workbook.getSheetIndex(String name);

Related questions

Apache POI error loading XSSFWorkbook class

I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my requirements. I'm attempting to move to XSSF, but I keep getting errors when trying to use it. I managed to …

Read More
Apache POI XSSF reading in excel files

I just have a quick question about how to read in an xlsx file using the XSSF format from Apache. Right now my code looks like this: InputStream fs = new FileInputStream(filename); // (1) XSSFWorkbook wb = new XSSFWorkbook(fs); // (2) XSSFSheet sheet = wb.…

Read More
Apache POI, using both XSSF and HSSF

I have a problem with Apache POI project. I failed to use XSSF and HSSF in the "Same Java Class". Which jar should I download or which artifact should I get add into maven? I want to handle both xls …

Read More