Questions tagged [apache-poi-4]
108 questions
0
votes
0 answers
How to avoid ApachPoi and Excel from rounding my Double values?
When extracting data to Excel from my Java code, i got a Double value to export, I'm doing like this :
Cell cell = row.createCell(4);
cell.setCellValue(rowTotal);
cell.setCellStyle(style);
this is working fine but rounding always my values to the…
Sofiane
- 473
- 1
- 6
- 13
0
votes
0 answers
Skipping undesired rows from excel file using Apache POI
I am working on Apache POI to extract data from MSEcxel files. What I need to do is to combine selective rows into a single string and generate QR code and further generate a word document and put this data (both generated string and QR code) into…
Ameer Moaaviah
- 1,530
- 12
- 27
0
votes
1 answer
Apache poi dependency version issue -java.lang.ClassNotFoundException: fr.opensagres.xdocreport.converter.XDocConverterException
I am trying to generate excel sheets, PDFs, and word documents using apache poi. Following are the pom entries I used in the code
org.apache.poi
…
Misthi
- 33
- 10
0
votes
1 answer
Is there a way to create a split plane horizontally using the Apache POI library in Java? [EXCEL + APACHE POI]
using the createSplitPlane() method in XSSFSheet it is only able to do a 4 pane split. Is there a way to do a 2 plane split instead horizontally?
Yashik
- 3
- 2
0
votes
0 answers
Runnable Jar File not running because coultnt read excel datas..but works fine in Eclipse
I am trying to create an executable jar file of a Maven Project in Eclipse.was using testNG in the maven project..so created a runner class with main method and exported runnable Jar File..Now it's not Running ..
i feel it's not reading datas from…
Achilles 1403
- 1
- 1
0
votes
0 answers
How to change the content of the table in the Text box of docX file
How to change the content of the table in the Text box of docX file?When xmlcursor.getobject () instanceof XmlAnyTypeImpl is instanceof XmlAnyTypeImpl, I cannot change the contents of the table in the text box. How can I change the contents of the…
大驴大驴
- 1
- 1
0
votes
1 answer
HCL Domino -11 - Java - Apache POI - NoClassDefFoundError error while converting docx to PDF
I have generated docx file through template using Apache POI. I am trying to convert it to PDF file. Below is the code and the libraries. I am using Apache POI 4.1.1.
InputStream is = new FileInputStream(new File(filepath));
OutputStream out = new…
Keertika
- 59
- 6
0
votes
0 answers
HTML string to RichText in an excel textbox using apache POI
Given a HTML as string like this.
This is a text Message.
- UL 1
- UL 2
- UL 3
- First…
Sam Si
- 163
- 13
0
votes
1 answer
Issue while printing the decimal values when reading from excel using java
In Excel I have these decimal values:
TS
BS
5.60
4.10
10.00
10.00
10.00
10.00
10.00
10.00
While parsing, it shows different…
XXXX
- 65
- 1
- 9
0
votes
1 answer
I want to copy specific columns from Excel file with extension, ".xlsx" using java (XSSF format)
I am working on a project where I have to copy data from Sheet1 to Sheet2.
I am able to create new file i.e. file2 and copy the whole data from file1 to file2.
My Requirement # I want to copy specific columns in specific sequence from file1 and…
Debamita
- 1
- 1
0
votes
0 answers
The file format and extension of .xls don't match -- apache-poi 4.1.2
I am creating xls with apache-poi version 4.1.2. when I do with junit it is working correctly but if I use tomee with container then the generated file is showing an error like
The file format and extension of .xls don't match
Java…
0
votes
1 answer
How to extract data from Excel sheet using Apache POI in java(lookup framing)
public class Array_Learn {
public static void main(String[] args) {
try {
FileInputStream ExcelFile = new FileInputStream(new File("C:\\Users\\Anbu.B\\Desktop\\POI-Test\\mediTask.xlsx"));
XSSFWorkbook book1 = new…
ANBU RAJA
- 3
- 4
0
votes
0 answers
How to read columns in excelsheet using java?
I have an excelsheet in which I have data something like this ,my requirement is to read the excelsheet and get the screen_name having type dropdown , this is my sample input and I have also added output which can be used as a refrence
Seq …
Divyesh Kumar
- 37
- 11
0
votes
1 answer
getting a blank line as first line in apache poi spreadsheet creation
Recently upgraded from poi-2.5.1 to poi-4.1.2 and what is happening is that a blank line is being inserted as the first line in the resulting .xls file. This was determined from comparing the file that is created from poi-2.5.1 to the one generated…
rwilkins29
- 1
- 2
0
votes
0 answers
XSSFCellStyle.BORDER_THIN - (BORDER_THIN cannot be resolved or is not a field) in poi 4.1.2
I have upgraded apache POI from 3.9 to 4.1.2 version. Getting error for XSSF font, styles, hyperlink, cell range address etc., Help me what are the changes required to do for upgrading to this version.
Maven dependency added,
…
ARUN KUMAR
- 1
- 1