i am using apache poi 5.0.0 version i have generated a graph in excel using the data and i am able to see the legends in the bottom of the graph. There are six legends shown. Now i want to remove two specific legends without removing them from the graph. There seems to be no functions available in XDDFChartLe…
Tag: excel
How to remove Spire.XLS signature from pdf File?
I’m working on java, i have an excel file named “file.xlsx” that i want to convert to pdf using Spire.XLS , this is the code i wrote for that : The pdf file is generated but with a signature : Evaluation Warning : The document was created with Spire.XLS for Java , i’m wondering about h…
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 ? …
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.l…
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 …
Workbook in java to find all words in sheet starting with “$” in a xlsx file
I’m working on an excel sheet in which I have multiple columns, which holds multiple text values including variables starting with $. I’m writing a Java code using workbook to read xlsx files. Since I have never used it before, may someone tell me how to achive this task using same. My code struct…
Executable JAR execution different from eclipse execution
I have created an App using Java which treats excel files using Apache POI. The problem is that when I run the code from eclipse, it works fine, but when I made an executable jar for the app (Using eclipse export executable jar option), the jar is working fine but the results are different, even the size of t…
Java streams collect excel CSV to a list filtering based on the sum of a column
Suppose we have an excel spreadsheet that looks like: How can I be able to gather to a list of only the IDs of the people whose status count is a sum greater than 0, and if it is 0 or less then discard it. So in the excel spreadsheet above, the list in java should look like: List<Integer> =
Algorithm to show how far away a value is from another
Disclaimer: This is a very very difficult question about mathematics and algorithms (in my opinion) – so respect to anyone who makes this. I admire you. I would like to evaluate the performance of my employees. I would like to do this by measuring the following parameters as percentages of the amount of…