Questions tagged [apache-poi]
Apache POI is a Java library for reading and writing various Microsoft file formats, especially Office related ones. It supports OLE2 and OOXML based formats, such as XLS, XLSX, DOC, DOCX, PPT and PPTX as well as a few others.
apache-poi
9,836
questions
1
vote
2
answers
96
views
Converting excel file from xls to xlsx using Java programming
I'm a junior software engineer. Currently, I am struggling to convert an excel file from xls to xlsx without losing formats/formulas. I need your advise. I have been trying a few solutions using POI, ...
0
votes
0
answers
28
views
How to find a excact value from a cell containing NamedRange while upload excel in Java?
I am working on importing a data from a Excel Sheet when a user tries to upload (.xlsx) file. For one particular field Field1 - 2233 its using a Named Range to get the actual value and not the named ...
0
votes
0
answers
34
views
Convert from WordProcessingML CTPicture to DrawingML CTPicture?
I have documents that have pictures in them, but none of them are being identified by XWPFRun.getEmbeddedPictures(). I can, however, get a list of them with XWPFRun.getCTR().getPictList().
The problem ...
0
votes
1
answer
41
views
How to merge with Apache POI and keep spacing and formatting
XMLSlideShow ppt = new XMLSlideShow();
// Creating an empty presentation
if (!powerpoints.isEmpty()) {
for (String arg : powerpoints) {
FileInputStream ...
-1
votes
0
answers
39
views
How to Efficiently Export Large Data Sets to Excel in Chunks with Spring Boot and S3?
I need to export a large volume of data (over 1 million records) from an Oracle database to an Excel file using Spring Boot. My application has limited JVM memory (1 GB max), so I want to process the ...
-1
votes
0
answers
25
views
Read an Excel file using OPCPackage
I am trying to read an excel file in order to fill my SQLite database with it's data, but when I try to open the file using **OPCPackage **or FileInputStream it won't open even the file is exist
I'm ...
0
votes
0
answers
38
views
Trying to use Apache POI ooxml in Android studio but keep getting the same error about log4j
main ERROR Unable to load services for service class org.apache.logging.log4j.spi.Provider java.lang.NoSuchMethodError: No static method metafactory(Ljava/lang/invoke/MethodHandles$Lookup;Ljava/lang/...
-1
votes
0
answers
47
views
Apache POI Excel Export: Inconsistent Behavior Across Different Environments with Large Result Sets
I am trying to export a large Excel file using Apache POI (v.4.1.2) and Java (1.8). However, I am facing a particular problem. I have 3 environments:
Local environment
Test environment
Production ...
0
votes
0
answers
48
views
excelWB.write(fileOut); gives IllegalArgumentException
I am trying to use an excel to write the into new file using Apache POI. This is the method code,
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import ...
0
votes
2
answers
41
views
Is a Neo4j UDF compatable with Apache POI?
I'm using Neo4j v 5.21.0 Enterprise on a PC. I've created a User Define Function to create Excel files from a Neo4j cypher query. It works very well when it runs from Maven, producing the Excel with ...
0
votes
0
answers
40
views
Do i need formula evaluation while SAX parsing of a XLSX file
In XLSX file, <f> tag is used for formulas and <v> tag seems to be used for the value computed of that formula in some spreadsheet software. I m writing a SAX Parser for xlsx reading. So ...
0
votes
0
answers
44
views
Unable to write to the Defined Name variable using jxls 3.0
I have below Defined Name variable in excel template.
Name Value RefersTo Scope
period Period: ${data.startDate}-${data....
-1
votes
0
answers
44
views
When running the main class using mvn exec:java, classes in rt.jar are not referenced
My java version is 8.0.372-zulu/zulu-8, maven version is 3.6.0
I have a problem that really bothers me.
I set up a maven project and use apache poi to process excel.
The code is simple as I just ...
0
votes
0
answers
61
views
How to use XSSFFormulaEvaluator to evaluate formula?
I need to use POI to handle a Excel .xlsx file in Java.
There is SUM formula in my Excel template. (e.g. =SUM(C4:C7))
In the beginning, I use a existed method in our program, but it end in line 3 ...
0
votes
0
answers
37
views
java.lang.InstantiationError: org.apache.xml.security.signature.XMLSignatureInput
getting the below error message with Apache POI and the xmlsec
java.lang.InstantiationError: org.apache.xml.security.signature.XMLSignatureInput
at org.apache.poi.poifs.crypt.dsig.services....