Obtaining the index of a specific sheet "Sheet_name" using jxl

Question

Is there a way to get the index of a specific sheet "Sheet_name" using jxl?

And what does the getSheet(String name) function of jxl library do?

Thanks in advance.

Answer 1

Nope, there isn't.

A very simple solution would be:

final String sheetName = "somesheet";
Integer index = null;
final Sheet[] sheets = workbook.getSheets();            
for(int i=0;i<sheets.length && index == null; i++) {
    if(sheets[i].getName().equals(sheetName)) {
        index = i;                  
    }
}