Home / Questions / 252684
Accepted
nachfren
Asked: 2020-04-09 08:58:52 +0800 CST 2020-04-09 08:58:52 +0800 CST

Hide sheet with Apache POI

  • 772

I read an excel with:

FileInputStream fis = new FileInputStream(new File("C:\\miPlantilla.xlsx"));

XSSFWorkbook workbook = new XSSFWorkbook (fis);
XSSFSheet sheet;
if(condicion) {
    sheet = workbook.getSheetAt(0);
} else {
    sheet = workbook.getSheetAt(1);//<-Uso otra hoja
}
XSSFRow row;
XSSFCell cell;

//Modifico datos.

Now what I try to hide one of the two sheets:

if(condicion) {
    workbook.setSheetHidden(0, true);
} else {
    workbook.setSheetHidden(1, true);
}

But it throws me the exception:

Caused by: java.lang.IllegalArgumentException: Sheet index (2) is out of range (0..1)

Does anyone know what I'm doing wrong?

java

1 Answers

  1. Best Answer

    In the end I needed to activate the other sheet so that it hides the sheet.

    if(condicion) {
    workbook.setActiveSheet(1);
    workbook.setSheetHidden(0, true);
} else {
    workbook.setActiveSheet(0);
    workbook.setSheetHidden(1, true);
}
    • 0