cannot find symbol Workbook.close()

Question

I saw multiple questions with this header but didn't get my answer.

 private void createHandBackFile(XSSFSheet sheet, String programId, XSSFWorkbook workbook) throws IOException {
    String output = "C:\\Users\\muddassirr\\Downloads\\Personal\\STORE\\Output";

    File file = new File(output + File.separator + programId);
    if (!file.exists()) {
        file.mkdirs();
    }
    int noOfColumns = sheet.getRow(0).getPhysicalNumberOfCells();
    for(int i = 0; i < noOfColumns; i++) {
        sheet.autoSizeColumn(i);
    }
    FileOutputStream outputStream = new FileOutputStream(new File(output + File.separator + programId + File.separator + "HAND_BACK.xlsx"));
    workbook.write(outputStream);
    outputStream.close();
    workbook.close();
}

There is no compilation error. But As I run I get runtime error saying

java: cannot find symbol
symbol:   method close()
location: variable workbook of type org.apache.poi.xssf.usermodel.XSSFWorkbook

possible dup of https://stackoverflow.com/a/33802626/3694269 — Shanu Gupta, May 21 '18 at 06:47
Check your class path and look for duplicate imports of different versions of the POI libraries. [This is not allowed.](https://poi.apache.org/faq.html#faq-N10204) — Axel Richter, May 21 '18 at 07:32

Muddassir Rahman · Accepted Answer · 2018-05-22T06:17:54.233

5

I got the answer. This dependency was missing in pom.xml

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.17</version>
    </dependency>

edited May 22 '18 at 06:17

answered May 22 '18 at 03:37

Muddassir Rahman

976
1
9
20

1

@AxelRichter actually I had changed to 3.17. – Muddassir Rahman May 22 '18 at 06:17

cannot find symbol Workbook.close()

1 Answers1