Skip to content
Advertisement

Tag: apache-poi

How to copy excel sheet to the same worbook?

I’m trying to copy an existing excel sheet to the same workbook(it contains 3 sheets ) in java using Apache poi . Here is what i did : after running this code, the workbook contains always 3 sheets , the “copy_file” is not created, i’m not getting any errors or exceptions . any idea ? Answer You need to open

Update Cell in excel file using Java Apache POI

I’m trying to update an empty cell in an existing excel file using Java ( Apache POI ), here is the code I wrote, I don’t get any errors and the values aren’t changed either . I get ” its null 2 ! ” in console . Any solutions? Thanks 🙂 Answer You need to open an output stream and

Receiving Cannot get a NUMERIC value from a BOOLEAN cell when exporting XML map

I have a workbook with an XML mapping defined (I am using POI 4.1.2). A mapped cell contains a formula which evaluates to boolean: =AND(B70=””;B71=””; B50=”No”) I try to export the XML mapping with the following code: The last line results to the following exception: java.lang.IllegalStateException: Cannot get a NUMERIC value from a BOOLEAN cell at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1035) at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:319) at

Multiple Excel file in sprint boot

IS there the way to create multiple excel file instead of multiple worksheets through spring boot? I have been using apache poi for generation of excel. } When i try to repeat the code of exp.export(response) , it gives me the 1 excel and for the next excel it says The workbook already contains a sheet named ‘Report’. I thought

Advertisement