I have a big issue on a Java tool I work with. Every time I try to upload an xlsx file that is marked as “Restricted with protection”, I got the same exception There is no password on that excel file, it’s just an upgrade of MS office that apply this kind of restriction for every file that i…
Tag: excel
apache poi convert excel to json [closed]
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 7 months ago. Improve this question ExcelToJson converter The method works correctly, but at the output it produces an array, w…
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 writ…
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 conver…
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 filte…
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 docu…
How to use Array Spilling with Apache POI 5.1.0
Using Apache POI to generate excel files, is it possible to prevent Excel from adding the implicit intersection operator (@) inside formulas ? For instance, using the following code, what I want to do is copy all the values inside the columns from A to K, using Excel Array Spilling behaviour. However, when op…