Questions tagged [apache-poi-4]
108 questions
2
votes
1 answer
The method setFillForegroundColor(short) in the type CellStyle is not applicable for the arguments (XSSFColor)
I am trying to get custom colours to work in Apache POI but I got into a small problem. So far I have been using IndexedColors, but as a palette, it is pretty drab. Thus using an RGB format for colour selection would help me to make my spreadsheets…
JoffJoff
- 145
- 1
- 12
2
votes
2 answers
How to fix the Java Compiler error in Android Studio when using Apache POI
I'm developing an Android App in Android Studio with Java Coding. In this app when user clicks a button an excel file gets saved in external storage with some data.
For this I'm using Apache POI 4.1.0. I have added this in dependencies, but when I…
Sabir Syed
- 422
- 3
- 19
2
votes
1 answer
How to Use Apache POI to create excel hyper link that links to long url
Excel is having a hyper link size limit of 255.
Now I'm using Apache POI to programmatically fill in a excel, but with a s3 pre-signed url that is much longer than 255 characters, 1350+ in length.
And when I click the hyper link created in excel,…
james
- 191
- 3
- 9
2
votes
1 answer
Apache poi migration to jdk 11 issue
I am currently migrating an application from jdk 8 to 11 but I have some issue with Apache Poi library. Some classes, methods and constants were removed and I am unable to find a migration guide from their website. The previous version was 3.13 and…
akuma8
- 4,160
- 5
- 46
- 82
2
votes
2 answers
Getting Error using Apache Poi 4 with Java 10
I want to mention that, the whole process runs absolutely fine, when I am using Java 8. But when I am trying the same process with Java 10 I am getting a big Error Message.
I know that poi 3.17 has problems with Java 10, but since…
Javed Was
- 56
- 1
- 5
1
vote
1 answer
Unresolved dependency when using iceblue spire appi
I want to compare two docx files and for this reason I am using Ice blue spire api which compare two documents, and checks whether the two documents are identical or not. I am using the following gradle dependency to my gradle project.It is saying…
Furqan Ahmed
- 9
- 3
1
vote
1 answer
How to fix "Some formula symbols might not be displayed correctly due to missing fonts Symbol, Windings..." for an XLSX generated with Apache POI
I have the following code:
XSSFFont font = createFont(workBook);
font.setColor(IndexedColors.WHITE.getIndex());
font.setFontName("Arial");
font.setBold(true);
XSSFColor BLUE_WAVE = new XSSFColor(new byte[]{ (byte) 60,
…
carlspring
- 31,231
- 29
- 115
- 197
1
vote
1 answer
What is the difference between Cell, SXSSFCell and XSSFCell?
From the documentation I came to know that SXSSFCell and XSSFCell are the implementing classes of Cell, but I am trying to understand the difference between different implementations. If I want to export data to excel, so which Cell implementation…
Mohsin M
- 239
- 7
- 20
1
vote
4 answers
Getting :: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.put(Ljava/lang/Object;)V
I am using the Poi(poi, poi-ooxml-schemas,poi-ooxml-4.4.1 ) api for export-import operation, and now upgraded xmlbeans from 3.0.2 to 5.0.1 version, after upgrading the xmlbeans-5.0.1 getting error while creating new SXSSFWorkbook(100);
....…
Rambabu Pudi
- 33
- 1
- 12
1
vote
1 answer
Binary file encryption with Apache POI
I'm trying to apply encryption to a binary xls file with Apache POI.
While I can successfully encrypt xml based files, if I encrypt a binary one I can't open it and I get the wrong password error.
This is my code:
@Test
public void testEncryption()…
firegloves
- 5,581
- 2
- 29
- 50
1
vote
0 answers
How to read bookmarks that are outside of a paragraph with Apache POI XWPF
Sometimes, when defining a bookmark in a .docx file (using Word 2016 in this case), the bookmark start tag () is placed by MS Word before the start of the paragraph. Unzipping the .docx file reveals the following:
Markus Pscheidt
- 6,853
- 5
- 55
- 76
1
vote
3 answers
How to correctly convert into a Date object this "strange" cell value retrieve parsing an Excel using Apache POI?
I am going crazy trying to parse an Excel from Java using Apache POI and I ami finding the following problem parsing a specific column containin dates.
This is the column into my Excel file:
As you can see this column contains date fields but some…
AndreaNobili
- 40,955
- 107
- 324
- 596
1
vote
1 answer
how to get Image and data in same cell in xssfworkbook
I am trying to insert iamge and some data in same cell using apcahe poi xssf work book.
I have tried something Like below
Workbook wb = new XSSFWorkbook();
XSSFSheet sheet = (XSSFSheet)wb.createSheet();
Row row =…
phani kumar
- 117
- 10
1
vote
1 answer
Edit header in dotx/docx file
I am currently trying to generate a new docx file from an existing template in dotx format. I want to change the firstname, lastname, etc. in the header but I'm not able to access them for some reason...
My approach is the following:
public void…
IvanNickSim
- 126
- 3
- 13
1
vote
2 answers
POI 4.1.1 setCellFormula not showing final value
Previously I was using POI 3.1.7 with setCellFormula without any issues. Now I've migrated to 4.1.1 and noticed that although the cell sets the formula correctly, it doesn't display any value (e.g the cell is set to "Accounting" format, the cell…
huffie
- 11
- 2