Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 months ago. Improve this question ExcelToJson converter The method works correctly, but at the output it produces an array, which I then need to write to the database. This array
Tag: excel
Excel file gets corrupted after launching an executable jar
I have an Eclipse project with the following code that uses Apache POI. When I launch it from Eclipse, it works properly. Since I created the executable jar, when I use it, the Excel input file passes from 9 to 1 kB and it won’t open anymore. [EDIT: since I was asked: the file is only read, I never write
APACHE POI set formula by column name format
Have small problem when I want to set formula to cell by column name format. Let me show example: In excel file I can do something like this =[Name] So value from colmn B is copied to column A But when I try to do something like this in Apache POI I get exception: Parse error near char 0 ‘[‘
Java Apache POI Bug
While working with the Apache POI Implementation I ran into a strange behaviour. I cannot explain the cause, so if anybody can give some hints, I would love to hear them. It is not even a big blocker for the problem that I was solving – at this point it is more a curiosity thing. So here it goes: As
Protect a SXSSFWorkbook (Excel) and convert it to a byte array
I am working on a Java function which is expected to return a protected Excel file (xlsx) in byte array. I found a solution which used the Encryption support of Apache POI: How to Protect Excel Workbook Via SXSSF? However, OutputStream cannot be cast into ByteArrayOutputStream. I tried to find a way to convert the OutputStream into ByteArray but all
How to write dates in Apache POI which would be filtered properly
I have a block of code which write data to .xlsx file. I need to write some date in “dd.MM.yy HH:MM” format. All is work properly, but when I try to open result file and test filter work, I got issue with that. Filter perceives dates just like strings, instead of dates, and I can’t get filter with year and
Java and org.apache.poi while reading excel line 47 is skipped
Using Java 1.8, org.apache.poi 5.1.0 and org.apache.poi.ooxml 5.1.0. I have an excel file that consist of 54 rows. I read through this file in blocks of 5 lines. If I get to line 47 it skips that line and gives me the first line of the new block while it should give me the first empty line above the now
Formula recalculation in excel template POI JAVA
I have an Excel template file with formulas in some cells, I open it and fill in the values using POI. The problem is that the formulas aren’t automatically recalculated. But if I open this file and click on a cell with a value, it recalculates that cell. I found two ways to solve this issue in the documentation, but
remove specific legend apache poi excel graph XDDFChartLegend
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 XDDFChartLegend which
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