Questions tagged [apache-poi-4]
108 questions
0
votes
1 answer
How to set Fill properties of Chart Area in Apache POI to "NO FILL"?
I created a chart by using Apache POI as below:
// creata anchor
XSSFDrawing drawing = sheet.createDrawingPatriarch();
XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, FROM_COLUMN, FROM_ROW, TO_COLUMN, TO_ROW);
// create…
Meysam Karimi
- 97
- 8
0
votes
1 answer
Apache POI and CellType
I am a little bit lost with version of
org.apache.poi
poi-ooxml
I tried version 3.17, 4.0.0 and 5.0.0.
if (c.getCellType () == CellType.NUMERIC.getCode())
{
}
or
if (c.getCellTypeEnum () ==…
chris01
- 10,921
- 9
- 54
- 93
0
votes
1 answer
How to add more than two y-axis (verticals) to the Line Chart in Excel using Apache POI in Java?
Currently i created and saved a Line Chart in java using Apache-POI 4.0.0 based on Apache POI - Cant get Line Chart Values to appear in the Secondary Axis . Successfuly i was able to generate an output like below image in Excel file:
And following…
Meysam Karimi
- 97
- 8
0
votes
0 answers
Apache POI 3.17 CustomProperties at sheet level
OPCPackage opcpackage = sheet.getWorkbook().getPackage();
int i = opcpackage.getUnusedPartIndex("/customProperty#.bin");
Im using Apache poi -3.17 and ooxml-schemas-1.3.jar and want to write Custom properties to Worksheet
and Im Stuck with…
h tushar
- 11
- 3
0
votes
0 answers
Why not able to write data in this excel file using Apache POI?
I'm working on some task where I need to open the excel file and write some data in that file. I'm using apache POI for this task. I'm able to write on some other file basically by creating the different files. But with this file, I'm not able to…
Anshu Kumar
- 633
- 7
- 12
0
votes
1 answer
Change the text direction using Apahe Poi
How to change the direction of text in a table in a Word document created using Apache Poi?
example
Александр
- 9
- 1
0
votes
1 answer
xmlbeans: deep equals not implemented
I'm trying to use org.apache.poi.xwpf.usermodel.XWPFNumbering.getIdOfAbstractNum(XWPFAbstractNum abstractNum) to test if the given abstractNum exists or not. This call ends up in:
CTAbstractNumImpl(XmlComplexContentImpl).equal_to(XmlObject) line: 79…
Markus Pscheidt
- 6,853
- 5
- 55
- 76
0
votes
2 answers
Apache POI, align text to left and other text to right in same row
I'm using Apache POI to create excel export file (.xlsx with XSSF).
I'm having one issue with borders between cells.
I need to have few cells merged into one row and in that row I need to have one text aligned to the left, and another text aligned…
whatamidoingwithmylife
- 1,119
- 1
- 16
- 35
0
votes
1 answer
wordprocessingml footnote number style (superscripts)
I just added a footnote to the word document.
but it seems little bit wierd.
Footnote numbers are usually entered as superscripts, but not now.
How can I insert a footnote number as a superscript?
this is my code..
r = p.createRun()
…
happygreen17
- 43
- 6
0
votes
0 answers
Using apache poi in java to generate excel line chart
i am using apache poi to generate line chart in excel. I have two sets of data, and it works well, please look at picture1.
picture1
When i use only one set of data, it generate picture2, and you can see the right side of the picture, it show…
user1434702
- 817
- 1
- 14
- 33
0
votes
1 answer
Set image position and tilt into a word .docx document using POI XWPF
I have added following picture in word document using XWPF addPicture ,
XWPFParagraph p3 = document.createParagraph();
XWPFRun r3 = p3.createRun();
imgFile = "C:\\poi-3.9\\pictures\\Picture4.jpeg";
try {
r3.addPicture(new FileInputStream(imgFile),…
exceed007
- 101
- 3
- 10
0
votes
2 answers
Reading excel using Tablesaw is causing OutOfMemoryError
I am using following api to read data from excel as a Table: https://jtablesaw.github.io/tablesaw/gettingstarted
The code is as follows:
XlsxReader reader = new XlsxReader();
XlsxReadOptions options =…
Naresh Chaurasia
- 419
- 5
- 21
0
votes
1 answer
org.apache.poi.util.XMLHelper is missing newXMLReader() method
As specified in https://poi.apache.org/apidocs/4.1/, I am not seeing in newXMLReader() method org.apache.poi.util.XMLHelper, Just want to cross check if I am missing anything here.
storia321
- 381
- 2
- 22
0
votes
1 answer
Apache POI 4.1.2 Migration issue with CELL_TYPE_NUMERIC
I had POI 3.17 before in my project and as the black duck scan resutl was shwoing vulnerability I had to switch to 4.0 or better. After I downloaded the 4.1.2 jar ( THIS IS A ANT PROJECT). I am having build issues which says this :
Compiling 500…
Ayman Akief
- 1
- 1
- 3
0
votes
0 answers
Cannot read chinese characters in an excel file
I have developed a java application that will read an excel file containing chinese characters and convert it to multiple CSV files. The file is as below:
public class SplitterBean {
public static final Logger LOGGER =…
Anirban
- 925
- 4
- 24
- 54