Questions tagged [apache-poi-4]
108 questions
1
vote
0 answers
Problem create chart from scratch with Apache Poi
When I create a chart from scratch and add it to a slide within a PowerPoint using Apache Poi the corresponding XSLFGraphicFrame shape get created and added to the XML but it doesn't get added to the getShapes() list within the slide, things that…

SquapaleDev
- 11
- 4
1
vote
1 answer
How to split the row in apache POI header
I am trying to create table ind Microsoft Word using apache poi. But I am not being able to generate the header attached for the table. Any suggestions, i can create the attached header using apache poi?
I am able to created the entire table but…

Misthi
- 33
- 10
1
vote
0 answers
How to get coordinates of boby elements in the document?
I have a docx document which consists of some paragraphs and I have to get coordinates (x, y) of this elements from left top corner of document.
I find something like this:
try (InputStream is = new FileInputStream(path)) {
XWPFDocument doc =…

John
- 1,375
- 4
- 17
- 40
1
vote
1 answer
How to create checkbox and input text fields in docx document?
I'm a new in apache poi could anyone help me with creating checkboxes and fillable fields(plain text, rich text) in docx document? I saw xml representation of docx and I think that is element describe checkbox
…

John
- 1,375
- 4
- 17
- 40
1
vote
2 answers
How to fix "We found a problem with some content in 'abc.xlsm'. Do you want us to try to recover as much as we can?
I have the following method (createAdditionalSheetsInExcel) in my code which tries to create additional sheets for a particular scenario (runOutputNumber > 1). It ends up creating an excel but the problem is when you try to open the excel you end up…

Sai Haridass
- 344
- 2
- 11
1
vote
1 answer
How to generate editable Stacked-bar-chart using apache poi 4.0.1 and java?
I want to create stacked bar chart using Apache poi 4.0.1 and Java language for Excel
The output excel file's extension should be .xlsx
The generated chart should have Chart title and Data Labels
The generated chart should also be able to show the…
user10907060
1
vote
0 answers
Get current height of xwpf row, cell, paragraph
I am using XWPF to read .docx file which contain a table. In this table I get row then cell then I add a paragraph inside and in this paragraph I add multiple Run (with different style of font)
My question is (I know I don’t have posibility to get…

ebeg
- 418
- 1
- 4
- 17
0
votes
1 answer
apache poi formatting issue(accounting)
I am currently working on creating .xlsx file using apache poi. my only issue is when I open my excel it always shows as Custom instead of Accounting. The cell formula or any integer value in cell in excel it shows as Custom instead of Accounting.…

Prashant Naik
- 105
- 1
- 8
0
votes
0 answers
Using Apache POI replace an XWPFParagraph with another XWPFParagraph at the same position in the document
I am using Apache POI to edit Docx documents. What I am trying to achieve is to rearrange an XWPFParagraph's runs by adding new runs to the XWPFParagraph, but inserting new runs to a paragaph is actually adding runs to the end of the paragraph. I…

Furqan Ahmed
- 9
- 3
0
votes
0 answers
Finding word document element page number in Apache POI
Is there anyway in which I can calculate and findout the page number of the element? Because I need this feature as to construct a Table of Content(TOC). I know that Apache POI has got word TOC support, but I need the TOC in a table format which is…

NoelToy
- 1
0
votes
1 answer
How to convert pivot table to HTML
I have an Excel in xlsx format. It has two sheets, TransactionDetails and Pivot. Pivot sheet contains pivot tables generated from data in TransactionDetails sheet. How can I convert the pivot sheet into HTML?
I have tried using Apache POI and POI is…

abhijit.bhatta
- 73
- 7
0
votes
0 answers
Replacing contents of word document using Apache POI
I am using Apache POI (version 5.2.2) Java library to replace text placeholders in word documents. One of my task is to replace/edit text put in a rectangle shape. I am using the code below and it successfully works, the only issue that I am facing…

Furqan Ahmed
- 9
- 3
0
votes
0 answers
How to extract text from a placeholder in docx file using Apache POI
I am working on Apache POI to edit word documents. My main task is to fetch the text and placeholders from the paragraphs and tables and they are working fine. In one of my clients document, there is a placeholder and inside that placeholder there…

Furqan Ahmed
- 9
- 3
0
votes
0 answers
How to split the producing XLS sheet to look like the template shown in apache.poi
I am using apache poi
HSSFWorkbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet();
.......
.......
And then I do the rest of my code. My data is looking good. But my rows are too long.
So the client want us to split the sheet…

prain99
- 21
- 5
0
votes
1 answer
java apache poi bar chart populate negative bar with color
I'm trying to populate bar chart for positive and negative values using apache poi. I'm able to populate positive bar with different color but now able to populate negative bar with different color. It is coming empty bar. I'm referring this…

Anil Jagtap
- 1,740
- 4
- 27
- 44