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,832
questions
0
votes
0
answers
25
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
31
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
36
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
35
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
42
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
57
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
30
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....
-2
votes
0
answers
37
views
Read the excel value using apache POI [duplicate]
When I try to read the excel value using apache POI, my logs show the following error/stacktrace. The value to read is alph+numerical+specialcharacter. e.g. Name@123
code -
String abc2=...
0
votes
0
answers
22
views
Data flow getting the internal server error while connecting Apache poi file
While I'm trying to connect the excel sheet getting the internal server error, Due to that i am not able to download the excel sheet and not able to validate the code
Need to connect the gcloud excel ...
0
votes
0
answers
42
views
Apache POI Dependency in Maven Project : java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.ooxml.util.DocumentHelper
I want to export an xlsx file in a Java project, so I added the Apache POI libraries. However, it doesn't work. I removed the xerces dependency and it works, but it causes an error in the existing ...
1
vote
0
answers
38
views
Casting to a Member Type in Scala
I'm using the Apache POI library 5.2.3 in Scala to create a line chart in a PowerPoint presentation.
// createData returns XDDFChartData
var chartData = chart.createData(
ChartTypes.LINE,
...
0
votes
1
answer
34
views
Image in front of text - CENTER
I have the following XML
CTGraphicalObject graphicalobject = drawing.getInlineArray(0).getGraphic();
long width = drawing.getInlineArray(0).getExtent().getCx();
long height = drawing....
-1
votes
0
answers
40
views
Thread execution inside aws lamda
I am having an lamda function that is calling for creating a excel.
When call hit first thing i am creating an entry in status table and returning status id as response
I have a poll api that can be ...
2
votes
1
answer
54
views
Apache POI Word - Line between columns
I already have the columns created. I would like to put a line between them, as is possible in Word.
Line Between
How do I set it using Apache POI?
CTColumns coluna1 = sectPr.addNewCols();
coluna1....
0
votes
2
answers
86
views
How to Compute Left Indentation for Numbered Paragraphs in OOXML (document.xml) from a DOCX File?
I'm working with a DOCX file and examining the document.xml (OOXML) file to determine the left indentation of paragraphs. Specifically, I'm trying to calculate the distance from the left margin to the ...