2
I’m creating a method to hide the elements that are zeroed out from an excel file, but the problem that it can’t catch the values when the column is a formula. How can I get these values?
My code:
private static ByteArrayOutputStream ocultarZerados(ByteArrayOutputStream arquivo) throws Exception
{
    InputStream arquivoExcel = new ByteArrayInputStream(arquivo.toByteArray());
    XSSFWorkbook wb = new XSSFWorkbook(arquivoExcel);
    XSSFSheet s = (XSSFSheet) wb.getSheetAt(1);
    for (Row linha : s)
    {
        System.out.println("===================");
        for (Cell coluna : linha)
        {
            if(coluna.getCellType() == 1)
            {
                System.out.print(coluna.getStringCellValue() + "|");
            }
            else {
                System.out.print(coluna.getNumericCellValue() + "|");
            }
        }
        System.out.println("===================");
    }
    wb.write(arquivo);
    wb.close();
    return arquivo;
}
I ran the test using poi 3.17 and it worked normally. In case you haven’t been able to solve the problem, if you can,.
– Fagner Fonseca